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
$ sudo mysqldump -u username -p dbname > dbexport.sql
> select * from wp_posts into outfile ‘/tmp/passwd.txt’;
$ sudo mysql -u username -p dbname < dbexport.sql