RE: 4.1.x with php-4.3.x
I recomend the PHP Home Edition Project at http://phphome.sourceforge.net/. It installs PHP, Apache and MySql, all configed to work together on a Windows machine. Version PHP Home 2.3.2 installs PHP v.4.3.3, Apache 2.0 and MySql 4.x (Note the latest version is 2.3.4 and includes PHP 5). I have been using 2.3.2 for several months on several machines and have had no problems at all. HTH, -- Will > -Original Message- > From: Daniel Kasak [mailto:[EMAIL PROTECTED] > Sent: Sunday, June 26, 2005 6:25 PM > To: mysql@lists.mysql.com > Subject: 4.1.x with php-4.3.x > > > I realise that this question may better be asked in a php list, but I > already did that and got *no* answers. > Does anyone know if there are some mysql dlls available for php-4.3.x ( > I'm running 4.3.11) that are compiled against 4.1.x so I don't have to > use the ugly hacks to get the old client to talk to the new server? > I'm not really up to compiling things on Windows. > > -- > Daniel Kasak > IT Developer > NUS Consulting Group > Level 5, 77 Pacific Highway > North Sydney, NSW, Australia 2060 > T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 > email: [EMAIL PROTECTED] > website: http://www.nusconsulting.com.au > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How to Version Control a database
I have a project that involves several developers working on their own machines. Each has a local copy of the database on their own machine. Since we have some developers who develop while not connected to the network, we cannot use a common database. How can I version control the database so that changes are not lost or stepped on. Right now, we use mysqldump to dump the database and version the dump file, but this still has problems. Is there a better way? -- Will -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Accessing last_insert_id problem.
Jeff Snoxell wrote: > At 09:46 19/12/02 -0500, you wrote: > >Jeff Snoxell wrote: > > > >>Nope. That doesn't do it either! > >> > >>I go: > >> > >>TRUNCATE TABLE my_table > > > >Are you using InnoDB tables? You'll have to do something akin to ALTER > >TABLE my_table AUTO_INCREMENT=1 ... at least according to Paul ... :) > > No, I'm using MyISAM I believe. > > Jeff If you want to set the ID back to zero, then I assume you are deleteing all of the records in the table. If so, why not simply drop the table and recreate it? Seems to work for me as the session below demonstrates. If you want to do something else, you better ask again so we can answer you real question. clip mysql> create table test ( id int auto_increment, d int, primary key (id) ); Query OK, 0 rows affected (0.00 sec) mysql> insert into test (d) values (2); Query OK, 1 row affected (0.00 sec) mysql> insert into test (d) values (2); Query OK, 1 row affected (0.00 sec) mysql> insert into test (d) values (2); Query OK, 1 row affected (0.00 sec) mysql> select * from test; ++--+ | id | d| ++--+ | 1 |2 | | 2 |2 | | 3 |2 | ++--+ 3 rows in set (0.00 sec) mysql> drop table test; Query OK, 0 rows affected (0.00 sec) mysql> create table test ( id int auto_increment, d int, primary key (id) ); Query OK, 0 rows affected (0.00 sec) mysql> insert into test (d) values (2); Query OK, 1 row affected (0.01 sec) mysql> insert into test (d) values (2); Query OK, 1 row affected (0.00 sec) mysql> insert into test (d) values (2); Query OK, 1 row affected (0.00 sec) mysql> select * from test; ++--+ | id | d| ++--+ | 1 |2 | | 2 |2 | | 3 |2 | ++--+ 3 rows in set (0.00 sec) mysql> = end clip = -- Will Will Merrell Virtual Assistant [EMAIL PROTECTED] Moreland Business Solutions - Your partner in business. http://www.morelandsolutions.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Connecting to MySQL on Linux from a Windows machine. -- Resolved !!
Well, after much fussing around with RPM's and searching this list, I have resolved my problem. The clue was the discussion on this list regarding the glibc bug. I upgraded to the 4.0.x RPM's that I got from the MySQL site and after I got all of the dependency problems fixed I was able to start up a MySQL/PHP setup that worked. Now both the website development works and I can use MyCC on the windows machine to administer the database. Thank you to all that considered my problem. --Will - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Connecting to MySQL on Linux from a Windows machine.
Thank you, but at this point I am pretty sure that my problem is not a matter of entries in the user table. When I attempt to telnet into port 3306 the connection is immediately dropped. I don't really know if any connection is actually established at all, it may be established and immediately dropped on simply refused from the start. There does not appear to be any exchange of user names or passwords. I have several variations of my username and host name in the user table. I believe that one of them should have worked if that was the problem. I believe that the problem lies in the mysql configuration. I think that it is not responding to the TCP/IP port in the way that I need it to. I have verified that the --skip-network flag is NOT set (set to OFF) so it is not that simple, but I cannot find any other flag that looks any more promising. Any other Ideas? BTW Thanks for the webmin tip, I'll give it a try. Doesn't solve all of my problem, but it may help. Thanks, --Will > -Original Message- > From: STIBS [mailto:stibs-pi@;gmx.de] > Sent: Friday, October 18, 2002 1:35 PM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: RE: Connecting to MySQL on Linux from a Windows machine. > > > Will, > > |||)So I still need some more ideas. > > I have to learn your problem each time again when I setup a new > machine every half a year. > > I try each time the following hostnames: > > localhost (didn't work 4u) > 127.0.0.1 (IP for localhost) > hostname (e.g. databaseserver.mydomain.com- what you called the machine) > 192.168.0.x (Your real network IP, can also be in 10.* or 172.25.*) > localhost.localdomain (results to same as hostname) > > one of them fit's ;o) ... if not I install webmin from > www.webmin.com and connect via Browser to the machine > (http://IP.ADD.RE.SS:1 - login as root). In Webmin's server > section you have a complete webbased MySQL administration. There > I make all settings and forget about it. It just works after this setup. > > STIBS > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: ERROR 2013: Lost connection to MySQL server during query
Hi, This is the same error that I am getting, except that in my case the server does not die, I just cant connect from another machine. All I get is this error, which seems to be because the server is not responding to the 3306 port. or something like that. I don't know if this is the same problem or if Animesh has a different problem that generates a similar response. See the "Connecting to MySQL on Linux from a Windows machine." thread for more details on my situation. Thanks, --Will > -Original Message- > From: Animesh [mailto:animesh@;deeproot.co.in] > Sent: Friday, October 18, 2002 4:53 PM > To: [EMAIL PROTECTED] > Subject: ERROR 2013: Lost connection to MySQL server during query > > > Hi All,, > > I am getting this error and mysqld is dying out while tring to access a > particular table in a particular databae while others don't fail.. > > ERROR 2013: Lost connection to MySQL server during query > > Plz Help as early as possible. > Regards, > Animesh > > [EMAIL PROTECTED] > DeepRoot Linux Pvt. Ltd. > Bangalore, India > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Connecting to MySQL on Linux from a Windows machine.
Thank you to both of you who responded to my question. I have checked both of these issues and found that neither solve my situation. 1) I have (and had) both a 'will@localhost' and a 'will@"%"' entry in the user table. Is there something else that has to be done to set up the host? 2) According to 'mysqladmin variables' the --skip-networking option is set to OFF. That should mean that Olaf's suggestion is satisfied, right? So I still need some more ideas. Why am I not able to connect to MySQL from another machine? Thanks, -- Will Randy Witt wrote: >Will, > >Do you have a user/host pair for the client in the user table within the >mysql database?? It's not good enough just to have a user, the host has >to be setup too. And Olaf van Zandwijk wrote: > Hi, > > It seems to me that you can't connect to MySQL from an other machine at > all. Did you start MySQL with the --skip-networking option? Try removing > that option from the start-up scripts. > > \Olaf > In response to my Original Post: >Will Merrell wrote: > >I cannot connect from my Windows machine to the MySQL database running on >the Linux server. > >I have tried several different programs and they all report an error that >says "Lost connection to MySQL server during connection". > >I have read all the articles I can find and searched the archives as well as >I can figure out but I am still stumped. > >Here are some pertinent details. > >1) The Server is running Redhat 7.3 and MySQL 3.23.49. It is on my local >network at 192.168.3.2 and there are no firewalls between it and the Windows >machine. (Both are behind the same firewall, and completely open to each >other.) > >2) The Windows machine is running Win98 SE at 192.168.3.x (DHCP). > >3) On the linux machine I can access MySQL just fine. The mysql command >works, and I can serve web pages with PHP/MySQL content. > >4) I can telnet, Samba, xterm, etc. to the linux machine just fine. I can >telnet to port 80 and get a connection although it doesn't do much there. > >5) I cannot telnet to port 3306. When I try, I get an immediate "Host >connection lost." error. > >Any ideas would be most appreciated. > > Thanks, > -- Will - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Connecting to MySQL on Linux from a Windows machine.
I cannot connect from my Windows machine to the MySQL database running on the Linux server. I have tried several different programs and they all report an error that says "Lost connection to MySQL server during connection". I have read all the articles I can find and searched the archives as well as I can figure out but I am still stumped. Here are some pertinent details. 1) The Server is running Redhat 7.3 and MySQL 3.23.49. It is on my local network at 192.168.3.2 and there are no firewalls between it and the Windows machine. (Both are behind the same firewall, and completely open to each other.) 2) The Windows machine is running Win98 SE at 192.168.3.x (DHCP). 3) On the linux machine I can access MySQL just fine. The mysql command works, and I can serve web pages with PHP/MySQL content. 4) I can telnet, Samba, xterm, etc. to the linux machine just fine. I can telnet to port 80 and get a connection although it doesn't do much there. 5) I cannot telnet to port 3306. When I try, I get an immediate "Host connection lost." error. Any ideas would be most appreciated. Thanks, -- Will - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php