WampServer

c2dan Wrote: ------------------------------------------------------- > David Floyd Wrote: > -------------------------------------------------- > ----- > > In reply to c2dan, I am aware of that, but I > > already have an extensive database driven > web-site > > on Linux and it would be a mammoth task to > > re-write all the queries. > > You wou
Forum: WampServer English

stevenmartin99 Wrote: ------------------------------------------------------- > add this line > > lower_case_table_names=2 > > to your my.ini file and restart wamp > > > you cannot remove this tho or it will stop working Thanks for this. That was exactly what I was looking for. Thanks for your help David
Forum: WampServer English

To Steven Martin, I've just seen your second reply which I will try, Thanks. Got to go out now, so will do it later this evening. David
Forum: WampServer English

In reply to c2dan, I am aware of that, but I already have an extensive database driven web-site on Linux and it would be a mammoth task to re-write all the queries. If you refer to may original post, there would appear to be a way to change the Server Settings, but I cannot figure out how to do this. - That was my query. David
Forum: WampServer English

Thanks for replying. I don't know what you mean by 'normally'! I created a table in phpMyAdmin. Just for example I created table 'Temp' but it appears as 'temp' The SQL is: CREATE TABLE `mydb`.`Temp` ( `Temp` INT( 11 ) NOT NULL ) ENGINE = InnoDB; The result of this is that the Table is 'temp' and the Field is 'Temp' David
Forum: WampServer English

I am installing a mysql database (which is on a Linux server at the moment) on a Windows server, and it is converting all of the case sensitive tables to all lower case. The queries are case sensitive, so I need the tables to maintain their correct case table names. Is there a way to configure the database to not alter the case sensitivity? I believe there is after reading but I am not a
Forum: WampServer English

Steven, Thanks for your advice. I discovered that my web host is using Apache 1.3, MySQL 5.0.77 and PHP 5.2.9.5 So I've loaded Apache 1.34, MySQL 5.0.37 and PHP 5.2.11 and all works fine. Thanks again for your help. David
Forum: WampServer English

Thanks for you help. I am about to find out what my Web Host Provider uses for version of php and mysql then do as you suggest. David
Forum: WampServer English

Thanks for your response and help. But I'm afraid I do not understand the reply. Are you suggesting that this is a deficiency in WAMP, as it works OK in LAMP. So how do you you change permissions in mysql? And why does the first part of the error message say "Warning: mysql_connect() : OK packet 6 bytes shorter than expected in G:\wamp\www\mytest\index.php on line 4 " and h
Forum: WampServer English

I don't think so. I am trying to contact and read the database at my web host, not on my local machine, which I can do on a Linux machine with LAMP installed but not on a Windows machine with WAMP installed. I can read databases on localhost without problem. David
Forum: WampServer English

I have used LAMP on my Linux machine for a couple of years and use it to maintain a website. For various reasons I now also need to maintain this website on a Windows machine and I have just recently installed the latest WAMP. Just to test things I have set up a temporary database (df6net1) at my host with one table (temp) with one field (temp) containing 'Hello World!' My test script
Forum: WampServer English