Import / Export a mySQL database

This can also be used for backing up a database.

Resource: https://my.bluehost.com/cgi/help/112

Export / backup database:

mysqldump -u username -p database_name > dbname.sql

Import / restore backup

First create the database of the appropriate name, then run:

 mysql -p -u username database_name < file.sql

Reply