View Full Version : connect to server n done backup automatic..

09-18-2006, 04:07 PM
how can i using a machine (XP os) that connect to server (redhat) process a backup of mysql database??? the backup file must save to my machine..

isnt possible to done it??? how can i dont it?

09-18-2006, 04:18 PM
you would use mysqldump or mysqlhotcopy to do the dump on the server and have to ftp that file to your computer.

09-19-2006, 12:20 AM
any other solution i can backup the database through my comp access to server(in automode)??

09-19-2006, 12:43 AM
since the data isn't on your computer I don't think you can run something on your computer to back it up.

09-19-2006, 08:35 AM
if the server allows remote mysql connections, you could run mysqldump on your machine, but it would be much, much slower than running it remotely and using ftp