🥂 Spring Discount! To celebrate the coming spring, all new orders will receive 25% off their first month! This means it’s easier than ever to upgrade or try out our cutting-edge game server hosting. 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
- 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)
Install Client
- Open your terminal.
- Execute
sudo apt update -yandsudo apt install mariadb-client -ywhich shall install the latest version of a MySQL client. - Execute
mysql --versionto verify it has been installed. - If you receive a message command not found, then try typing
bashand 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,PASSWORDandDATABASE_NAMEwith the details from the previous step.
mysqldump -h DB_IP -u USERNAME -pQ'PASSWORD' DATABASE_NAME > backup.sql- Unfortunately,
mysqldumpdoes 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.