Want to back up your WordPress database via phpMyAdmin? WordPress stores all site data in a MySQL database. Often, a copy of the database is needed when transferring a site or when manually backing it up. In this article, I will show you how to easily make a database copy via phpMyAdmin.
Why use phpMyAdmin for database duplication
All site content is stored in the WordPress database. Almost all WordPress hosting companies offer a database management system – MySQL. You can work with MySQL using the command line tools, however this is not entirely easy for beginners. This is why PhpMyAdmin is needed. it offers a web interface for MySQL database management. With its help, you can make a manual backup of the database , restore the administrator password or move the site to another server.
Having said all that, let’s get back to the main point – how to duplicate a WordPress database using phpMyAdmin.
DUPLICATE / CLONE WORDPRESS DATABASE VIA PHPMYADMIN
First, go to your hosting account’s cPanel dashboard. Find the “Database” section and click on the phpMyAdmin icon.
Don’t worry if your cPanel dashboard looks a little different from my screenshots, or if your hosting company doesn’t have this dashboard at all. In that case, just go to the Databases section and look for the “open phpMyAdmin” option or something similar. … All modern hosting providers have access to databases from the control panel. So look, gentlemen.
After all these actions, the phpMyAdmin interface will appear, where, in order to continue, you need to click on the Databases link at the very top of the window.
In the screen that appears, you will see a list of all available databases. Click on the required one.
A list of tables in your WordPress database will appear. To continue working in the top menu, click on the “Operations” link.
Enter a name for the database copy in the box under “ Copy database to ”. Be sure to select the “Structure and Data” option and click the “Go” button.
PhpMyAdmin will start to duplicate the WordPress database. When finished, you will see a message about the successful completion of the process.
In order to view the created copy of the database at the top of the window, click on the “Databases” link.
MANUALLY COPYING A WORDPRESS DATABASE VIA PHPMYADMIN
If you are using shared hosting, then it is quite possible that you cannot create a database directly from phpMyAdmin.
In this case, you will not see the “Copy DB to …” box on the operations page.
However, you can export an existing database and then import it into a new database. To do this go to phpMyAdmin in your cPanel dashboard.
Select the required WordPress database, in the main menu, click on the “export” button and select the custom method – “custom”.
Scrolled page to the “output” section and check “Save output to a file’ option.
Click on the “Go” button to continue the process.
phpMyAdmin will start exporting the WordPress database and send it to your browser as a .mysql file.
Create a new database where you can import this file. Go to the cPanel dashboard and click on the “MySQLDatabases” icon.
On the next screen that appears, enter a name for the new database and click on the “Create database” button.
Cpanel will create a new MySQL database. However, in order to start using it, you must assign it to the MySQL user.
To do this: scroll down to the “Add user to database” section and select your MySQL username. Then select the newly created database.
To continue the process, click on the “Add” button.
After that, Cpanel will grant MySQL users all the privileges in the newly created database.
Now that the new database has been created, you can open phpMyAdmin through your cPanel dashboard.
Select the created database and click on the “Import” button in the main menu.
Then click on the “Choose File” button and select the .mysql file that you downloaded earlier and click on the “Continue” button – “Go”.
PhpMyAdmin will download this file from your computer and import it into the database. When finished, you will see a message about the successful completion of the process.
Hope this article helped you figure out how to make a copy of your WordPress database via phpMyAdmin.
If you are looking for a more efficient way to backup and manage your site, then check out our list of the best WordPress backup plugins .
If you liked this article, then please don’t forget to like it. Subscribe to my YouTube channel, find me on social media.