PDA

View Full Version : mysql backup


pyreneeen
11-23-02, 01:46 PM
I would like to backup my database. When I issue the mysql command:
BACKUP TABLE mytable TO 'mypath'
I am getting the following message:
Access denied for user: me@1.1.1.1 (Using password:YES)

1.1.1.1 is an IP address

Somebpdy knows how to do a backup in this way? Otherwise, what are the alternatives?

Paul E
11-23-02, 02:42 PM
I backup my DB on the webhost using a cron job as explained in this thread (http://forum.powweb.com/showthread.php?s=&threadid=1597) . The DB can also be downloaded (backup) using phpMySQLadmin, MySQL-Front (my personal favorite), or other MySQL access software.

I don't know how to back it up using the commands that you mentioned, sorry.