mysqldump

HowTo : BackUp MySQL Database From the Command Line

The basic installation of MySQL Server provides a great command line utility to take backup of MySQL databases.

The 'mysqldump' command is used for creation "dumps" of databases managed by MySQL.

These dumps are just files with all the SQL commands needed to recreate the database.