FRIHOST FORUMS SEARCH FAQ TOS BLOGS COMPETITIONS
You are invited to Log in or Register a free Frihost Account!


Why do I see Server version: 4.0.23-standard-log in MySQL





iyepes
Hi,

It's supposed that server is running MySQL 5.0, however phpmyadmin show me this:
Server version: 4.0.23-standard-log
MySQL client version: 4.0.23

I'm trying to create a view, and the server reject my sintax, being MySQL 4.0 it could be a reason, but, why am I obtaining that version? how can I work with MySQL 5.0 here?

Thanks for your answers.
rvec
server 2 has mysql 4.0.23
http://www.frih.net/phpinfo.php

server 1 has mysql 5.0.22
http://www.frihost.com/phpinfo.php

you are on server 2 so ...

If you somehow send me the sql files I could try to make them mysql4 compatible.
iyepes
Thanks for your help, however I found out that MySQL views are an snapshot, if something change in my tables, the views won't reflect it. Because of that, I've desisted on using views for my app.

Thanks again.

By the way, why do you have different versions of mysql in each server?
Related topics
mysql's
PHP, MySQL...
info
Version info?
PHP and SEO
MySQL and PHP problem in the future
What versions of php mysql do we have
need help restoring phpbb database from old webhost.
Starting with PHP and going to place with no internet.
sql
database backup
JynxAnims Version 4.0 Refreshed
Which version of php and MySQL does frihost run?
Rvec's PHP shop
Reply to topic    Frihost Forum Index -> Support and Web Hosting -> Web Hosting Support

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.