Make a quick dump of a mysql database:
mysql_dump db_name > backup-file.sql
You can then read that dump file back into the server like this
mysql db_name < backup-file.sql
or like this:
mysql -e “source /path/to/backup/backup-file.sql” db_name