Page 1 of 1

database shows many table backups, why?

Posted: 2020-01-16 23:52
by mgoetze
I noticed today inside Phpmyadmin that many of our tables are duplicated with the suffix "backup_date_stamp" so for example we have a table called product experts and it looks like this in pHPmyadmin

product_experts
product_experts_backup_20151123020614
product_experts_backup_20151123020902
product_experts_backup_20151123021032

Is it safe to drop these tables?

Anyone know why they exist or what created them?

Re: database shows many table backups, why?

Posted: 2020-01-17 06:38
by pbottcher
Hi,

as a guess. Did you upload data through the import mechanism? This will per default create such backups.
So it is safe to remove them from your database if you do not need this "old" data anymore.

Re: database shows many table backups, why?

Posted: 2020-01-17 07:10
by mgoetze
No, never used the import feature.

I will probably just leave them for now, since they are not bothering anything. I was just curious where they came from. Perhaps @a.gneady can advise us.