database shows many table backups, why?

If you're a new user of AppGini, feel free to ask general usage questions, or look for answers here.
Post Reply
mgoetze
Posts: 23
Joined: 2014-12-02 06:59

database shows many table backups, why?

Post by mgoetze » 2020-01-16 23:52

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?

pbottcher
AppGini Super Hero
AppGini Super Hero
Posts: 1635
Joined: 2018-04-01 10:12

Re: database shows many table backups, why?

Post by pbottcher » 2020-01-17 06:38

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.
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.

mgoetze
Posts: 23
Joined: 2014-12-02 06:59

Re: database shows many table backups, why?

Post by mgoetze » 2020-01-17 07:10

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.

Post Reply