If this is your first visit, check our documentation. To post, register or login.
Forums / General Questions / Backup-Restore Problem - upgraded shop

Backup-Restore Problem - upgraded shop

Locked

Started by tphoare on 7 Nov 2006, 1:36 PM · Views: 1,490

Results 1 to 2 of 2
This thread is locked. New replies are disabled.
7 Nov 2006, 1:36 PM
#1
tphoare avatar

tphoare

New Zenner

Join Date:
Sep 2005
Location:
London
Posts:
88
Plugin Contributions:
0

Backup-Restore Problem - upgraded shop

I'm having real problems backing up and migrating data from a 1.2.7 shop to 1.3.6.

I have tried PHPAdmin and MySql-front but everything seems to stall while trying to import admin_activity_log. I have tried backing up and restoring this table separately but it just seems too big.

Is there any harm simply emptying it? - it seems to me simply to be a log without any other dependent relational bits.

Are there any other large tables that are likely to give problems and if so what can I do?

Any help greatly appreciated.

7 Nov 2006, 3:19 PM
#2
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,512
Plugin Contributions:
176

Re: Backup-Restore Problem - upgraded shop

The largest tables will be admin_activity_log, email_history (if you have email archiving enabled), and user_tracking (if you have that mod installed).
If you don't care to retain that data, you're safe to exclude it during backup/restore.
The admin activity log simply tracks all activity done in the admin area ... an audit trail of sorts. Mainly intended to assist if there were ever credit card fraud on your site, but useful for some troubleshooting issues on occasion.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.