Cron Job for backing up multiple dbs at once

[Website]

Seems like the hosting providers enabled binding address feature in mysql.

can you do the same editing in the script I gave you, that is, adding hostname/IP address in the script ?

Can you please make the changes in the script and send the entire script here so i can copy and paste after changing the credidentials?
I am not good at coding. I dont wanna mess up anything.

PS: the folder is writable for sure.

[msohail]

Can you please make the changes in the script and send the entire script here so i can copy and paste after changing the credidentials?
I am not good at coding. I dont wanna mess up anything.

PS: the folder is writable for sure.

Sure I will, but first send me the script which you executed half hour ago which gave you the entire list of databases.

Database
information_schema
db244952345_affiliatemarketingprogramguide
db244952345_affiliatepartnershipguide
db244952345_affiliateprogramjournal
db244952345_affiliatesolutionguide
db244952345_brandadvocacycentral
db244952345_brandadvocacyguide
db244952345_churnratereductionguide
db244952345_customeradvocacycentral
db244952345_customeradvocacyguide
db244952345_customerloyaltycentral
db244952345_franchisemarketingcentral
db244952345_franchisesuccessguide
db244952345_gamificationcentral
db244952345_localpromotionsguide
db244952345_loyaltyjournal
db244952345_loyaltymanagerguide
db244952345_loyaltyprogramguide
db244952345_loyaltyprogramvendors
db244952345_membershipretentionideas
db244952345_onlineaffiliateprogramguide
db244952345_opengraphintegrationguide
db244952345_partnershipmanagerguide
db244952345_partnershipprogramguide
db244952345_promotionpartnerscentral
db244952345_promotionpartnersguide
db244952345_referraljournal
db244952345_retailbrandguide
db244952345_retailfranchisecentral
db244952345_retentionguide
db244952345_saasretentionguide
db244952345_socialadvocacyguide
db244952345_socialgraphpromotionsguide
db244952345_socialloyaltyguide
db244952345_socialreferralcentral
db244952345_upsellguide
db244952345_upsellingtechniques

[Website]

I wrote
mysql -uDBUSERNAME -pPASSWORD -hHOSTNAME -e "show databases;" | awk '{print $1}'
to SSH to get that list

and I was trying to use this script to backup the DBs

count=2
i=`mysql -uDBUSERNAME -pPASSWORD -e "show databases;" | awk '{print $1}' | wc -l`
while [ $count -le $i ]
do
        db=`mysql -uDBUSERNAME -pPASSWORD -e "show databases;" | awk '{print $1}' | sed -n "$count"p`
        if [ "$db" == "information_schema" ] || [ "$db" == "performance_schema" ] || [ "$db" == "mysql" ];
        then
                ((++count))
                echo "Skipping" >> /dev/null
        else
                mysqldump -uDBUSERNAME -pPASSWORD $db > /nfs/c0434/hf0541/mnt/1162744/domains/site.com/html/backups/$db.sql
                ((++count))
        fi
done

[msohail]

Ok so you only require hostname to be added in the script.

count=2
i=`mysql -uDBUSERNAME -pPASSWORD -hHOSTNAME -e "show databases;" | awk '{print $1}' | wc -l`
while [ $count -le $i ]
do
        db=`mysql -uDBUSERNAME -pPASSWORD -hHOSTNAME -e "show databases;" | awk '{print $1}' | sed -n "$count"p`
        if [ "$db" == "information_schema" ] || [ "$db" == "performance_schema" ] || [ "$db" == "mysql" ];
        then
                ((++count))
                echo "Skipping" >> /dev/null
        else
                mysqldump -uDBUSERNAME -pPASSWORD -hHOSTNAME $db > /DESTINATION_FOLDER/$db.sql
                ((++count))
        fi
done

Make the necessary changes in the script and In Sha Allah it should work out fine.

Make sure the script has executable permissions.

Jazak Allah
Sohail

[Website]

I get this error now
line 4: -e: command not found

count=2
i=`mysql -uDBUSER -pPASS -hHOSTNAME
 -e "show databases;" | awk '{print $1}' | wc -l`
while [ $count -le $i ]
do
        db=`mysql -uDBUSER -pPASS -hHOSTNAME
 -e "show databases;" | awk '{print $1}' | sed -n "$count"p`
        if [ "$db" == "information_schema" ] || [ "$db" == "performance_schema" ] || [ "$db" == "mysql" ];
        then
                ((++count))
                echo "Skipping" >> /dev/null
        else
                mysqldump -uDBUSER -pPASS -hHOSTNAME
 $db > /nasdfgfs/c0asdsdg4/hasdg05/mnwr3w2t/136232324r243w2ef95/domains/backups/$db.sql
                ((++count))
        fi
done

[msohail]

I get this error now
line 4: -e: command not found

count=2
i=`mysql -uDBUSER -pPASS -hHOSTNAME
 -e "show databases;" | awk '{print $1}' | wc -l`
while [ $count -le $i ]
do
        db=`mysql -uDBUSER -pPASS -hHOSTNAME
 -e "show databases;" | awk '{print $1}' | sed -n "$count"p`
        if [ "$db" == "information_schema" ] || [ "$db" == "performance_schema" ] || [ "$db" == "mysql" ];
        then
                ((++count))
                echo "Skipping" >> /dev/null
        else
                mysqldump -uDBUSER -pPASS -hHOSTNAME
 $db > /nasdfgfs/c0asdsdg4/hasdg05/mnwr3w2t/136232324r243w2ef95/domains/backups/$db.sql
                ((++count))
        fi
done

Thats because you copied/edited it incorrectly

i=`mysql -uDBUSER -pPASS -hHOSTNAME
-e "show databases;" | awk '{print $1}' | wc -l`

it should be in a single line as shown in my script like this

i=`mysql -uDBUSER -pPASS -hHOSTNAME -e "show databases;" | awk '{print $1}' | wc -l`

Incorrect

db=`mysql -uDBUSER -pPASS -hHOSTNAME
-e "show databases;" | awk '{print $1}' | sed -n "$count"p`

Correct

db=`mysql -uDBUSER -pPASS -hHOSTNAME -e "show databases;" | awk '{print $1}' | sed -n "$count"p`

Incorrect

mysqldump -uDBUSER -pPASS -hHOSTNAME
$db > /nasdfgfs/c0asdsdg4/hasdg05/mnwr3w2t/136232324r243w2ef95/domains/backups/$db.sql

Correct

mysqldump -uDBUSER -pPASS -hHOSTNAME $db > /nasdfgfs/c0asdsdg4/hasdg05/mnwr3w2t/136232324r243w2ef95/domains/backups/$db.sql

[Website]

Works perfectly. You da man! Thank you very much!

[msohail]

Works perfectly. You da man! Thank you very much!

Anytime.

Jazak Allah
Sohail

[mizzle]

Oh, that is good code to make the script scale
My script was just a simple one for a small amount of DBs. If you don't mind, I will use some of your code to make my script more scaleable for others.

[msohail]

Oh, that is good code to make the script scale
My script was just a simple one for a small amount of DBs. If you don't mind, I will use some of your code to make my script more scaleable for others.

You are welcome to use the script.

Jazak Allah
Sohail