Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2006
    Location
    Largo, Florida USA
    Posts
    102
    Plugin Contributions
    0

    Default Making database small for moving site

    I am updating/moving a site that has been running for more than four years and now has over 4,000 products and 5,600 customers. Where can I trim the fat for this move in database? I am sure the majority of my older orders have incorrect emails, contacts that are not employed by company that bought items and so on.

    My PHP admin panel shows (110) next to database name.

    I have the Search Log and Email archive module installed, I used them to delete all but last 30 days of emails and all but 7 days of search log entries.

  2. #2
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,761
    Plugin Contributions
    9

    Default Re: Making database small for moving site

    I would not get rid of any of the historical information
    Zen-Venom Get Bitten

  3. #3
    Join Date
    Aug 2006
    Posts
    38
    Plugin Contributions
    0

    Default Re: Making database small for moving site

    I agree. I just moved my DB with 2500 products and it was less than 2.5mb of data. Adding in a few thousand customers and you're only looking at 10mb or so, right? Unless you have a super slow internet connection, I wouldn't sweat the extra seconds to import that file. :)

 

 

Similar Threads

  1. v151 Losing customer info when moving database from test site to live site
    By FunkyPapa in forum General Questions
    Replies: 3
    Last Post: 7 Oct 2013, 01:11 PM
  2. v139h Moving Site - Database Configuration?
    By kevinmc3 in forum General Questions
    Replies: 8
    Last Post: 27 May 2012, 11:46 PM
  3. Database large when moving site
    By Nile Hadwards in forum Installing on a Windows Server
    Replies: 1
    Last Post: 2 Mar 2011, 05:38 AM
  4. Moving Site - Cannot Use Same Database Prefix
    By creative in forum Installing on a Linux/Unix Server
    Replies: 5
    Last Post: 24 Nov 2009, 12:49 AM
  5. DataBase problem after moving site!!!!!!
    By PetesTown in forum Upgrading from 1.3.x to 1.3.9
    Replies: 17
    Last Post: 6 Nov 2008, 07:59 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