mysqldump --add-drop-table -u user -p database >database.sql

##</code><code>##

mysql -u user -p database <database.sql