This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
computing:linux:mysql_backup [2018/10/01 14:31] gcooper |
computing:linux:mysql_backup [2018/10/01 14:33] (current) gcooper |
||
---|---|---|---|
Line 128: | Line 128: | ||
</ | </ | ||
- | ===== Restore A MySQL Backup ===== | + | ====== Restore A MySQL Backup |
One-liner to restore a gzipped MySQL backup: | One-liner to restore a gzipped MySQL backup: | ||
Line 135: | Line 135: | ||
gunzip < mysql-database-name.sql.gz | mysql -p -h localhost mysql-database-name | gunzip < mysql-database-name.sql.gz | mysql -p -h localhost mysql-database-name | ||
</ | </ | ||
- | gunzip < mysql-sonoracomm_whmcs-database.sql.gz | mysql -p -h localhost | + | |
+ | :!: You will need to enter the database |