MySQL Dump/Restore, Dumping MySQL Database and Tables using MysqlDump command

Dumping MySQL Database using MysqlDump command

Dumping all available databases in MySQL

mysqldump --user=USERNAME --password=PASSWORD -A > FOLDER/DUMP_FILE.SQL

Dumping some of the databases in your MySQL Database

mysqldump --user=USERNAME --password=PASSWORD --databases DATABASE_1 DATABASE_2 > FOLDER/DUMP_FILE.SQL

Dumping some of the tables in a database

mysqldump --user=USERNAME --password=PASSWORD --databases DATABASE --tables TABLE > FOLDER/DUMP_FILE.SQL

If production, development, publishing versions of your MySQL system are different, then you may use the given command to provide concurrency.

--compatible=mysql323

Restoring MySQL Dump Files

You may run the command given below to restore previously dumped mysql archieve

mysql --verbose --user=USERNAME --password=PASSWORD DATABASE < FOLDER/DUMP_FILE.SQL

Example values

USERNAME: root
PASSWORD: 555555
DATABASE: db_askfoxes
TABLE: tbl_content
WINDOWS FOLDER: d://dumps/
LINUX FOLDER: /var/www/dump/