Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2005
    Location
    London
    Posts
    95
    Plugin Contributions
    0

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

  2. #2
    Join Date
    Jan 2004
    Posts
    66,363
    Blog Entries
    7
    Plugin Contributions
    274

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

 

 

Similar Threads

  1. Restore sql from backup ZC
    By zcrt12345mm in forum General Questions
    Replies: 2
    Last Post: 28 Dec 2010, 07:45 PM
  2. backup and restore
    By marketimpact in forum General Questions
    Replies: 10
    Last Post: 25 Aug 2010, 10:28 AM
  3. Backup/Restore/Move ZC issue
    By isbrucker in forum Installing on a Linux/Unix Server
    Replies: 1
    Last Post: 17 Sep 2007, 11:45 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR