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:
- 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.
To restore from a backup:
- 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.