Zen Cart Logo
Forums / General Questions / Import customer details only into database

Import customer details only into database

Locked

Views: 1,084

Results 1 to 7 of 7
This thread is locked. New replies are disabled.
17 Dec 2010, 4:58 PM
#1
mcpisik avatar

mcpisik

Zen Follower

Join Date:
Jan 2007
Location:
Mount Maunganui, New Zealand
Posts:
417
Plugin Contributions:
0

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)

17 Dec 2010, 6:48 PM
#2
get_em_fast avatar

get_em_fast

Totally Zenned

Join Date:
Dec 2006
Location:
Seligman, MO U.S.A.
Posts:
2,072
Plugin Contributions:
1

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

17 Dec 2010, 7:30 PM
#3
mcpisik avatar

mcpisik

Zen Follower

Join Date:
Jan 2007
Location:
Mount Maunganui, New Zealand
Posts:
417
Plugin Contributions:
0

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...
:smile:
Any ideas on just the customer parts?

18 Dec 2010, 6:29 PM
#4
hamid84 avatar

hamid84

Zen Follower

Join Date:
Feb 2007
Location:
Walsall
Posts:
223
Plugin Contributions:
0

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

18 Dec 2010, 6:44 PM
#5
mcpisik avatar

mcpisik

Zen Follower

Join Date:
Jan 2007
Location:
Mount Maunganui, New Zealand
Posts:
417
Plugin Contributions:
0

Re: Import customer details only into database

hamid84:

I completed this mission a few months ago...
Excellent thanks.
I might be in touch soon! :smile:

28 Dec 2010, 4:21 PM
#6
mcpisik avatar

mcpisik

Zen Follower

Join Date:
Jan 2007
Location:
Mount Maunganui, New Zealand
Posts:
417
Plugin Contributions:
0

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!

28 Dec 2010, 4:48 PM
#7
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

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