wiki:mysqlbackuprestore
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| wiki:mysqlbackuprestore [2024/06/13 20:39] – guidebeacon | wiki:mysqlbackuprestore [2024/06/13 20:46] (current) – guidebeacon | ||
|---|---|---|---|
| Line 9: | Line 9: | ||
| ===== Manual Restore ===== | ===== Manual Restore ===== | ||
| - | There is a copy of the database backups locally and on backblaze. | + | There is a copy of the MySQL database backups locally and on BackBlaze. |
| To restore a local copy, make a copy of the backup zip: | To restore a local copy, make a copy of the backup zip: | ||
| - | '' | + | < |
| + | cp / | ||
| + | </ | ||
| Decompress the zip: | Decompress the zip: | ||
| - | '' | + | < |
| - | + | cd /tmp | |
| - | '' | + | unzip all_dbs.zip |
| + | </ | ||
| Then run this command to perform the restore from the shell or SSH. | Then run this command to perform the restore from the shell or SSH. | ||
| - | '' | + | < |
| + | mysql -u root beaconte_beacontech < beaconte_beacontech.sql | ||
| + | </ | ||
| If restoring a different database, change the database name and file parameter. | If restoring a different database, change the database name and file parameter. | ||
| The file must be in its raw form and not compressed or it won't work. | The file must be in its raw form and not compressed or it won't work. | ||
wiki/mysqlbackuprestore.1718311160.txt.gz · Last modified: 2024/06/13 20:39 by guidebeacon