Home / server / Questions / 293011
Accepted
Minhaj
Asked: 2011-07-23 02:35:06 +0800 CST

Restore 200+ mysql databases

  • 772

I have 200+ mysql database dump in tar.gz format. Restoring all of them one by one is very time consuming. Is there any way so I can restore all these database in a single transaction.

Thanks for your help in advance!

mysql

2 Answers

  1. No, because transactions don't cross database boundaries. On the other hand, if you want to load 200+ databases with a single command, just script the process.

    • 1
  2. Best Answer

    With bash:

    for file in *.tar.gz; do 
  echo "processing $file";
  zcat $file | mysql;
done
    • 0