How to Import and Export a MySQL Database

Import : mysql -u root -p database < database.sql

Export : mysqldump –host=database.host.net –password –user=username database > database.sql

mysqldump –host=’localhost’ –password –user=username database > database.sql