Many times I needed a command to transfer all my databases to a new server/environment. Following is the command I have used:

One command to backup all mysql databases

First we will need to create a directory where to store all the backups and change directory to it, and then backup all mysql databases with one command: 

You will need to replace -ppassword with -pYOUR_MYSQL_ROOT_PASSWORD (no spaces between -p and the password). If your mysql root user doesn't have a password, you don't need to use -u root and -ppassword flags.

Taking the command piece by piece:

The above command will execute the mysql query: SHOW DATABASES without the following header, which is not needed in our case:
+----------------------+
| Database             |
+----------------------+

Next the command will take each database name (information_schema, some_database and so on) and provide it to the standard mysql database backup command which will be executed for each database:

Each database backup file will be gziped before finish.

Now to check that everything went well, list the curent directory:

Now all that is to be done, depending on your situation, is to gather all these files in one tar file or scp them directly to the new environment.

Related: How to copy a mysql database using mysqldump

Bookmarks:

Echo "How to backup all mysql databases with one command" around: