Easy mysql question

This is so easy, I can't figure it out. (and can't find it searching the net or the board.)

I'm trying to move *many* mysql databases.

According to the docs...


If all the databases are wanted, one can use:

mysqldump --all-databases > all_databases.sql
So, how do I place all of those databases on another server?

Since I didn't add drops, nothing should be overwritten, right?

I've made a bunch of guesses, but nothing is working. All of the examples I'm finding for restoring databases require a database name in the command. Shouldn't the .sql file above be creating the databases itself?

 

 

 

 

Top