Skip to content

Instantly share code, notes, and snippets.

@msanjaypandit

msanjaypandit/Mysql_Backup_Restore_Script.md

Last active March 8, 2018 06:06
Show Gist options
  • Save msanjaypandit/6937da30dab57664034d6f86b8d14986 to your computer and use it in GitHub Desktop.
Save msanjaypandit/6937da30dab57664034d6f86b8d14986 to your computer and use it in GitHub Desktop.
Download ZIP
[MySql Backup/Restore] Generate and restore mysql backup #Mysql #backup #restore
Raw
Mysql_Backup_Restore_Script.md

Download full database (.gz extention)
mysqldump -h[host] -u[user] -p[password] [database] | gzip -c | cat > /var/www/html/mysqldump_[database]_$(date +%Y%m%d_%H%M%S).sql.gz

Download full database with ssl enabled (.gz extention)
mysqldump -h[host] -u[user] -p[password] [database] --ssl-ca=[.PEM file] [database] | gzip -c | cat > /var/www/html/mysqldump_[database]_$(date +%Y%m%d_%H%M%S).sql.gz

Download Specific database table (.gz extention)
mysqldump -h[host] -u[user] -p[password] [database] [tablename] | gzip -c | cat > /var/www/html/mysqldump_[database]_[tablename]_$(date +%Y%m%d_%H%M%S).sql.gz

Download Database after ignore some table (.gz extention)
mysqldump -h[host] -u[user] -p[password] [database] --ignore-table=[table1] --ignore-table=[table2]| gzip -c | cat > /var/www/html/mysqldump_[database]_$(date +%Y%m%d_%H%M%S).sql.gz

Restore Backup file in Database
mysql -h[host] -u[user] -p[password] [database] < /var/www/html/database.sql

Restore Database using .sql.gz file with ssl enabled
zcat database.sql.gz | mysql -h[host] -u[user] -p[password] --ssl-ca=[.PEM file] [database]

Restore Database using .sql.gz file
zcat database.sql.gz | mysql -h[host] -u[user] -p[password] [database]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment