Archive for 11 June 2012

MySQL backup

Settings

This is a little utility I created using Visual C#. I use it to backup my server’s database every day. It can remember any number of mysql databases with credentials in an xml file. Backups are done manually by pressing the button.

Database manager

Database manager

This utility creates backup by querying server for detailed list of tables, and then selects all data from each table, 1000 rows at a time to avoid locking up database while gameserver still needs access to it. Data is saved to .sql files, which size is limited to certain size. After this, another file is created and backup is continued.

Main program window

Main program window