Backup all databases in seperate files from Mysql in windows 7

Question

My OS is Windows 7 and I am using MySQL 5.5 version as DB for that I am having SQLyog(8.71) as GUI.

Now my problem is I want to take back up of all the databases present in MySQL. There are more than 100 databases present in my DB.

Any help is greatly appreciated.

score 2 · Answer 1 · edited May 23 '17 at 11:52

2

As first and important, you should have appropriate privilege for backup all the databases.

If you want to try on command line, then follow the instructions in this stackoverflow answer.

If you want to try with SQLyog GUI tool, you can follow the instructions in this youtube video.

edited May 23 '17 at 11:52

Community

answered Dec 08 '16 at 08:14

Steve.NayLinAung

Hey @ Steve.NayLinAung thank you very much for your info... Actually the you-tube link will work only for enterprise or ultimate editions of SQLYog.. if we are using trail version it is not accepting... So I am giving the link to download enterprise or ultimate versions of sqlyog so that it will be helpful to others URL: http://www.irdevelopers.com/post/11745/Webyog-SQLyog-Ultimate-12.0.9.0-x86-x64.html – Kishan Dec 08 '16 at 09:37
And my problem got solved thanks guys\ – Kishan Dec 08 '16 at 09:41

score 0 · Answer 2 · edited Dec 08 '16 at 08:07

0

I do not have a complete script but what i should do:

mysql "show-databases" > alldb.txt

Now you have a file alldb.txt with all database names in it

In a powershell file or command file,

foreach databasename in getlines(alldbd.txt) {
    mysqldump databasename > databasename.sql
}

edited Dec 08 '16 at 08:07

Senjuti Mahapatra

answered Dec 08 '16 at 07:10

Jeroen Bakker

hi could you please be little bit more clear – Kishan Dec 08 '16 at 07:19
You also must exclude some schemas like information_schema etc. and also include switch -R to have all information about the schema – Bernd Buffen Dec 08 '16 at 08:22

2 Answers2