3 Points How To Utilize phpMyAdmin for Blog

It is the part of my journey to reduce more WordPress plugin in this blog. And now I will try to optimize a Cpanel feature which is easy to find in each web hosting Cpanel – phpMyAdmin. phpMyAdmin can be used as alternative tool for the database related WordPress plugin such as WP-DB-Backup. As you know, WP-DB-Backup is a WordPress Plugin that allow us to save WordPress database manually or automatically. Indeed, WP-DB Backup is a great useful WordPress plugin. However, We can optimize phpMyAdmin to replace the function of this plugin so we can remove it from our blog’s plugin list. And not only that, phpMyAdmin surely can do more.

In this blog post, I share three points about how to use phpMyAdmin in the term of blog database. I believe that this three points of phpMyAdmin usage is enough to cover all of our database related WordPress plugin so we can remove them from our blog for good. This is surely a big help for my less WordPress plugin blogging journey. Now, I can remove database related WordPress plugin from my blog and still able to do:

Point #1. DataBase Optimizing

As you know, database can slow our WordPress blog loading time. It is happened if our blog database is not well optimized. As you know, loading time is the important reason to keep our traffic since the readers surely will go away if our blog loading time is too long. Also that loading time is a factor for SERP determinant now – at least for the biggest search engine on the internet, Google. Therefore it is a must to make sure that our blog database is always well optimized. We can use phpMyAdmin to do this database optimizing work so it run lighter and faster.

Here how we can do it:

• Log in to Cpanel page

• Go to “Dabases” area

• Click “phpMyAdmin” icon

• Choose The Database to be optimized and click it

• In below of tables, click”Check tables having overhead”

• And then, select “Optimize table”

All overhead data is already removed which mean that the blog database is already optimized. In this optimizing, we remove all the non needed data from database so the database run lighter and faster which surely able to improve the whole of our blog’s performance significantly.

Point #2. DataBase Backup

Database backup is a must as part of blogging disaster recovery. Without database backup, it is almost impossible to recover from blogging disaster. We may have content data in office format but it is surely needed very big effort to recover our blog with only that data. In other hand, database backup can recover our blog in very easy and fast way. We only need to upload the data back into our blog database and our blog is recovered perfectly. We can do database backup easily by use phpMyAdmin.

Here how we can backup the blog database:

• Log in to Cpanel page

• Go to “Dabases” area

• Click “phpMyAdmin” icon

• Choose The Database to be optimized and click it

• In above, choose “Export” and click it

• In “Export” area, choose select all and SQL as format

• Choose “zipped” as compression method

• Leave the other setting as default and then click “Go” button in below

• The save window will pop up

• Follow the save steps until finish

The Blog Database is already backup successfully. Now, we already have the newest blog database in our backup file which will allow us to recover our blog database fast and easy in case of blogging disaster. We only need to upload it back to our blog database to recover our blog database perfectly.

Point #3. DataBase Problem Fixing

Database is the core of our blog for sure. The entire of our blog content is stored in the database. A broken database surely will lead us to blogging disaster. It is great that we already have database backup in our computer/laptop file so we can always fix database problem easy and fast. However, it is not so efficient to fix database problem by uploading the entire of database if the problem is only happened in single part (table) of database. It is far more efficient if we only fix the broken part. Fortunately, phpMyAdmin allow us to fix single broken part (table) of database easily without have to re-upload our database backup.

Here how we can do database fixing:

• Log in to Cpanel page

• Go to “Dabases” area

• Click “phpMyAdmin” icon

Choose The Database to be repaired and click it

• In table area, check the broken table.

• In below, select “Repair table”

The broken table is fixed without need to upload database backup – no need to recover the entire of database. This way is surely far more efficient if we face the single part (table) of database problem. It surely save a lot of time and effort if compare with re-uploading the entire of database backup.

Final Words

phpMyAdmin is surely a big help for us as bloggers to optimize our blog database. There are many things that can be done regarding the blog database. phpMyAdmin allows us to optimize, to back up, and to fix the blog database. With phpMyAdmin on our table, We as Bloggers surely no need database related WordPress plugin anymore to do database related task. In this blog post, I share how we can use phpMyAdmin to do three database related tasks for blog. I believe that there are many other usages of phpMyAdmin.

So if know other usages of phpMyAdmin, You could share it through comment form.
 
 
That’s all update this time, wait for next update!