Article

How do I import or export a database using shell access?

« Go Back

Information

 
TitleHow do I import or export a database using shell access?
Description

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

Attachment 
Attachment 
Feedback

Was this article helpful?

   
Feedback

Please tell us how we can make this article more useful.

Characters Remaining: 255