How to Import/Export MySQL Databases with SSH

April 22, 2012

1252

To Import without errors .

To export a MySQL database, access your VPS via SSH and run:

Code:

 mysqldump -u username -p database_name > dumpfile.sql

To import a MySQL Database, run:

Code:

 mysql -u username -p database_name < dumpfile.sql