Wednesday, April 3, 2013

Migrate Databases of a user


cd ~user/www/
mysqlshow | grep user > dblist
cat dblist | cut -d "|" -f2 > dblist2
mv -f dblist2 dblist
sed -i '$d' dblist
sed -i '1,4d' dblist
for db in `cat dblist`; do sleep 0; echo "Dumping $db" ; mysqldump $db > $db.sql; if [ $? -eq 0 ]; then  echo "Done dumping $db.."; else read; fi; done

mkdir /home/user/db_dumps/
cd ~user/db_dumps/
wget domain.com/dblist
for db in `cat dblist`; do wget domain.com/$db.sql; if [ $? -eq 0 ]; then echo downloaded $db.sql..; done

for db in `cat dblist`; do sleep 0; echo "Restoring $db" ; mysql $db < $db.sql; if [ $? -eq 0 ]; then  echo "Done restoring $db.."; else read; fi; done

No comments:

Post a Comment