PhpMyAdmin tutorial for bloggers

PhpMyAdmin is very good tool to work with MySQL databases.It is popular web based interface for MySQL database administration.Most of the shared hosting account have PhpMyAdmin and most popular CMS are PHP MySQL based.So knowledge of PhpMyAdmin is indeed required.

All basic database operations can be performed using this tool.In this post I am outlining some of the most common functionality needed by new blogger or website owner.

Create Database using PhpMyAdmin

This is the most common operation performed using PhpMyAdmin.You will have to create a Database before installing any content management system like WordPress.Creating Database is very easy using PhpMyAdmin.

Start PhpMyAdmin and Click on Databases tab.You will be able to see window as shown in below image.Enter name of the database (example in below image) and choose collation as shown in picture or according to your requirement.Click on create button.This is it.You have created your first database.

Create Database PhpMyAdmin

Create Database PhpMyAdmin

Copy Database using PhpMyAdmin

You should create a backup database.In case you messed up your current or main database you can copy from backup database.You can also restore your main database with backup file but it is easier and faster to backup from a database.So I have also included this task in this tutorial.Follow below steps to copy database using PhpMyAdmin

On the first screen of PhpMyAdmin select the source database to be copied (i.e if the database src_data is to be copied to dest_data then select src_data database on this screen). Click on the database name to select it.

After selecting the database next screen shows all the tables present in the database under the tab Structure as shown in below picture

PhpMyadmin Structure tab on database screen

PhpMyadmin Structure tab on database screen

Click on the tab Operations.Below screen will be presented

PhpMyadmin Operations tab on database screen first

PhpMyadmin Operations tab on database screen1

Enter the destination database (for example dest_data) where the data from source database is to be copied and choose the options as below.

PhpMyadmin Operations tab on database screen

PhpMyadmin Operations tab on database screen

Click on go button to copy the database.

Backup Database using PhpMyAdmin

It is always a good practice to periodically backup your database.All content management systems like WordPress store almost all data in database tables.So you should backup your database so that you can restore your site to latest state in case of any issues.

Your web host will be taking backups but it is periodic.I would suggest you to backup after major updates or creating quite a number of posts.Having said enough about importance of backing up your database lets see the process using PhpMyAdmin.There are plugins for this task but it is better not to use plugins for simple tasks like this.Less plugins is good for performance.

  • Select the database you want to backup from list of databases on your PhpMyAdmin panel
  • Click on Export option as shown in the image below and select the options as shown

PhpMyadmin Operations tab on database screen

database-backup-phpmyadmin-export

  • Click on the Go button for backup to start.

Restore Database using PhpMyAdmin

You have devoted your time and effort to create this lovely website of yours.But if there is a small security hole then not so good people will jump and mess up your website.Once the website is messed up the best option is to delete everything and start fresh.

The situation becomes worst if you do not have latest backup.You loss some of your recent contents in that case.Producing the content is rework for you.Now with backup you can easily restore using below steps.

  • Select the database in which you want to insert data from list of databases on your PhpMyAdmin panel
  • Click on Import option as shown in the image below and select the options as shown.The character set option should be same as that of file from which data is to be loaded.

Database load PhpMyAdmin import

database-load-phpmyadmin-import

  • Click on the Go button to load the database.

What’s Next

These are the most common operations I can think of right now.But I will update the post with more operations in near future.You can also suggest using comment form below.Consider sharing the post if it helped you.

4 thoughts on “PhpMyAdmin tutorial for bloggers

    • thanks

  1. mam! I need some data type in a Table with “TEXT” attribute . yes It working, but these all rows direct become “Primary Keys” this can not save duplicate values . Please fix this and reply . “Matter : To store paragraphs with duplicate values” thank You !

    • In a field declared as primary key you can not have duplicate value it is not PhpMyAdmin issue it is RDBMS functionality..Hope I understood your problem

Leave a Comment