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:42] – guidebeacon | wiki:mysqlbackuprestore [2024/06/13 20:46] (current) – guidebeacon | ||
|---|---|---|---|
| Line 13: | Line 13: | ||
| 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.1718311320.txt.gz · Last modified: 2024/06/13 20:42 by guidebeacon