How to back up server database?

[Ronin Cross]

I have HeidiSQL, how do you back up your server so you have a copy of the terrain, guilds, claims, basically everything?

I'm new to this so sorry if its a simple thing, I can't understand HeidiSQL yet haha; also once you back it up, I'm guessing you get just a single file, to restore it you just load that file correct?

[Leiunn]

Hey, you can export the database using HeidiSQL the following way:

1. Open HeidiSQL
   
2. In the top menu bar go to Tools -> Database SQL Export
   
3. A Window will appear
   
4. On the left side you select the database you want to export (navigate through the tree)
   
5. On the right side you select
   
   • Both Delete and Create for database
     
   • And only create for tables (this is important as without create no data can be restored later on)
6. Now select a place and name for the export file
   
7. Finally click on export

To restore the Data in HeidiSQL you go to File -> Execute SQL-File. And select the exported file.

To test this I really recommend you to copy the export file, open the copy and rename all occurences of the database name to something else and then try to execute that modified file. If everything worked well you should have no errors and in HeidiSQL (maybe need to use the refresh button) the new database should appear with all tables and data in it.

Hope this helps.

Regards