Copy Struct and Data
Hi people, What I need make to copy Struct and Data from Database in my machine to another machine (export) in the web ? The my host in the web work with phpMySQL. tks, Celso -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
OK... stuck on can't connect from client
It´s happen exactly the same with me. Do you have some suggestion to solve this? I'm on Linux Redhat 7.2 and MySQL v. 3.23.41 I can make connections from the server... including the use of other hostnames for test purposes. All my PHP/MySQL sites are up and running. I can access the database through phpMyAdmin. I cannot connect from a client app such as Mascon. I notice that each time I try I get the following added to my logfile. Number of processes running now: 1 mysqld process hanging, pid 8617 - killed 021013 20:08:43 mysqld restarted /usr/libexec/mysqld: ready for connections Number of processes running now: 1 mysqld process hanging, pid 9796 - killed 021013 20:10:02 mysqld restarted /usr/libexec/mysqld: ready for connections Number of processes running now: 1 mysqld process hanging, pid 9858 - killed 021013 20:25:23 mysqld restarted /usr/libexec/mysqld: ready for connections I've included the last three instances. I've been fighting with this now for the last three days!!! Please help. All 'was' working fine for a year or more, up until the point of a machine reboot. -- John Hinton - Goshen, VA. http://www.ew3d.com Those who dance are considered insane by those who can't hear the music - 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: Upgrading MySQL causes Error - ASP
Gerald, I've written to them asking your question. I'd like to point out that I just got an empty record set when it is running under ASP. The query runs successfully through phpMyAdmin 2.0.5. I realized that the query (select count(*) as quantity from person;) works well in ASP so that I think it should be something related to GROUP BY clause. Celso. - Original Message - From: Gerald L. Clark [EMAIL PROTECTED] To: Celso Pires [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, March 01, 2001 11:11 Subject: Re: Upgrading MySQL causes Error - ASP They replaced your MySQL with a new version. Did they re-compile Apache and PHP to use the new MySQL libraries, or is it trying to use the now missing ones? Celso Pires wrote: Hi there, I've got a site hosted at an ISP and everything was going well when they decided to upgrade the software. Now my site is running under Win2K, IIS5, MySQL 3.23.33 and MyODBC 2.50.36. In order to get easier to explain what is going wrong, I've built the following test: CREATE TABLE person ( person_ID INTEGER NULL, name CHAR(50) NULL, gender CHAR(1) NULL ); INSERT INTO person (person_id, name, gender) values (1,'Bob','m'),(2,'Mary','f'),(3,'Antony','m'),(4,'Rose','f'),(5,'Kuerten','m '); mysql select count(*) as quantity, gender - from person - group by gender; +--++ | quantity | gender | +--++ |2 | f | |3 | m | +--++ 2 rows in set (0.01 sec) *** As you can realize, so far so good. Now things get worse *** html head titleGROUP BY TEST/title /head body bgcolor="#FF" % Response.Write "Beginbr" strConn = "DRIVER=MySQL;SERVER=myserver;DATABASE=mydatabase;UID=myuser;PWD=mypass;" Set conn = Server.Createobject("ADODB.Connection") conn.Open(strConn) strSQL = "select count(*) as quantity, gender " strSQL = strSQL "from person " strSQL = strSQL "group by gender;" Response.Write strSQL "BR" Set Rs = conn.Execute(strSQL) While Not Rs.EOF Response.Write "Quantity: " RS("quantity") " - Gender: " RS("gender") "BR" Rs.MoveNext Wend Rs.Close conn.close response.write "The Endbr" % /body /html *** The page above should print: Begin select count(*) as quantity, gender from person group by gender; Quantity: 2 - Gender: f Quantity: 3 - Gender: m The End *** Instead, I'm getting this: Begin select count(*) as quantity, gender from person group by gender; The End *** It means that the record set is empty. Thank you very much for any help. Regards, Celso. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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 - 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
Upgrading MySQL causes Error - ASP
Hi there, I've got a site hosted at an ISP and everything was going well when they decided to upgrade the software. Now my site is running under Win2K, IIS5, MySQL 3.23.33 and MyODBC 2.50.36. In order to get easier to explain what is going wrong, I've built the following test: CREATE TABLE person ( person_ID INTEGER NULL, name CHAR(50) NULL, gender CHAR(1) NULL ); INSERT INTO person (person_id, name, gender) values (1,'Bob','m'),(2,'Mary','f'),(3,'Antony','m'),(4,'Rose','f'),(5,'Kuerten','m'); mysql select count(*) as quantity, gender - from person - group by gender; +--++ | quantity | gender | +--++ |2 | f | |3 | m | +--++ 2 rows in set (0.01 sec) *** As you can realize, so far so good. Now things get worse *** html head titleGROUP BY TEST/title /head body bgcolor="#FF" % Response.Write "Beginbr" strConn = "DRIVER=MySQL;SERVER=myserver;DATABASE=mydatabase;UID=myuser;PWD=mypass;" Set conn = Server.Createobject("ADODB.Connection") conn.Open(strConn) strSQL = "select count(*) as quantity, gender " strSQL = strSQL "from person " strSQL = strSQL "group by gender;" Response.Write strSQL "BR" Set Rs = conn.Execute(strSQL) While Not Rs.EOF Response.Write "Quantity: " RS("quantity") " - Gender: " RS("gender") "BR" Rs.MoveNext Wend Rs.Close conn.close response.write "The Endbr" % /body /html *** The page above should print: Begin select count(*) as quantity, gender from person group by gender; Quantity: 2 - Gender: f Quantity: 3 - Gender: m The End *** Instead, I'm getting this: Begin select count(*) as quantity, gender from person group by gender; The End *** It means that the record set is empty. Thank you very much for any help. Regards, Celso. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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