If you have an established website with lots of content, one day you may need to make some global updates to the data in your WordPress database tables. You might be lucky and a particular WordPress plugin may have an admin panel so you can make the required changes, but usually the admin panel does not cater for the case when you need to make hundreds of similar updates to lots of fields. This phpMyAdmin tutorial will show you exactly how to use this tool to update values in a MySQL database in a WordPress website.
WordPress or a WordPress plugin does not have a nice GUI so it’s impossible to easily make some global changes to the data in your WordPress database. e.g. This can be a big problem if you need to increase all the prices in your online store.
WordPress uses the MySQL database and one of the benefits of MySQL is that you can easily export or import data into any MySQL database table (or even the entire database). You might not know that there is a great tool called phpMyAdmin that you can use to do all the exporting and importing of data. You can access phpMyAdmin from your cPanel (most hosting providers offer cPanel with your hosting account for free)..
For example, you might need to:
- Export all your product details from a particular WordPress plugin to a CSV file.
- Increase all the prices in your eCommerce store by 10%.
- Modify links globally across the entire database.
- Update email addresses globally across the entire database.
- and so on…
It is extremely easy to use phpMyAdmin, so I created this tutorial that shows you how to use the phpMyAdmin tool. Once you learn how to use this tool you will be able to make all sorts of changes to your data quite easily.
Like the quality of the screencast? I use the Screenflow app for it!
In this tutorial I will show you how to:
- Make backups of your database so you will be fine in case you need to reload the original data back into the database.
- Export all the data from the relevant database table into a text file.
- Manipulate the data in the text file.
- Import the modified text file data back into the database.
Don’t be intimidated by phpMyAdmin. If you take the proper precautions and backup your database first, no matter what happens, you can just reload the old database backup.
Questions / Problems?
Add your questions to the comments below and I’ll help you.