Manual Export of MySQL Database

Join our Discord and be part of our community!

Manual Export of MySQL Database

In this guide, we will demonstrate step-by-step instructions on manually exporting your MYSQL database.

Databases make managing and accessing your data easier, especially if you have multiple items needing to access it. However, you may find yourself needing to export the data to keep as a backup or to move databases. This guide will cover how.

Windows

Download Database Management Software

HeidiSQL is a well known and simple Graphical MySQL database management tool. However, you should always do your own research in what software to use. ⁣

Visit the HeidiSQL download page and download the installer.
Once you have located the downloaded file, you will need to run it, select the file and install the software.
Make sure to have HeidiSQL open.

Database Details

Login to the panel. See Access the Panel for instructions.
Head to your specific game server.
Click on the Databases tab on the left-hand navigation bar.

Click the eye icon button to populate the database details of your desired database.
You will want to keep a note of the details such as the 1 IP address, 2 username and 3 password.

Export Database

First, we need to get HeidiSQL logged in so it can manage and export your database.
Click on the 1 New button so we can add the session.
Input the 2 IP address of where your database is hosted.
Enter your 3 username and password credentials.
Input the name of the 4 Database you wish to connect to.

Finally, click on 5 Open to start the connection.

Once connected, you will see a lot of information regarding your database. You will want to right-click on the database and hit export database as SQL.

1 You may choose between insert or insert and replace existing data. Either way, MySQL will continue.
2 You may decide how you want your data to be stored. Either a singular database file or just in a zipped SQL folder.
3 Make sure the file is saved where you want it to be.

In your folder, you will see the file from the MySQL backup.

Linux (Ubuntu/Debian)

Please keep in mind, you may require sudo privileges. If you do not know what a command does, then please do research. For example, you should understand installing packages, navigating folder structures, etc.

Install Client

Open your terminal.
Execute sudo apt update -y and sudo apt install mariadb-client -y which shall install the latest version of a MySQL client.
Execute mysql --version to verify it has been installed.

If you receive a message command not found, then try typing bash and run the command again.

Database Details

Head to your specific game server.
Click on the Databases tab on the left-hand navigation bar.

Click the eye icon button to populate the database details of your desired database.
You will want to keep a note of the details such as the 1 IP address, 2 username and 3 password.

Take note of the Database name as well.

Export Database

Open your terminal.
Choose a spot to download your backup. Let’s say you want it to do it in your home directory, so you use cd ~.
Execute the following command:

Make sure to replace USERNAME, PASSWORD and DATABASE_NAME with the details from the previous step.

mysqldump -h DB_IP -u USERNAME -pQ'PASSWORD' DATABASE_NAME > backup.sql

Unfortunately, mysqldump does not have a way to view the progress of the dump, so you need to wait for it to finish.

If you require further assistance, you can open a support ticket here.

Feedback and suggestions can be submitted here or further discussed on our Discord server.

Manual Export of MySQL Database
Windows
Download Database Management Software
Database Details
Export Database
Linux (Ubuntu/Debian)
Install Client
Database Details
Export Database