Wich SQL to choose? upgr 138 to 139 or only sgl??

While I am just to import the 1.3.9c to my server, in a demo folder I have named differently, I notice that in the SQL folder there are two (2) different SQL:s. I am wondering over which one to choose.

They read like this, in the folder called "zc_install / sql/ ":

mysql_upgrade_zencart_138_to_139.sql

and

mysql_zencart.sql



Ps. I currently use version 1.3.8 for my webshop.

Thanks in advance

You should upload both files (actually the entire zc_install folder) to the server. But you should NOT execute them manually. You need to let zc_install process them as part of the database_upgrade menu choice.

Quote:

---

Originally Posted by stefanl

I notice that in the SQL folder there are two (2) different SQL:s. I am wondering over which one to choose.

They read like this, in the folder called "zc_install / sql/ ":

mysql_upgrade_zencart_138_to_139.sql

and

mysql_zencart.sql

---

Whatever you do, DON'T run the mysql_zencart.sql file directly. It will wipe out your existing database.

*** EDIT: Don't run SQL files manually at all. ***

Cheers
Rod

Thank you both,

My webhost server ask via PhpMyAdmin to choose "a" sql file, do you still mean I should select the folder? WIll Phpmyadmin actually admit a folder with sql files instead of a certain sql file?

Is there any 1,2,3 kids proof tutorial on this one?

When I upload to my demo folder I dont have 1.3.8 preinstalled as it is a "clean" databas, should I simply upload the 1.39c and play with it? See that it works?

When it works I still have the database WITH the 1.3.8 version. How will I go about really? I dont seem to understand entirely the procedure in the tutorials.

Thanks again and in advance

You should NOT be using phpMyAdmin to run ANY of the .sql files in zc_install.
Instead you should run zc_install/index.php in your browser, and choose the database-upgrade option.

Quote:

---

Originally Posted by DrByte

You should NOT be using phpMyAdmin to run ANY of the .sql files in zc_install.
Instead you should run zc_install/index.php in your browser, and choose the database-upgrade option.

---

Hi again,

Ok, but how do I run zc_install via my browser?

I mean my web host "tutorial" says I should upload the sql via phpmyadmin and choose sql. Now you say I shouldnt. I feel I am missing out on something that is very important and at the same time elementary. But so easy I dont get it :-)

What I feel I miss out on is to understand what I am missing. Allthough the dedicated posted tutorial threads explaining how to do this whole procedure is great in one way, they miss out to give me that little "key"-thing. Do you know of any thread that shows every step I need to do, and I mean every step, almost like if I was a kid.

I hear you and kind of understand what you mean and really appreciate that take time to help out, really do. I only feel that I need all these suggestions to fall into place.

Quote:

---

Originally Posted by stefanl

Hi again,

Ok, but how do I run zc_install via my browser?

What I feel I miss out on is to understand what I am missing. Allthough the thread explaining how to do this whole procedure they miss out to give me that little "key"-thing. Do you know of any thread that shows every step I need to do, and I mean every step, almost like if I was a kid.

I hear you and kind of understand what you mean and really appreciate that take time to help out, really do. I only feel that I need all these suggestions to fall into place.

---

This wiki tells you all step by step: http://www.zen-cart.com/wiki/index.php/Installation and http://www.zen-cart.com/wiki/index.p...tion_-_Upgrade

Add /zc_install to the end of the link to your demo folder and zc_install should start on its own.

Quote:

---

Originally Posted by frank18

This wiki tells you all step by step: http://www.zen-cart.com/wiki/index.php/Installation and http://www.zen-cart.com/wiki/index.p...tion_-_Upgrade

---

Hi,
Thanks but those are some of them that do miss that key-thing. Especially as they dont say what Sensei says - dont run sql via phpmyadmin

Quote:

---

Originally Posted by stefanl

Hi,
Thanks but those are some of them that do miss that key-thing. Especially as they dont say what Sensei says - dont run sql via phpmyadmin

---

stefanl, detailed upgrade instructions that help you retain your customizations while upgrading to new features, can be found in the installation zip file under the /docs/2.Readme-Upgrade.html file.

The 'key-thing' is to follow these instructions to a tee