If you ever loose access to your WordPress website and you have backups of your
wp-content folder and the WordPress database then you are pretty much insured. In most cases, all your media files are stored in the
wp-content folder and the database houses all the data.
Backing up your WordPress website or if the website is too large, backing up just the database before any significant site change is always a good idea.
Here are 5 methods you can follow to export your WordPress website database quickly.
1. Backup WordPress website database using Adminer
This is probably the easiest and most reliable way to export and download your WordPress database.
Adminer is a small but extremely powerful full-featured database management tool written in PHP. Basically, it’s just a .php file that you need to upload on your server/website and it’s completely free.
What makes Adminer special is its user experience and ability to do things fast. To backup your WordPress website’s MySQL database using Adminer, follow these steps:
Step 1: Go to Adminer’s official website and download the latest file. (It’s just about 500 kB in size.)
Step 2: Upload the file on your server in the root of your WordPress installation. You can do this either using FTP or using a WordPress plugin like WP File Manager.
Step 3: Start a new browser tab and go to the file you just uploaded. For example, if the name of the uploaded file is
adminer-4.7.3.php and your website is www.xyz.com then type
www.xyz.com/adminer-4.7.3.php in the browser address bar.
Step 4: Fill your WordPress database, username, and password to access your database.
In case you don’t know these details, it’s very easy to find them. Simply open your WordPress root directory (as in step 2), locate the
wp-config.php file then right-click on it and select edit. You’ll find the required details in this format:
/** The name of the database for WordPress */
define( ‘DB_NAME’, ‘database_name_here‘ );
/** MySQL database username /
define( ‘DB_USER’, ‘username_here’ );
/* MySQL database password */
define( ‘DB_PASSWORD’, ‘password_here‘ );
Step 5: Click on the ‘Export‘ option under your database name, then select ‘Save’ from the Output options click ‘Export’. Your WordPress database backup will then start downloading.
2. Back WordPress website database using cPanel
cPanel is an extremely popular web hosting control panel. Almost every popular shared hosting brand provides cPanel as a part of their plans. Backing up your WordPress website database using cPanel is very easy. You can follow the steps below:
Step 1: Log into your cPanel and search for ‘Backup Wizard’ using the search bar. We’re going to use the backup wizard to take a backup of our WordPress database.
Step 2: Click on the ‘Backup Wizard’ option to start the backup wizard.
Step 3: Once the cPanel Backup Wizard’ starts, Select the ‘Backup’ option. It will then ask you if you wish to take a full or partial backup. In our case, we only want to backup our WordPress database which means we have to select ‘MySQL Databases’ option under partial backups.
Step 4: Selecting the MySQL databases option opens the Final Step page. Here’s you’ll see a list of all the databases in your account. Click on the name of the database you want to backup and it will start downloading.
If you do not know the name of the database accociated with your WordPress website. You can find it in the
wp-config.php file. Simply go to your cPanel file manager, locate your WordPress installation and look for
wp-config.php file. Click on ‘Edit file’ option in the right-click menu and the name of your database is mentioned in the format,
define( 'DB_NAME', '
3. Backup WordPress database using phpMyAdmin
If you have phpMyAdmin installed on your server, backing up your WordPress website database is extremely easy. The process is similar to using Adminer to backup WordPress database. Follow these steps to backup your WordPress database using phpMyAdmin.
Step 1: Open phpMyAdmin and click on the name of the database associated with your WordPress website.
Step 2: After selecting your database, click on the ‘Export’ option in the menu bar.
Step 3: Select the format using the dropdown menu if you want to download your database in any format other than SQL and click the ‘Go’ button after which your download will begin.