BeastNode Game Server Hosting

Checkout our new range of Cheap Game Server Hosting! Including Rust, Terraria and Valheim!

Starting at only $2.11/mo!

Don't worry our Minecraft Servers are here to stay!

Minecraft Hosting Game Servers

How to Use HeidiSQL to Backup or Export Your Database

This guide will cover the basics on how to export/backup your Minecraft server's MySQL database to your computer with HeidiSQL (Windows PC only).

First, make sure to download HeidiSQL and install it:

1. Start up HeidiSQL and click "New" on the bottom left corner of the window, and you should get something like this:

2. On the left window, change "Unnamed" to whatever you want to name it. Then on the right window fill in the Hostname/IP, User, and Password with the ones shown to you in your Multicraft control panel's MySQL Database menu (nothing else needs to be changed). Click save once done then click open to access your database.

3. With your database window now open, right-click your database name on the left side of the window (underneath "information_schema") and select "Export database as SQL" and the following window will come up:

4. Ensure your settings match the above (make sure the database is selected on the left, tick both Create options and change the Data option to Insert) and then click the icon to the right of the "Filename" field to select where you wish to save the backup .sql file.

5. Click "Export" and wait until the process is completed.

  • 15 Users Found This Useful
Was this answer helpful?

Related Articles

MySQL Databases for Plugins

Most Minecraft plugins offer database storage such as SQLite, H2, or MySQL. Although SQLite and...