mySQL backup

[yzerfontein]

How do you backup a mySQL database? I've got access to phpMYadmin.

[NullPointer]

You can export your data to a file and then Import it back to the database

[StupidScript]

As NullPointer said:

In phpMyAdmin:

Select the database you want to backup, choose the "Export" tab, define what syntax you will use for the backup (SQL) and a name for the file that contains the exported data, then hit GO.

From the command line:

mysqldump -u user -pPaSsWd dbname > outputfile

[photocrats.com]

phpmyadmin is the best way but after exporting the database, always check the file. Sometimes it becomes corrupted file with wired texts.

[StupidScript]

phpmyadmin is the best way

Acknowledging both that there are a few ways to do this and your excellent suggestion to check the resulting file after using phpMyAdmin, I beg to differ with your assessment of which method is 'best'. I've never had a corrupted file (or any restoring issues) using mysqldump, it takes only a second or two to complete, and there's no question about its formatting, as it is drawn from the current installation's configuration and capabilities. IMHO.

[alainkun]

Yes, you pnly need export DB.
If you need do it every days you can try to do a small PHP file:

<?php
$conexion = mysql_connect('localhost', 'user', 'pass');
$result = mysql_query('SHOW DATABASES', $conexion);
while ($row = mysql_fetch_row($result)) {
echo "Backup of ".$row[0]." ... ";
exec("mysqldump --host=localhost --user=user --password=pass --opt --default-character-set=utf-8 --flush-logs ".$row[0]." | bzip2 -c > /your/root/on/server/to/save/DB".$row[0]."-".date('Y.m.d').".sql.bz2");
echo "finish.n";
}
?>

You can add it to a crownjob on your host to do it automaticly every days