Sql - mysql dump database

Back up a Database

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

Restore a Backup

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