Sql - mysql dump database

Back up a Database

    
    mysqldump -u [username] -p db_name > backup.sql
    

Restore a Backup

    
    mysql -u [username] -p < backup.sql