Via shell command or cron job use something like this:

shell:~$ mysqldump --opt --single-transaction --databases database_one database_two > /your/backup/directory/my_databases.sql

This above will create a quick data dump that will be faster to re-import.



$@!ful™ wrote:

Which is the best way and format to backing up large MySQL (relational) database?