Is there any way to purge whole data?

Using my Dolibarr
,
1

I was wondering if there are any ways to natively purge all SQL tables, after a while when it gets too big?
For example, if I need to purge all data for one year at the end of an year, is there any way to do it directly from Dolibarr?

2

Hi,

No it doesn’t exist

1 Like
3

Yes there is but not through dolibarr.
You can just go with your phpAdmin and transfare all the database. There are size and format restrictions for the exported file. You can extend it and I suggest you tou use an SQL format. If your have a lot of data you can choose 1 table each time or you can change the SQL statement for getting some (thousand) records each time. It was ok for me.
Check also www, I suppose that will be utility for very big database migration.

1 Like
4

Thank you for the reply. But I was looking for an inbuilt purge feature. :slightly_smiling_face:

5

Thanks :slightly_smiling_face: