Manual Database Backup

The following steps can be followed to create a manual backup of your databases.

By copying these files you can start up a duplicate or test version of your server quickly and easily.

Steps to backup: To restore from a backup:
 * Create a location to store the backups. We're assuming there's a folder on your Desktop called 'Backups'
 * In 'Backups' create a new folder with the date. For example 7-17. Doing this allows you to keep several backups and have them sorted nicely in your folder.
 * Copy the entire Berkeley database folder into the newly created backup folder above. The Berkeley database can be found in /Core3/MMOCoreORB/database/
 * Next backup the MySQL database. Look for a program called MySQL workbench and open it.
 * You should see an option called 'Data Export' - click it, use the 'Self Contained File' option and point the save to the backup folder. I usually call the file monthxx.sql, i.e. july17.sql.
 * For extra protection, take the sql file and Berkeley database, compress it into a single file and store it offsite via a service like Dropbox, Google Drive, etc.
 * Download and uncompress the backup file.
 * Copy the entire 'database' folder to /Core3/MMOCoreORB/database/ (you might want to delete contents in the target folder before copying to make sure nothing extra is there).
 * Open MySQL Workbench.
 * Find the SWGEmu database, right click and 'Drop Schema.'
 * 'Import' the SQL backup file. You want to choose the 'self contained' option again.
 * Hit the 'Refresh' icon and you should see the SWGEmu schema again.
 * IMPORTANT - If you are starting a test server or making a duplicate of your server on another box, make sure the DB secret key in your config file matches the one from the backup.