If this is your first visit, check our documentation. To post, register or login.
Forums / General Questions / copying products over to a new site problems

copying products over to a new site problems

Locked

Started by jonnyboy22 on 31 Jan 2009, 2:34 PM · Views: 834

Results 1 to 7 of 7
This thread is locked. New replies are disabled.
31 Jan 2009, 2:34 PM
#1
jonnyboy22 avatar

jonnyboy22

Zen Follower

Join Date:
Jun 2008
Location:
Sheffield South Yorkshire
Posts:
165
Plugin Contributions:
1

copying products over to a new site problems

hello,

i have an new site and i want to copy my products over from my old site.

I cant install any mods etc on my old site as it has a limited admin modifictaion installed and i dont have FTP or phpmyadmin access.

I do have the httpdocs and a sql database in a backup

ive tried creating a new zencart install and then inserting the database over it then changing the config.php files but something always seems to go wrong. either my products dont show up or they do but not in any catagories.

What tables from the database do i need to copy over to my new database to copy my products over?

Im not to bothered about attributes as i can quickly re-add these. its mainly the products descriptions and catagories etc.

Thanks in advance guys.

I also have another question http://www.zen-cart.com/forum/showthread.php?t=118876 regards combining search options.

Want to switch servers? see our how to migrate Zencart guide
Supercharge your website with our **Fast Zencart Hosting**

31 Jan 2009, 5:06 PM
#2
kobra avatar

kobra

Black Belt

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

Re: copying products over to a new site problems

I cant install any mods etc on my old site as it has a limited admin modifictaion installed and i dont have FTP or phpmyadmin access.
How are you expected to manage this without the proper tools?

Zen-Venom Get Bitten

31 Jan 2009, 5:32 PM
#3
jonnyboy22 avatar

jonnyboy22

Zen Follower

Join Date:
Jun 2008
Location:
Sheffield South Yorkshire
Posts:
165
Plugin Contributions:
1

Re: copying products over to a new site problems

I have the sql file.

is their not a way to insert bits of the sql file? e.g products_description

Want to switch servers? see our how to migrate Zencart guide
Supercharge your website with our **Fast Zencart Hosting**

31 Jan 2009, 6:51 PM
#4
kobra avatar

kobra

Black Belt

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

Re: copying products over to a new site problems

is their not a way to insert bits of the sql file? e.g products_description
How adept are you at sql?
do you have shell access?
do you know cmd line linux commands?

Zen-Venom Get Bitten

1 Feb 2009, 12:25 AM
#5
jonnyboy22 avatar

jonnyboy22

Zen Follower

Join Date:
Jun 2008
Location:
Sheffield South Yorkshire
Posts:
165
Plugin Contributions:
1

Re: copying products over to a new site problems

How adept are you at sql?
not 2 bad (i do web design for a living)
do you have shell access?
yes
do you know cmd line linux commands?
no

Want to switch servers? see our how to migrate Zencart guide
Supercharge your website with our **Fast Zencart Hosting**

1 Feb 2009, 12:31 AM
#6
kobra avatar

kobra

Black Belt

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

Re: copying products over to a new site problems

do you know cmd line linux commands?
no
You were doing good right til this....
There are mysql cmd's that can be run through shell...

Did not ask why you do not have something like phpmyadmin?? This would be much simpler to tutor

Zen-Venom Get Bitten

1 Feb 2009, 5:53 PM
#7
jonnyboy22 avatar

jonnyboy22

Zen Follower

Join Date:
Jun 2008
Location:
Sheffield South Yorkshire
Posts:
165
Plugin Contributions:
1

Re: copying products over to a new site problems

Did not ask why you do not have something like phpmyadmin?? This would be much simpler to tutor

the guy who owned the site before had several sites all running on the same sql server, just in different tables, thus if he game me the password etc i could in theory edit someone elses zencart database.

either way i managed to install the sql backup via phpmyadmin on a test site, then install easypopulate, backup the products and then using easy pop install the products on my new site.

long winded way of doing it but its worked.
thank for your help.

Jonathan

Want to switch servers? see our how to migrate Zencart guide
Supercharge your website with our **Fast Zencart Hosting**