MySQL Databases

Applications Programming
1

Hello all again,

How do you guys backup your MySQL databases?

I have a few programs that have an default back up that make an .sql file which is great but I also use OpenX which runs on PHP and has a database. That does not have an auto-back-up feature so do I just download the database and that's it?

Any recommend for the tool?

Thanks

2

I normally use mysqldump

3

Agreed. Backing up the binary database files is not a good idea since your version of mysql may change and make them incompatible. But if you use mysqldump to back everything up as text, it will remain compatible.

It will also allow you to pick and choose which databases and tables get restored relatively easily.