Virtual private server hosting news, reviews, tips, and tutorials from an industry-leading provider.

How to Import/Export MySQL Databases with SSH

Posted: January 8th, 2012 | By: | Filed under: Tutorials | Tags: , | No Comments »
To export a MySQL database, access your VPS via SSH and run:
# mysqldump -u username -p database_name > dumpfile.sql
To import a MySQL Database, run:
# mysql -u username -p database_name < dumpfile.sql
This article is also available in the VPS6.NET Knowledgebase:
https://vps6.net/my/knowledgebase/37/How-to-ImportorExport-MySQL-Databases-with-SSH.html

Leave a Reply