How do I import or export a database using shell access?
To export a database use the command line:
mysqldump -u root -p db-name > backup.sql
To import a database please use:
mysql -u root -p db-name < backup.sql
See more at: http://www.unixmen.com/how-to-import-and-export-a-mysql-database-using-ssh/#sthash.lkbj951V.dpuf
Updated 2 months ago