Step1: create a file /home/test.txt and add all databases names there.

Step2: Apply below command which will dump all databases in /home directory.

# for i in `cat test.txt` ; do mysqldump $i > $i.sql ; done”

Advertisements