Resetting a database the hard way

When working with programs such as WordPress, PrestaShop or even custom coded ones you sometimes need to do manual work within the databases. This may mean having to perform testing with existing data and altering the content or even clearing the database altogether. One of the more common things to do during testing and development is a manual reset of the entire database. This can be performed by deleting the database completely and then re-creating it via cPanel. It then involves re-attaching the users and ensuring their passwords and permissions are correct.

An easier way

A shorter way to handle this is to use the phpMyAdmin tool to remove all the tables at once. This leaves the database and all users in place. The passwords and permissions remain and do not need to be reset in the process. Below we demonstrate how to use the phpMyAdmin tool to quickly reset a database.

How to reset a database in phpMyAdmin

  1. Log into your cPanel interface.
  2. From the main cPanel screen, look for the Databases category and then click on the phpMyAdmin tool.
  3. This opens the phpMyAdmin tool. Click on the Databases tab at the top of the page. This lists all the databases on the account. Find the database you want to work with and click on it.
  4. The next screen lists all the tables in the database. Scroll to the bottom and click on the Check all checkbox.
  5. Next to the Check All checkbox isa dropdown list for commands. Find and click on the Drop option.
  6. You will then be presented with a confirmation screen that displays the SQL Query phpMyAdmin will run. Click on the Yes button to confirm and run the query.
  7. After the query runs, the tables will be removed from the list. You should see a message at the top that says "No tables found in database". This means the database is empty.

Now that your database is empty you can continue with your testing, whether it is running a .sql file within phpMyAdmin or performing a manual installation where you need an empty database.

Did you find this article helpful?

We value your feedback!

Why was this article not helpful? (Check all that apply)
The article is too difficult or too technical to follow.
There is a step or detail missing from the instructions.
The information is incorrect or out-of-date.
It does not resolve the question/problem I have.
How did you find this article?
Please tell us how we can improve this article:
Email Address
Name

new! - Enter your name and email address above and we will post your feedback in the comments on this page!

Related Questions

Here are a few questions related to this article that our customers have asked:
Ooops! It looks like there are no questions about this page.
Would you like to ask a question about this page? If so, click the button below!
Ask a Question

Post a Comment

Name:
Email Address:
Phone Number:
Comment:
Submit

Please note: Your name and comment will be displayed, but we will not show your email address.

0 Questions & Comments

Post a comment

Back to first comment | top

Need more Help?

Search

Ask the Community!

Get help with your questions from our community of like-minded hosting users and InMotion Hosting Staff.

Current Customers

Chat: Click to Chat Now E-mail: support@InMotionHosting.com
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!