🚀 UltraServers Relaunch We're thrilled to announce the relaunch of our service with a brand-new, streamlined panel designed to enhance your gaming experience. Join our Discord for more information, lifetime discounts and to take part in our $175 raffle to win Steam gift cards.
Manually Exporting your 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:
Downloading a 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.
Grabbing the details to your Database
- You need to access the Panel through this URL.
- 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.
Exporting your 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)
Installing the 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.
Grabbing the details to your Database
- 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.
Exporting your 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.