mysql backup

[cfleck]

what is the best way to back up a mysql database? i'm foreign to the topic so i dont really know.

i'm using CocoaMySQL to "administer" it, and it has a lovely "table dump" option but i dont know if thats what i want.

It will dump my selected tables to a file, but is that a good enough backup? how can i write a script to do that?

 

[Pengu]

if you get a dump of the entire database with data, you can then compress the file (its all text) and use it later if you need to restore from it.

 

[octane]

Yep, that's what I do.

When I come to do a back up of my data, I just go into phpMyAdmin and dump all of the tables separately.

Each dump containing data & schema.

Can't really go wrong...

 

[cfleck]

i'd like to automate it with cron. anyone know how to do this from the cli?

 

[Pengu]

write an sql script to backup the databases you want, and then setup the cron job to run mysql client and use an external sql script.

 

[michaelsanford]

mysqldump --all-databases --add-locks --extended-insert -h127.0.0.1 -uusername -ppassword > backup.sql