Updating the MYSQL

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

export the whole thing

import the whole thing

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

DrByte:

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

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

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

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

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

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.

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.

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.

Well, if you run the installer and proceed in order, there is a Update Cfg Files button at the bottom of the first install page. I do that, enter all my settings (the last page is the db settings) and hit save, I get the error. The problem is I should then get the chance to upgrade my db after that db settings page, but never happens because the error (the install lists each step on the left hand side of the page and shows the db upgrade would be next).

So this must be a problem with the db or a specific table..maybe having to do with an outdated add-in module...

Anyone have a clue?

There are possibly FOUR buttons at the bottom of the System Inspection page:

• Install
• Upgrade Cfg Files
• Upgrade Database
• Refresh

You want "Upgrade Database". If it doesn't show, or is disabled, then the database-info in your configure.php file isn't pointing to a working set of Zen Cart database tables.