How to dump all MySQL databases into indivisual files at once
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 :
for I in `echo "show databases;" | mysql -u myuser --password="" | grep -v Database`; do mysqldump -u myuser --password="" $I > "$I.sql"; done
As you can see you can put each .sql file into a different folder if you want, and it's possible to compress each file using piping :)
- Login to post comments