Mysql Database truncate

I using mysql workbench to view those mariadb data , but can i use mysql workbench to truncate / remove all data from the database, will it cause the erpnext not function well ? The reason i want to truncate is a lot of test data present inside.

Or any proper way to do it ?

Any help from u guys ? Thanks in advance

hi, check out this https://frappe.github.io/erpnext/user/manual/en/setting-up/articles/delete-a-company-and-all-related-transactions

I read same problem in the forum, there is better to create new site for the same bench,

I do not fully understand the flow, i have made changes which i wish to reflected on the new site, how can i do it ?

Anyone please point some approach?

Hi @Randy_Lowery,

I have tried the answer you gave, but those master data is not deleted by using the method you mentioned.

In result, i just deleted those master data manually.

@jcyh,

You can use the bench --site your_sitename reinstall command to delete all the data from the database. It will reinstall installed app in your site

Thanks,
Makarand