Differences

This shows you the differences between two versions of the page.

--- wiki:mysqlbackuprestore [2024/06/13 20:37] – removed - external edit (Unknown date) 127.0.0.1
+++ wiki:mysqlbackuprestore [2024/06/13 20:46] (current) – guidebeacon
@@ Line 1: / Line 1: @@
+====== MySQL Manual Backup and Restore ======
+===== Manual Backup =====
+There is a script ''/etc/cron.daily/databasebackup.sh'' which dumps the databases daily, and uploads them to backblaze.
+To force another backup, just execute the script and another copy will be made.
+===== Manual Restore =====
+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:
+<code>
+cp /backup/mysql/all_dbs.zip /tmp/
+</code>
+Decompress the zip:
+<code>
+cd /tmp
+unzip all_dbs.zip
+</code>
+Then run this command to perform the restore from the shell or SSH.
+<code>
+mysql -u root beaconte_beacontech < beaconte_beacontech.sql
+</code>
+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.