User Tools
computing:linux:mysql_backup
Differences
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:32] gcooper |
computing:linux:mysql_backup [2018/10/01 14:33] (current) gcooper |
||
|---|---|---|---|
| Line 15: | Line 15: | ||
| </ | </ | ||
| - | ====== PostgreSQL Password | + | ===== PostgreSQL Password ===== |
| For scripts that run as '' | For scripts that run as '' | ||
| 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 | ||
computing/linux/mysql_backup.1538425930.txt.gz · Last modified: 2018/10/01 14:32 by gcooper
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
