Jump to content


Photo

Help with mysqldump


  • Please log in to reply
1 reply to this topic

#1 everythingandtwo

everythingandtwo
  • Members
  • Pip
  • Newbie
  • 6 posts

Posted 24 May 2003 - 04:54 PM

I\'m trying to backup a database that I have located on one server to another server on my network. So far I haven\'t had any luck. I can back the database up to a file locally, but not across the network. Here is the syntax I\'m using along with the error message...

C:mysqlbin>mysqldump -u webuser -p pass --opt fonemail | mysql 

--host=10.192.212.34 fonemail_backup

ERROR 1044: Access denied for user: \'@OSPSDEV3\' to database \'fonemail_backup\'

I\'ve created a DB called fonemail_backup at the remote location and I have granted all privileges to webuser@OSPSDEV3 however it is still saying access denied. Can anyone help me out? Thanks!

- Brad

#2 barbatruc

barbatruc
  • Members
  • PipPip
  • Member
  • 28 posts
  • LocationMontreal, Quebec, Canada

Posted 26 May 2003 - 12:49 PM

Is the access granted elsewhere than from localhost for this user? Use your IP for this field or simply % to allow connections from everywhere for this user.

JP.
Unfortunately, PHP \'empowered every moron with a copy of Windows notepad to be \"web programmers\". (...) Give PHP a real INFRASTRUCTURE. Use PEAR!!!\'




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users