Script to Make a backup of the current database and restore DB from the available backup of all the database owned by a particular user in cPanel
You can make use of the following script to generate a backup of all the databases and also restoring the DB from the available backup in cPanel owned by a particular user.
=============
#!/bin/bash
cd /var/lib/mysql
ls -al | grep username | awk {‘print$9’} > dblist
for i in `cat dblist`
do
mysqldump $i > $i.sql;
mv $i.sql /home/username
done
cp /backup/cpbackup/monthly/username/mysql/yogabook_*.sql /var/lib/mysql
for i in `cat dblist`
do
mysql $i < $i.sql;
done
=============
Have a Great Day 🙂 🙂
