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
# mysqldump -u username -p database_name > dumpfile.sql
# mysql -u username -p database_name < dumpfile.sql
Powered by WHMCompleteSolution