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/01/15 11:54] gcooper |
computing:linux:mysql_backup [2018/10/01 14:33] (current) gcooper |
||
---|---|---|---|
Line 127: | Line 127: | ||
exit | exit | ||
</ | </ | ||
+ | |||
+ | ====== Restore A MySQL Backup ====== | ||
+ | |||
+ | One-liner to restore a gzipped MySQL backup: | ||
+ | |||
+ | < | ||
+ | gunzip < mysql-database-name.sql.gz | mysql -p -h localhost mysql-database-name | ||
+ | </ | ||
+ | |||
+ | :!: You will need to enter the database password of the database on ' |