How to clear database

[hanaffekamis]

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

[Damian Culotta]

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?

[hanaffekamis]

Hi Damian Culotta

Thank for the reply.

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

Or is there any video tutorial?

Thank you .

[Damian Culotta]

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.