Updating the MYSQL

[Darkwander]

Greetings all:

I am currently running a shop on my webspace called "Store", it is using the database "Zencart", while this is still running, i have installed the new Zencart on another directory called "Shop" and it is using the database "Store".

What i want to know is if i can export the MYSQL files from PHPAdmin and import them in the new Database.

If i can which files do i need to export for things like;

Customers, Orders, Categories, Product, Product codes, etc.

The old version is: 1.2.5

The new Version is: 1.3.5

[DrByte]

export the whole thing

import the whole thing

run zc_install and choose database-upgrade to bring the database structure up-to-date

[Darkwander]

export the whole thing

import the whole thing

run zc_install and choose database-upgrade to bring the database structure up-to-date

Thanks, worked like a charm...

[Darkwander]

Crap, spoke too soon....

I am getting this error when i am tryng to access the Admin Panel..

1146 Table 'delights_store.zencart_project_version' doesn't exist

[Darkwander]

OKey, i got it working.

I re-ran the install program, this time i updated the config files, then updated the database again and it is working sweet...

[tcustomgolf]

As an addition to this post, as I had the same problem:

Running 1.2.7;
Installed 1.3.5 on server in new directory with new DB;
Dropped all tables in new DB;
Exported 1.2.7 DB;
Imported 1.2.7 DB into new empty 1.3.5 DB;
get error below...

1146 Table 'tcustom_zen135.configuration' doesn't exist
in: [update configuration set configuration_value='/home2/tcustom/public_html/zen135/cache' where configuration_key='SESSION_WRITE_DIRECTORY']

Looking at some of the forum posts, could this be related to a mod that is not recognized by 1.3.5??

Any help would be appreciated as I'm trying to populate 1.3.5 with my 1.2.7 products for testing...

[Darkwander]

Did you try updating the Config files as well , when you updated the database ?

[tcustomgolf]

After exporting the 1.2.7 db and importing into the empty 1.3.5 db, I changed the config files to write (CHMOD 777), else I couldn't pass the install checks for 1.3.5. I checked the configs after failing the upgrade and they seem to have all the proper calls to the new DB (username, pw, dn name, etc. as they should because when I installed 1.3.5 initially, these have to be set.)

Also, checking phpmyadmin, all the tables came into the new db when I restored from the 1.2.7 backup, and the configuration table seemed fine...the structure looks like all the others.

[tcustomgolf]

After exporting the 1.2.7 db and importing into the empty 1.3.5 db, I changed the config files to write (CHMOD 777), else I couldn't pass the install checks for the 1.3.5 install. I checked the configs after failing the upgrade and they seem to have all the proper calls to the new DB (username, pw, dn name, etc. as they should because when I installed 1.3.5 initially, these have to be set.)

Also, checking phpmyadmin, all the tables came into the new db when I restored from the 1.2.7 backup, and the configuration table seemed fine...the structure looks like all the others.

[Darkwander]

When you are doing the Update, there are two things to do,

One is to run "Update Database" and the other is "Update Config".

Personally i know think the order would matter, but i Ran the config files, then updated the Database.

Try that.