Backup

How to dump all MySQL databases into indivisual files at once

Blog
Drupal
Linux
Sys Administration

I had to move 264 databases from one Linux server (Fedora) to another (CentOS), hard copying /var/lib/mysql wasn't a good idea because version of two MySQL databases were different and i had to repair all the tables after move so i decided to write a very short and usefull bash script.

It dumps all the databases but each database into a different file :

1
Your rating: None Average: 1 (128 votes)