Tuesday, 12 April 2016

import and export MySql database via SSH

Problem to import mysql databse with phpmyadmin because of escape character, maybe time to try import via SSH then! To import your database using SSH:

mysql -u username -ppassword dbname < dbname.sql


To export your database using SSH:

mysql -u username -ppassword dbname > dbname.sql

No comments:

Post a Comment