Skip to content

Backing Up Your Database

Bryce Mecum edited this page Jan 27, 2024 · 22 revisions

Note

This page needs people with more knowledge to answer these questions:

  • TODO: Does this pause the server while it works?
  • TODO: How long can this take?
  • TODO: Does this capture writers that happen are you start it? i.e., can this be done while players are logged in?

Using MySQL Workbench

image

Command Line

Browse to your wamp/bin/mysql/VERSION/bin folder, then run the following (changing the username (-u) and/or password (-p) as needed:

mysqldump -u root -p ace_auth > ace_auth.sql
mysqldump -u root -p ace_shard > ace_shard.sql

And if you have customized weenies (.sql files) or modified anything in ace_world, also run:

mysqldump -u root -p ace_world > ace_world.sql