MySQL backup and restore

BACKUP

Note: There's no space between the -p option and the password

Full database

     mysqldump -u username -p[password] [database_name] > dumpfilename.sql 

Multiple databases

     mysqldump -u username -p[password] --databases database1 database2 > dumpfilename.sql 

All databases

     mysqldump -u username -p[password] --all-databases > dumpfilename.sql 

Single table

     mysqldump -u username -p[password] [database_name] [table_name] > dumpfilename.sql 

RESTORE

     mysql -u username -p[password] [database_name] < dumpfilename.sql  

From here