MySQL Backup and Reanimation

[Ashcrow]

Whats the best way to backup a MySQL database and whats the best way to recover the data onto a diffrent MySQL instalaltion?

[Ashcrow]

This fell down the list to fast. *bump*

[Killer_Penguin]

Whats the best way to backup a MySQL database and whats the best way to recover the data onto a diffrent MySQL instalaltion?

Mysql has a dump feature, so you can dump all your databases or just specific ones to .sql files. You can then insert them into another database server, or your own later.

Or, like I do, just tarup the /var/lib/mysql directory, so that you can just re-write it, and all your data is intact.

[namirays]

hai,

u can get back up method from this site

http://www.debianhelp.co.uk/mysqlscript.htm

it will back up to local and also will email your back up n log file.