phpMyadmin imports

[Parafanaylya]

I need my attributes, customers, and sales records from my old ZC1.2.7 site in my 1.3 site.

Do I delete the existing fields through PHPMYADMIN, export from the old site to desktop, and then upload?

[Absolute]

Are the two databases on the same server? Is your 1.3 a fresh install or does it have records already in it? Are you just changing the store from 1.27 to 1.3?

The reason is that if you go to the install index.php, there is an update you can run on the database to convert from 1.2.7 to 1.3.0. This should solve your problem, howe ver, only do this if you are no longer using your 1,2,7 database for the old store.

The easiest way to do it if you are using the same server for both is to copy the entire database using phpMyAdmin, and call it something like zen130, and then run the install database update on zen130 database.

Would this work for you, or are you using different servers?

Word of advice though - backup your database completely before you try and perform and operations - just in case.

Absolute

[Parafanaylya]

Hello Absolute

Old & new on same server - the old database has lotsa stuff that's not going on the new site. The new database already has lotsa stuff uploaded already. I did my first ZC site like a bull in a china shop - it's a mess as far as images go, and I've also decided to drop products from the site.

My new site has been correctly structured regarding images (3 sizes) and image sharing is done eg category x has x/img.jpg images and category y shares that image.

What I want to import is attributes, sales and customers. I've also picked up on a thread upgrading your zen cart/upgrading from 1.2+ to 1.3+/phpmyadmin

Something there maybe good?

parafanaylya

[Parafanaylya]

Are the two databases on the same server? Is your 1.3 a fresh install or does it have records already in it? Are you just changing the store from 1.27 to 1.3?

The reason is that if you go to the install index.php, there is an update you can run on the database to convert from 1.2.7 to 1.3.0. This should solve your problem, howe ver, only do this if you are no longer using your 1,2,7 database for the old store.

The easiest way to do it if you are using the same server for both is to copy the entire database using phpMyAdmin, and call it something like zen130, and then run the install database update on zen130 database.

Would this work for you, or are you using different servers?

Word of advice though - backup your database completely before you try and perform and operations - just in case.

Absolute

Fresh install

[Parafanaylya]

Hello again Absolute

I'm getting stuck a little

I have used the IP address given to me by my host, and also used the cpanel URL and the http://mydomain:2082, but it won't connect. The other settings are port 3306 and connection type is direct. I'm on broadband, OS is Win2K?

parafanaylya

[DrByte]

Instructions for Selective Database Backup which may help you identify which tables to transfer after you've upgraded a copy of your old 127 site to 1.3.x format (which you need to do before copying data over, or you'll end up with SQL errors trying to import into your real 1.3.x database).

[DrByte]

I'm getting stuck a little

I have used the IP address given to me by my host, and also used the cpanel URL and the http://mydomain:2082, but it won't connect.

suggest you talk to your host...

[Merlinpa1969]

Hey pat,

your cpanel login can be easily reached by logging into camelot and hitting the cpanel link.



Make a copy of the zen 1.2.7 DB in a seperate DB

apply the patches from the zc_install file....

for 127 to 1.3 and 1.3 to 1.3.0.1

then go to export in the top

select the tables you want to export....

tell it to add drop tables and complete inserts.....

and download it as a file....

now open the 1.3 DB
hit import

browse to the file you just downloaded....

hit go voila customers orders products categories are all in place