This article will provide a step-by-step guide on how to export your site’s database at SiteGround.
There are several reasons why you may want to backup your database, including:
- You want the ability to quickly and easily restore your website in case of any unexpected issues or problems.
- You feel safer knowing that you have an additional copy of your data.
- You have a local development environment and want to import your database into it.
This guide will only cover exporting or backing up your database with SiteGround. If you’re looking for a guide on how to backup your files, check out our guide on how to download a .zip backup of the public_html folder.
SiteGround automatically backs up your files and database every 24 hours on all Shared and Cloud hosting plans. All backups are stored for 30 days, and you can restore your website from any of these backups at any time. You can find out more about this at the relevant part of our guide to SiteGround’s Site Tools.
Right, let’s get started.
How to Export and Download a Backup of your Database with SiteGround
The first step is to log into your SiteGround Site Tools dashboard, which can be accessed via your SiteGround client area.
You can find details on how to do this in the following articles:
Following these steps, you’ll be on SiteGround’s Site Tools dashboard.
Once in the phpMyAdmin database manager, select the database you want to export by clicking on the database name in the left-hand menu.
You will then see the database tables listed in the main window.
Final Thoughts
In conclusion, exporting a database in phpMyAdmin is a simple process. Using the “Quick” option, you can easily export your entire database in the most common file format (SQL).
If you need more control over the export process, the “Custom” option allows you to select specific tables or data, choose the file format, add additional options and even schedule the export to occur later.
Whether you’re making a backup of your entire database or exporting a specific subset of your data, phpMyAdmin makes it easy to export your databases with just a few clicks. With this knowledge, you should be able to export your databases whenever you need to, confidently.