Dump and Restore

The logical dump of  all database can be done using mysqldump utility as below:
mysqldump -u root -p --all-databases > all_databases.sql

The logical dump of a particular database can be done using mysqldump utility as below:
mysqldump -u root -p publications > publications.sql


The restore the dumped sql flat file can be done for all databases can be done as
mysql -u root -p < all_databases.sql

The restore for a particular database can be done as below
mysql -u root -p -D publications < publications.sql