It's very important to back up data...

make them periodically to avoid losing valuable information.

With the utility mysqldump you can export our data in MySQL.

For example, to back up the database "test" run the following command:

mysqldump -B --opt test -u root -p > backup_test.sql

in the file backup_test.sql there are all the information necessary to completely restore the database "test".

To restore the database that was backed up previously, simply run:

mysql -u root -p < backup_test.sql