MySQL Dump All Databases and Create (or Recreate) them on Import?

Question

I was wondering how I can get the following file,

mysqldump -h server -u root -p --all-databases > all_dbs.sql 

to automatically create any databases that are not yet created, when imported. Also, if a database is already present, it should recreate it (overwriting the old one).

Is this possible? Thanks!

Answer 1

Export: mysqldump -u root -p --all-databases > all_dbs.sql Import: mysql -u root -p < all_dbs.sql