cancel
Showing results for 
Search instead for 
Did you mean: 

How to clear database

How to clear database

Hello can someone guide me how to delete database so that I can start over again. I would like to clear all the products, categories, orders, etc. I would like to start new from the beginning. Thank You

3 REPLIES

Re: How to clear database

Hi @hanaffekamis,

 

First of all, remember to perform a backup (just in case you need to restore something).

If you need to delete the whole database maybe the easiest way is using the mysql console (or phpmyadmin or another similar tool), and execute:

DROP DATABASE your_database_name; CREATE DATABASE your_database_name;

This will DELETE everything and then you'll create an empty database to start over with the installation process.

 

Is this what your are looking for?

 

--
If you've found one of my answers useful, please give "Kudos" or "Accept as Solution"

Re: How to clear database

Hi 

Thank for the reply.

Could you guide me step by step on how to do that?

Or is there any video tutorial?

Thank you .

Re: How to clear database

Hi @hanaffekamis,

 

If you're not sure how to access to your database I should recommend to get qualified support.

Normally hosting panels provide access to phpmyadmin (tool) to browse databases over your browser.

Another way is to use the server shell to perform those operations.

If you are not familiar with this two ideas/ways/methods; maybe you should request support to your hosting provider.

--
If you've found one of my answers useful, please give "Kudos" or "Accept as Solution"