Taking Backup of MySql automatically

[beatnik_abx]

Sponsored Links

Hi,

I want to know how to take backup of MySQL database on a lo0cal machine & on the server automatically?

If you guys know any application then please let me know about the same.

[madjack]

I think you need to go through this tutorial by MySql
http://dev.mysql.com/doc/refman/5.0/...-recovery.html

I hope this helps.

[Raffaele]

A MySQL dump is a bit slower than a raw backup because it creates all the SQL queries required to create the tables of that database, as well as all the insert queries required to place the information back into the database's tables.

If you want to perform the mysql dump manually, without the assistance of your hosts control panel, then run SSH to your web server and do the following (taken from MySql.com):

* mysqldump --tab=/path/to/some/dir --opt db_name

[beatnik_abx]

Is there any Software I mean application that will enable me to backup my SQL database periodically?
I am on Mac environment. (Windows based GUI will also do.)