Backing Up Your Database

Warning

This page is a draft and isn't to be treated as guidance of best practice. This warning can be removed once this page has been filled in more completley.

Note

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

• TODO: How can atomicity be enforced?
• TODO: How long can this take?
• TODO: Investigate the "single transaction option". Does it slow down other reads or writes? Does it preserve atomicity? More info at https://stackoverflow.com/questions/41683158/mysqldump-single-transaction-option
• Relevant thread in Discord: https://discord.com/channels/261242462972936192/261242462972936192/1187967838904918097

Using MySQL Workbench

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

Q & A

• Q: Does this pause the server?

  A: No it does not.

• Q: Can this be done while players are logged in?

  A: Yes.