MySQL#

Dump:

$ mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql

Restore:

$ mysql -u root -p[root_password] [database_name] < dumpfilename.sql