Best Way To Backup To A Local Machine?

[3dColor]

I would like to schedule nightly backups of my database from my web host to my local machine, but I am not sure the best way.

I have been trying unsuccessfully today to use MySQL Admin with Vista Task Scheduler.

The thought is I use Vista Task Scheduler on my local machine to run MySQL Admin at night right before MySQL Admin runs it's scheduled backup.

But I can't figure out how to get the Task Scheduler to connect to the database after it starts the MySQL Admin program.

 

[Kozusnik]

I use this on Linux, but it should work on the other OS.

Schedule this to backup...

mysqldump --add-drop-table --extended-insert --quick --host=server_name_or_ip --user=db_username --password=db_password database_name > ./db_file.sql

This is the restore...

mysql -udb_username -pdb_password database_name < ./db_file.sql

I use it in conjunction with php and/or shell scripts to give the db_file.sql a date/time stamp. Then I also do the cleanup from the script.

Mark

 

[3dColor]

Mark,

What shell scripts do you like to use for this. Would AutoIt work?

 

[3dColor]

I figured out how to use MySQL Admin to do this with the task scheduler. My issue was a bad password.