Advice please! Which MySql and Which PHP

:happy: Hello

before I install Zen-Cart upon my server service, could I ask for some advice, as to which versions would be best suited to the needs of the software, Zen-Cart, and my needs to use it as a general store upon the web.

My provider (Hosting Service) allows for the selection of either version 4 or 5 of MySql.
And selection of version 4 or 5 of PHP.
Before using their panel to make a new database, I hope a kind soul upon the forum, may point me in the best direction.

Thanking you in advance

Dave

FAQ:

http://www.zen-cart.com/forum/faq.php?faq=server_requirements#faq_server_req

Hi

thanks for the reply "TheOracle" although I had read that FAQ before.

I was hoping for some feed back from people who had used "MySql5" and "PHP5" with their "Zen-Cart" powered Shops and Stores.

Before I install myself, as it always appears, to use the most current versions of any software is a good idea.

Thanks again

Dave:thumbsup:

My advice is to use the most up to date versions of PHP 4 and MySQL 4

There are people who always try to use the most up to date versions of everything, and they are the people whose websites fall over. Don't be first in the rush to try something new, let someone else do it and get burned, let the bug fixes and security patches be applied, and then use them.

PHP 5 is pretty stable now, but I still wouldn't touch MySQL 5.

Vger

as a host we use
php 4.4.2
mysql 4.1.2

stable and secure

Something else we have in common.

Vger

:smile: Hello

and thank you all for your replies. From the sound of things I am best advised to go for the version Fours .

Thank you all for your advice.

Dave
:thumbsup:

I just want to double check on the mySQL version. I know that Vger said he wouldn't touch mySQL 5, but what I need to know if that is because of issues not related to Zencart, or does mySQL5 cause issues with Zencart (especially 1.27d)?

Need to know due to a possible server upgrade.

Thank You,

Betty

Vger said "she" would not touch MySQL 5, because lots of programmes are having problems with it, not just Zen Cart.

Vger

I want to host my zen cart on our own server, can anyone please suggest which versions of PHP, Apache & MySql should i use.

Can i install the latest release of PHP, Apache & MySql available with XAMPP ver 1.5.4a.

Will this one work with my zen cart 1.3.6

regards

I'd advise against using MySQL 5, not because of problems with Zen Cart but because of problems caused by MySQL 5.

When you say you want to host the site on your own server - do you mean 'online' (Internet) or 'offline' (Intranet). If you are going to host it online then I'd recommend you use something like CentOS (an open source version of RedHat Enterprise Linux). XAMPP wouldn't be up to the job of keeping an online web server secure.

Vger

Dear Vger,

Thanks for your reply, I mean online. I have developed the site using Zen 1.3.6 on my local server with uniserver3.3, This has Mysql5 & PHP5. now if I install a web server with lower variant of mySql, would'nt it give me problems? (I mean developing on Mysql5 and hosting on MySql4?)

What kind of problems does MySql5 throws up? The site which i have developed is not a shopping cart, i have tried to use Zencart as a CMS.

Also wanted to know as the development has been done on XP pro OS and hosting would be on linux OS, is their any chances of conflicts?

I have done all the local testings on uniserver 3.3 and have not faced any issues till date. The server i want to use is a company owned server which has linux (redhat) OS

I'm a total newbie to this world, but i myself am amazed that i can do all the things what i'm doing now!!! Thanks to the wonderful world of forums, and especially Zen members!!

Regarding Server, we allready have a Redhat Linux server, which currently hosts one Static HTML Site, the problem is it does not have PHP, PHP My Admin and My Sql.

So will i have to download MY Sql, PHP & PHP My Admin individually or trhere is a bundled package availabe or production use (Like XAMPP or Uniserver)

Used PHP 5.1.4 and MySQL 5.0.24 on my server without a problem for ZC. If your server has the resources, I would say you should install both mySQL4 and mySQL5 on it. That way you can switch the DB backend depending on the software requirement, which is what I'm doing on my server, MySQL5 is the default, but 4 is there as fall back if any customer have problems.