Results 1 to 7 of 7
  1. #1
    Join Date
    Jan 2007
    Location
    Mount Maunganui, New Zealand
    Posts
    419
    Plugin Contributions
    0

    Default Import customer details only into database

    Hi,
    I'd like to upgrade from 1.3.8 to the latest version.

    My database is a whopping 4gb or so.
    (I have optimized the database)
    Therefore I'd like to import only the customer accounts and orders.

    Is this possible and easy to do?

    (I know I'll be in for a lot of work in recreating the products, but its reached that time....unless I should wait for 2.0? gulp)

  2. #2
    Join Date
    Dec 2006
    Location
    Seligman, MO U.S.A.
    Posts
    2,101
    Plugin Contributions
    5

    Default Re: Import customer details only into database

    Even though your database is large, why not import the whole thing, so you will have all of your customers, orders, products............EVERYTHING?..............just asking...................
    Teach them to shop and they will shop today;
    Teach them to Zen and they will OWN a shop tomorrow!

  3. #3
    Join Date
    Jan 2007
    Location
    Mount Maunganui, New Zealand
    Posts
    419
    Plugin Contributions
    0

    Default Re: Import customer details only into database

    (edit: database is 8mb not 4 gb....day dreaming)

    It contains a lot of modules that were added to try out, but are not used, and I'm sure that's where half of the database size comes from.
    Would a massive database not slow things down a tad?
    We get a lot of page views so the faster the better...

    Any ideas on just the customer parts?

  4. #4
    Join Date
    Feb 2007
    Location
    Walsall
    Posts
    222
    Plugin Contributions
    0

    Default Re: Import customer details only into database

    I completed this mission a few months ago.

    Here is my thread http://www.zen-cart.com/forum/showthread.php?t=165208

  5. #5
    Join Date
    Jan 2007
    Location
    Mount Maunganui, New Zealand
    Posts
    419
    Plugin Contributions
    0

    Default Re: Import customer details only into database

    Quote Originally Posted by hamid84 View Post
    I completed this mission a few months ago...
    Excellent thanks.
    I might be in touch soon!

  6. #6
    Join Date
    Jan 2007
    Location
    Mount Maunganui, New Zealand
    Posts
    419
    Plugin Contributions
    0

    Default Re: Import customer details only into database

    Can anyone tell me how to import single fields with phpmyadmin?

    I have a full database backup from an old store and only want to import customer fields and products.

    (don't worry about why...)

    Thanks!

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

    Default Re: Import customer details only into database

    It contains a lot of modules that were added to try out, but are not used,

    Is this possible and easy to do?
    Basically NO, not easy

    If all you are wanting is to remove addons

    Make a backup first

    frop any tables they added, and remove any files and if they touched core files replace with originals

    Then use the full DB
    Zen-Venom Get Bitten

 

 

Similar Threads

  1. Can I import a 1.3.7 Database into 1.3.8?
    By Big_Woody in forum Upgrading from 1.3.x to 1.3.9
    Replies: 1
    Last Post: 13 Feb 2010, 12:03 AM
  2. How to export customer database and import them into outlook?
    By kimsonvu in forum General Questions
    Replies: 1
    Last Post: 1 Dec 2008, 08:18 AM
  3. Possible to import only customer data into a new install
    By Mark Kidd in forum Upgrading from 1.3.x to 1.3.9
    Replies: 5
    Last Post: 12 Jul 2008, 02:08 AM
  4. I import database but still no details show
    By icklebits in forum Upgrading from 1.3.x to 1.3.9
    Replies: 18
    Last Post: 7 Jun 2007, 12:56 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