How to Import / Export MySQL Databases via SSH / Command-line

To Export a MySQL Database run:

mysqldump -u username -p database_name > dumpfile.sql

To Import a MySQL Database run:

mysql -u username -p database_name < dumpfile.sql

This entry was posted in FAQ and tagged , , . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *