mysqldump --user=XXXXXXXX --password=XXXXXXX -A > /PATH/TO/DUMPALL.SQL
Dump Individual or Multiple MySQL Databases
mysqldump --user=XXXXXXXX --password=XXXXXXX --databases DB_NAME1 > /PATH/TO/DUMPDB_NAME1.SQL
Dump only certain tables from a MySQL Database
mysqldump --user=XXXXXXXX --password=XXXXXXXX --databases DB_NAME --tables TABLE_NAME > /PATH/TO/DUMPTABLE_NAME.SQL
Restore the database
mysql --user=XXXXXXXX --password=XXXXXXXX DB_NAME < /PATH/TO/DUMPALL.SQL
