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
- Head to your server Dashboard and head over to the 1 Database tab to make note of 2 your credentials.
- You will want to keep a note of the details such as the 1 database name, 2 IP address, 3 username and 4 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.
- In your folder, you will see the file from the MySQL backup.
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.
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 server Dashboard and head over to the 1 Database tab to make note of 2 your credentials.
- You will want to keep a note of the details such as the 1 database name, 2 IP address, 3 username and 4 password.
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 regarding this article are welcome on our Discord server