MYSQL Database Restoration in Linux
Please run below command that from where you want to take database to restore:
/usr/bin/mysqldump –user=proftpd –password=proftpd –opt –skip-lock-tables –single-transaction –default-character-set=binary –databases mds > MDS_Dump.sql
Note:- If we know the root password of the mysql, then use that credentials, after that zip MDS_DUMP.sql file and tranfer it into destination server.
To restore Please use below script:-
—————————
#!/bin/bash
#
# Script for restoring Database database.
# Modified by Sravan Kumar E
#
echo “Restoration staDatabaseed at: `date`” >> /tmp/restore.log
FILENAME=`date +%d-%b-%Y`
if [ -f /tmp/Database_Dump_?????????${FILENAME}.sql.gz ]
then
gunzip -d /tmp/Database_Dump_?????????${FILENAME}.sql.gz
mysqladmin –user=root –password=******** -f drop Database3 >> /tmp/restore.log 2>>/tmp/restore.log
RESTORE_FILE=`echo /tmp/Database_Dump_?????????${FILENAME}.sql`
echo “ImpoDatabaseing the data from ${RESTORE_FILE}” >> /tmp/restore.log
mysql –user=root –password=c1b8rn8t < ${RESTORE_FILE} gzip /tmp/Database_Dump_?????????${FILENAME}.sql rm -f /tmp/Database_Dump_?????????${FILENAME}.sql echo "Restoration completed at: `date`" >> /tmp/restore.log
else
echo “Restore Failed because of non availability of proper file” >> /tmp/restore.log
fi
—————————–