Editing and Managing WordPress Database files are really useful sometimes and require a perfect knowledge and a surely create a Database Backup before making changes or else you can loose your work done So Far…
What do we need to make changes in WordPress Database?
Well, there might be some Plugins available which can help you regarding making changes in your WordPress Database but It is not recommend using WordPress Plugins for every work. In fact we can do this easily by using PhpmyAdmin tool which is available in our Cpanel or you can download it for your Computer Machine.
Why do we need to make changes in our MySql Database?
It is very important to Edit and Manage WordPress Database tables when we bring our WordPress to a new level with large number of pages and posts. Sometimes we are required to search and find some posts or postmeta which is required to be edited or deleted.
Secondly, if you are Installing Multiple WordPress Sites with Single MySql Database, then you are required to makes changes in WordPress MySql Database to keep the old database merged with the new one…
What things to be kept in mind while changing MySql Database?
You must have a last Database Back-Up file downloaded, so that in case if something happens wrong you can manage it once again.
You must have Cpanel access and/or Database details with permissions to make changes in the MySql Database.
You must take all the responsibility if something happens wrong and you are unable to revert it back in case you don’t have a Backup file. (Try contacting hosting service provider they might have the last back up for you stored in their back up process)
You must have some basic knowledge to understand where and when you are making changes, this consists reading Rows & Columns.
How to Make Changes in MySql Database via Cpanel?
Firstly, Login to Cpanel and go to PHP My Admin option.
This will take you to a new window with the PhP My Admin logged with your all Databases of all Websites (in case multiple sites are installed).
As shown in the above image from the left section you can choose the MySql Database which is required to be changed accordingly.
As soon as you choose the correct Database which is needed to be modified it will show something like this (shown in the above image).
Later you can click (from either side) on the particular table which needs to be modified. Eg. wp_posts
As soon as you click on the table which needs to be changed or modified you will see list of rows as shown in the above image. From where you can start editing your Database Tables, which can be editing in 2 ways:
1st you can double click on the column if you are required to make changes in just a single column which when done will show something like this (as shown in the below image).
2ndly you can click on the edit button to make changes in the entire row which will show something like this (as shown in the below image).
Finally, to make bulk changes i.e. deleting or removing the entire table(s) or any other available options you can just check the boxes before the tables on which action is needed and click on with selected.
This procedure can be used for backing up some tables or entire backups or replacing Tables prefixes or even to Optimize WordPress Database Tables.
Note: Please do keep the back and make necessary changes only or else your site may stop working properly. contact me if you need some help…