====== 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.