How to Import and Export MySQL Database(s)

CLICK TO SHARE

Export a Database

$ sudo mysqldump -u username -p dbname > dbexport.sql

Import a Database

$ sudo mysql -u username -p dbname < dbexport.sql