WordPress Blog’s use MySQL Database to store whole information like your blog posts, comments, etc. If you’re a Professional Blogger then you’re constantly updating your blog with at least 4 blog posts a day and this data directly stored in MySQL database which you don’t want to lose at any condition, so it’s necessary for you to keep up the regular backups of your data to protect it from any loss or damage. Already I had covered a lot on the database from installing to deleting a database by using PHPMyAdmin. Now, this post focus on “how-to back-up the WordPress Database By Using PHPMyAdmin”. [Read more…] about [How-To Guide] Back-Up WordPress Database By Using PHPMyAdmin
Tutorials
[How-To Guide] Delete MySQL Database
Already in earlier article, I have provided you a step-by-step guide in creating a new user in MySQL database. Now, this post focus on deleting MySQL database.
Step1: Click on MySQL Database.
Step2: After clicking on MySQL Database, you will find the names of all your current databases. Click on “Delete Database”, to delete the required database.
Step3: Now it will ask for permission to delete the database as shown below:
Step4: After granting the permission, you’ve successfully deleted the database.
In this way you can easily delete a database and if you face any problem then do let us know in the comments section? In the meanwhile you might be interested in reading in these articles:
Install MySQL Offline On Your PC
Configure MySQL Offline On Your PC
Checking MySQL Installation Works On PC or Not?
Repair And Optimize WordPress Database Using WordPress Hidden Feature
Optimize WordPress Database Using PHPMyAdmin
Repair WordPress Database Using PHPMyAdmin
[How-To Guide] Create New User In MySQL Database
MySQL, most popular database which allows you to run content-driven websites. MySQL database managed by using third-party programs such as PHPMyAdmin because it offers you a quick and easy database administration process. Already I had provided you lots of guides on MYSQL Database from installation to some advanced level. Here is a quick round-up of all the posts.
Install MySQL Offline On Your PC
Configure MySQL Offline On Your PC
Checking MySQL Installation Works On PC or Not?
Repair And Optimize WordPress Database Using WordPress Hidden Feature
Optimize WordPress Database Using PHPMyAdmin
Repair WordPress Database Using PHPMyAdmin
Top WordPress Plugin To Optimize WordPress Database
All these posts help you out in getting friendlier with MYSQL database. This post focus on creating a new user in MySQL. Follow the step-by-step guide to create user.
Step1: Open your cPanel, under it click on MySQL Database option as shown below:
Step2: After clicking on MySQL database, it will open a new page. Now scroll down and you see the “MySQL Users” as shown below in screen-shot:
Step3: After clicking on “Create User” button a new user-created and it looks like this:
Step4: The new database user will be “cpanelusernmae_admin” (admin is the username of that database you’ve created).
Step5: Now click on “Add” button to “Add User to Database” as shown below:
Step6: Now select the privileges you assign to this user and after assigning privileges click on “Make Changes” button.
Step7: Congratulations, you have successfully added new user to database.
This tutorial guides you in creating more users to your database.
If you face any problems then let us know in the comments section. To get all the latest information you can follow us on Twitter
[How-To Guide] Repair WordPress Database Using PHPMyAdmin
Already, in earlier articles I had provided you a step-by-step guide on Repairing and Optimizing your WordPress driven website without using any plugin and Optimizing WordPress Database using PHPMyAdmin. Continuing on same series of posts, this post focus on Repairing WordPress Database using PHPMyAdmin.
Step1: Login to your WordPress Database using PHPMyAdmin.
Step2: Now select the database which you want to repair. Click on “Check tables having overhead” option to select the right tables.
Step3: From drop down menu, select the menu item which says “Repair table”, this will repair the table.
Step4: After selecting “Repair table” option, this will repair the database and will be look like this:
PHPMyAdmin is the easiest way to repair the database tables without adding plugin load to your WordPress site.
Note: Before applying this tutorial back-up your database and never click on options like Drop, Empty because they will ruin your database and create problem so be careful.
Finally in the end do let us know in the comments section, if you faced any problem?
[How-To Guide] Optimize WordPress Database Using PHPMyAdmin
Already I had provided you a step-by-step guide on repairing and optimizing your WordPress driven website without using any plugin. This article focus on optimizing WordPress Database by using PHPMyAdmin.
PHPMyAdmin, free software tool written in PHP and made to handle administration MYSQL over world-wide web.
Step1: Login to your WordPress Database using PHPMyAdmin
Step2: Select the right database, if there is only one database then it would be chosen by default.
Step3: Now click on “check tables having overhead” option and select the proper table as shown below:
Step4: From drop down menu (as indicated above in screen-shot), select the menu item which says “Optimize table”. This will optimize the tables which is shown below:
PHPMyAdmin is the easiest way to optimize the overheads of your database without adding plugin load to your WordPress site.
Note: Before applying this tutorial back-up your database and never click on options like Drop, Empty because they will ruin your database and creates a problem so be careful.
Finally in the end do let us know in the comments section, if you faced any problem?