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