How to Import and Export MySQL Database(s)

Export a Database

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

Export Table from a Database into a File

> select * from wp_posts into outfile ‘/tmp/passwd.txt’;

Import a Database

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