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?
database shows many table backups, why?
Re: database shows many table backups, why?
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.
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.
Any help offered comes with the best of intentions. Use it at your own risk. In any case, please make a backup of your existing environment before applying any changes.
Re: database shows many table backups, why?
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.
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.