How to import and export mysql database?

This assumes that mysql is in your classpath. Replace "dbname" in the below command with your own database name.

mysqldump -u root -p dbname > dump.sql (export)

mysql -u USER -p dbname < dump.sql (import)