Backup mysql database?

[Anon]

Dear all,

There are some databases in the mysql server. We would like to backup all of them because we re-install the whole linux OS. Please give us reply on how to backup the whole mysql databases effectively, thanks.

Sincerely yours,
Simon

[[deleted]]

Manuals are your friends, read them.
http://www.mysql.com/doc/B/a/Backup.html

[Anon]

um, that page doesn't mention how to make a backup using PHP. Since this site has a decided PHP slant, does anyone please know how to backup databases/tables using PHP?

Thanks,

John

[[deleted]]

DO exactly what they say in the mysql manual.
You can use PHP's exec() and system() functions to start the commands.