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.