Re: Urgent please..
Thank you very much..excellent support - Original Message - From: "Logan, David (SST - Adelaide)" <[EMAIL PROTECTED]> To: "Renish" <[EMAIL PROTECTED]> Cc: ; "Joshua J. Kugler" <[EMAIL PROTECTED]> Sent: Thursday, November 16, 2006 12:16 PM Subject: RE: Urgent please.. Hi Renish, Perhaps these might be a more appropriate forum and also get you the result you need. This being a database list (I'm sure there are php experts on here) is probably not quite the right place to be asking. One of the php lists may produce a more relevant response. http://www.php.net/mailing-lists.php Regards --- ** _/ ** David Logan *** _/ *** ITO Delivery Specialist - Database *_/* Hewlett-Packard Australia Ltd _/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED] _/ _/ _/ _/ Desk: +61 8 8408 4273 _/ _/ _/_/_/ Mobile: +61 417 268 665 *_/ ** ** _/ Postal: 148 Frome Street, _/ ** Adelaide SA 5001 Australia invent --- -Original Message- From: Renish [mailto:[EMAIL PROTECTED] Sent: Thursday, 16 November 2006 2:38 PM To: Joshua J. Kugler Cc: mysql@lists.mysql.com Subject: Re: Urgent please.. Ocourse i read the manual . I was unable to do so..ie the reason I asked...I also knew this location mysql@lists.mysql.com - Original Message - From: "Joshua J. Kugler" <[EMAIL PROTECTED]> To: Cc: "Renish" <[EMAIL PROTECTED]> Sent: Thursday, November 16, 2006 11:20 AM Subject: Re: Urgent please.. On Wednesday 15 November 2006 18:14, Renish wrote: Can anyone tell me..how to install PHP php-5.2.0-Win32 . i click on php.exe and nothing seems to happen. I have intalled 1) webserver-Apache2 2) MySql-41.1 Please read the documentation before asking questions such as these. Thanks. http://www.php.net/manual/en/install.windows.php j -- Joshua Kugler Lead System Admin -- Senior Programmer http://www.eeinternet.com PGP Key: http://pgp.mit.edu/ ID 0xDB26D7CE PO Box 80086 -- Fairbanks, AK 99708 -- Ph: 907-456-5581 Fax: 907-456-3111 -- 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]
RE: Urgent please..
Hi Renish, Perhaps these might be a more appropriate forum and also get you the result you need. This being a database list (I'm sure there are php experts on here) is probably not quite the right place to be asking. One of the php lists may produce a more relevant response. http://www.php.net/mailing-lists.php Regards --- ** _/ ** David Logan *** _/ *** ITO Delivery Specialist - Database *_/* Hewlett-Packard Australia Ltd _/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED] _/ _/ _/ _/ Desk: +61 8 8408 4273 _/ _/ _/_/_/ Mobile: +61 417 268 665 *_/ ** ** _/ Postal: 148 Frome Street, _/ ** Adelaide SA 5001 Australia invent --- -Original Message- From: Renish [mailto:[EMAIL PROTECTED] Sent: Thursday, 16 November 2006 2:38 PM To: Joshua J. Kugler Cc: mysql@lists.mysql.com Subject: Re: Urgent please.. Ocourse i read the manual . I was unable to do so..ie the reason I asked...I also knew this location mysql@lists.mysql.com - Original Message - From: "Joshua J. Kugler" <[EMAIL PROTECTED]> To: Cc: "Renish" <[EMAIL PROTECTED]> Sent: Thursday, November 16, 2006 11:20 AM Subject: Re: Urgent please.. > On Wednesday 15 November 2006 18:14, Renish wrote: >> Can anyone tell me..how to install PHP php-5.2.0-Win32 . i click on >> php.exe and nothing seems to happen. >> I have intalled >> 1) webserver-Apache2 >> 2) MySql-41.1 > > Please read the documentation before asking questions such as these. > Thanks. > > http://www.php.net/manual/en/install.windows.php > > j > > -- > Joshua Kugler > Lead System Admin -- Senior Programmer > http://www.eeinternet.com > PGP Key: http://pgp.mit.edu/ ID 0xDB26D7CE > PO Box 80086 -- Fairbanks, AK 99708 -- Ph: 907-456-5581 Fax: 907-456-3111 -- 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]
Re: Urgent please..
Ocourse i read the manual . I was unable to do so..ie the reason I asked...I also knew this location mysql@lists.mysql.com - Original Message - From: "Joshua J. Kugler" <[EMAIL PROTECTED]> To: Cc: "Renish" <[EMAIL PROTECTED]> Sent: Thursday, November 16, 2006 11:20 AM Subject: Re: Urgent please.. On Wednesday 15 November 2006 18:14, Renish wrote: Can anyone tell me..how to install PHP php-5.2.0-Win32 . i click on php.exe and nothing seems to happen. I have intalled 1) webserver-Apache2 2) MySql-41.1 Please read the documentation before asking questions such as these. Thanks. http://www.php.net/manual/en/install.windows.php j -- Joshua Kugler Lead System Admin -- Senior Programmer http://www.eeinternet.com PGP Key: http://pgp.mit.edu/ ID 0xDB26D7CE PO Box 80086 -- Fairbanks, AK 99708 -- Ph: 907-456-5581 Fax: 907-456-3111 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Urgent please..
Try http://www.php.net/manual/en/install.windows.php --- ** _/ ** David Logan *** _/ *** ITO Delivery Specialist - Database *_/* Hewlett-Packard Australia Ltd _/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED] _/ _/ _/ _/ Desk: +61 8 8408 4273 _/ _/ _/_/_/ Mobile: +61 417 268 665 *_/ ** ** _/ Postal: 148 Frome Street, _/ ** Adelaide SA 5001 Australia invent --- -Original Message- From: Renish [mailto:[EMAIL PROTECTED] Sent: Thursday, 16 November 2006 1:44 PM To: mysql@lists.mysql.com Subject: Urgent please.. All, Can anyone tell me..how to install PHP php-5.2.0-Win32 . i click on php.exe and nothing seems to happen. I have intalled 1) webserver-Apache2 2) MySql-41.1 I want to use PHP as sever side scripting. Cheers, Renish. -- 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]
Re: Urgent please..
On Wednesday 15 November 2006 18:14, Renish wrote: > Can anyone tell me..how to install PHP php-5.2.0-Win32 . i click on > php.exe and nothing seems to happen. > I have intalled > 1) webserver-Apache2 > 2) MySql-41.1 Please read the documentation before asking questions such as these. Thanks. http://www.php.net/manual/en/install.windows.php j -- Joshua Kugler Lead System Admin -- Senior Programmer http://www.eeinternet.com PGP Key: http://pgp.mit.edu/ ID 0xDB26D7CE PO Box 80086 -- Fairbanks, AK 99708 -- Ph: 907-456-5581 Fax: 907-456-3111 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Urgent please..
All, Can anyone tell me..how to install PHP php-5.2.0-Win32 . i click on php.exe and nothing seems to happen. I have intalled 1) webserver-Apache2 2) MySql-41.1 I want to use PHP as sever side scripting. Cheers, Renish. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Urgent: Please Confirm Interest in China Business Opportunity
This is a text part of the message. It is shown for the users of old-style e-mail clients
RE: urgent : PLEASE HELP - problems with back up and restore
Hi, Thanks Again. You are really helping me Well it get a lot of "query ok, 0 rows affected <0.00 sec>" And one like this : query ok, 2 rows affected <0.01 sec> Records: 2 Duplicates: 0 Warnings: 0 But it look like everything is in the Database now ? What is this "Source" Command ? Another thing I noticed is that My Original databes my Sp's Got "Delimiter $$" But on the backup file it replaced with ;; Barak _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, November 24, 2005 7:21 AM To: Barak Mery Cc: mysql@lists.mysql.com Subject: RE: urgent : PLEASE HELP - problems with back up and restore I saw both views and stored procedures in the dump file. What error do you get if you process the script with the "source" command within the MySQL CLI? mysql -uroot -pmypass (login welcome) mysql> CREATE DATABASE IF NOT EXISTS bcm; mysql> USE bcm; mysql> source myback1.sql There is another option to drop/create the database. Your dump didn't have that so you need to do it manually in order to restore it. Shawn Green Database Administrator Unimin Corporation - Spruce Pine "Barak Mery" <[EMAIL PROTECTED]> wrote on 11/23/2005 07:18:02 PM: > Wel I read the manual but didn't find something that I really need to add > I suspect it is something with the script itself. > > Now I'm using > mysqldump -uroot -pmypass --routines -q -x bcm>myback1.sql > > but after i run > mysqldump -uroot -pmypass --routines bcm>myback1.sql > > it now restore the tables but not the views or sp's > > here is the backup file > > thanks > Barak > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Wednesday, November 23, 2005 9:30 PM > To: Barak Mery > Cc: mysql@lists.mysql.com > Subject: RE: urgent : PLEASE HELP - problems with back up and restore > > > There's a new option added in 5.0.13: > > -R (--routines) > > It's designed designed specifically to dump SPROCs and FUNCTIONs. I > thought it would have been turned on by default but I guess it > wasn't. Add that to the list of options and check your dump results > again. I refer you again to the manual for additional warnings and cautions. > > http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html > > Shawn Green > Database Administrator > Unimin Corporation - Spruce Pine > > > > "Barak Mery" <[EMAIL PROTECTED]> wrote on 11/23/2005 02:23:42 PM: > > > Well Shawn, > > > > First of thanks for the quick result. > > > > I tried your suggestion but it didn't help no sp and no restore. > > > > It only shrinked the backup file (by deleting the cr). > > > > Is there any log file where I can trace that kind of erros ? > > > > Barak > > > > > > > > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, November 23, 2005 9:07 PM > > To: Barak Mery > > Cc: mysql@lists.mysql.com > > Subject: Re: urgent : PLEASE HELP - problems with back up and restore > > > > > > > > "Barak Mery" <[EMAIL PROTECTED]> wrote on 11/23/2005 01:51:37 PM: > > > > > Hi, > > > > > > > > > > > > I'm really desperate on this on. > > > > > > After struggling with some really weird bugs I finally finished > my project. > > > > > > > > > > > > Buut I can't perform a good backup and restore. > > > > > > > > > > > > I'm using : > > > > > > MySql 5.0.16-nt (essentials version) > > > > > > Windows xp > > > > > > The DB contains tables, vw's and sp's. > > > > > > It is a very small one and at the moment I don't have any data inside. > > > > > > The whole backup file size is 100Kb. > > > > > > > > > > > > 1. I backed up my db using mysql administrator. > > > It created a back up file with all tables, views and sp's, but > when I tried > > > a restore it got errors like. > > > "Could not handle this statement etc. > > > > > > > > > 2. I tried : mysqldump -uroot -pmypassword dbname > backup.sql > > > And then mysqldump -uroot -pmypassword newDbName < backup.sql > > > I didn't get any error. > > > The shell printed to the screen the backup file completely only > without the > >
RE: urgent : PLEASE HELP - problems with back up and restore
I saw both views and stored procedures in the dump file. What error do you get if you process the script with the "source" command within the MySQL CLI? mysql -uroot -pmypass (login welcome) mysql> CREATE DATABASE IF NOT EXISTS bcm; mysql> USE bcm; mysql> source myback1.sql There is another option to drop/create the database. Your dump didn't have that so you need to do it manually in order to restore it. Shawn Green Database Administrator Unimin Corporation - Spruce Pine "Barak Mery" <[EMAIL PROTECTED]> wrote on 11/23/2005 07:18:02 PM: > Wel I read the manual but didn’t find something that I really need to add > I suspect it is something with the script itself. > > Now I’m using > mysqldump -uroot -pmypass --routines -q -x bcm>myback1.sql > > but after i run > mysqldump -uroot -pmypass --routines bcm>myback1.sql > > it now restore the tables but not the views or sp’s > > here is the backup file > > thanks > Barak > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Wednesday, November 23, 2005 9:30 PM > To: Barak Mery > Cc: mysql@lists.mysql.com > Subject: RE: urgent : PLEASE HELP - problems with back up and restore > > > There's a new option added in 5.0.13: > > -R (--routines) > > It's designed designed specifically to dump SPROCs and FUNCTIONs. I > thought it would have been turned on by default but I guess it > wasn't. Add that to the list of options and check your dump results > again. I refer you again to the manual for additional warnings and cautions. > > http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html > > Shawn Green > Database Administrator > Unimin Corporation - Spruce Pine > > > > "Barak Mery" <[EMAIL PROTECTED]> wrote on 11/23/2005 02:23:42 PM: > > > Well Shawn, > > > > First of thanks for the quick result. > > > > I tried your suggestion but it didn’t help no sp and no restore. > > > > It only shrinked the backup file (by deleting the cr). > > > > Is there any log file where I can trace that kind of erros ? > > > > Barak > > > > > > > > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, November 23, 2005 9:07 PM > > To: Barak Mery > > Cc: mysql@lists.mysql.com > > Subject: Re: urgent : PLEASE HELP - problems with back up and restore > > > > > > > > "Barak Mery" <[EMAIL PROTECTED]> wrote on 11/23/2005 01:51:37 PM: > > > > > Hi, > > > > > > > > > > > > I'm really desperate on this on. > > > > > > After struggling with some really weird bugs I finally finished > my project. > > > > > > > > > > > > Buut I can't perform a good backup and restore. > > > > > > > > > > > > I'm using : > > > > > > MySql 5.0.16-nt (essentials version) > > > > > > Windows xp > > > > > > The DB contains tables, vw's and sp's. > > > > > > It is a very small one and at the moment I don't have any data inside. > > > > > > The whole backup file size is 100Kb. > > > > > > > > > > > > 1. I backed up my db using mysql administrator. > > > It created a back up file with all tables, views and sp's, but > when I tried > > > a restore it got errors like. > > > "Could not handle this statement etc. > > > > > > > > > 2. I tried : mysqldump -uroot -pmypassword dbname > backup.sql > > > And then mysqldump -uroot -pmypassword newDbName < backup.sql > > > I didn't get any error. > > > The shell printed to the screen the backup file completely only > without the > > > table script part. > > > > > > It Created a backup file only for the tables (why ? a minute agoI did the > > > backup with the same tool). > > > But after restoring, the new db was still empty. > > > > > > > > > 3. I tried to restore with mysql > -uroot -pmypassword newDbName < > > > backup.sql > > > But I got the same results. > > > > > > > > > > > > > > > > > > It should be a very simple and basic issue. > > > Why everything is so hard with mysql ? > > > > > > > > > > > > Is there any really good and quick forum for mySql ? I posted some new > > > thread i
RE: urgent : PLEASE HELP - problems with back up and restore
Thanks Marko :) -Original Message- From: Marko Knezevic [mailto:[EMAIL PROTECTED] Sent: Thursday, November 24, 2005 12:29 AM To: MySQL list Subject: Re: urgent : PLEASE HELP - problems with back up and restore Dear Barak, Save yourself year or two of your life and try using MySQL Front not that command line tools. Its really nice tool for handling MySQL databases Regards Marko -- 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]
RE: urgent : PLEASE HELP - problems with back up and restore
Thanks again, I will try this and read the manual again. _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 23, 2005 9:30 PM To: Barak Mery Cc: mysql@lists.mysql.com Subject: RE: urgent : PLEASE HELP - problems with back up and restore There's a new option added in 5.0.13: -R (--routines) It's designed designed specifically to dump SPROCs and FUNCTIONs. I thought it would have been turned on by default but I guess it wasn't. Add that to the list of options and check your dump results again. I refer you again to the manual for additional warnings and cautions. http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html Shawn Green Database Administrator Unimin Corporation - Spruce Pine "Barak Mery" <[EMAIL PROTECTED]> wrote on 11/23/2005 02:23:42 PM: > Well Shawn, > > First of thanks for the quick result. > > I tried your suggestion but it didn't help no sp and no restore. > > It only shrinked the backup file (by deleting the cr). > > Is there any log file where I can trace that kind of erros ? > > Barak > > > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Wednesday, November 23, 2005 9:07 PM > To: Barak Mery > Cc: mysql@lists.mysql.com > Subject: Re: urgent : PLEASE HELP - problems with back up and restore > > > > "Barak Mery" <[EMAIL PROTECTED]> wrote on 11/23/2005 01:51:37 PM: > > > Hi, > > > > > > > > I'm really desperate on this on. > > > > After struggling with some really weird bugs I finally finished my project. > > > > > > > > Buut I can't perform a good backup and restore. > > > > > > > > I'm using : > > > > MySql 5.0.16-nt (essentials version) > > > > Windows xp > > > > The DB contains tables, vw's and sp's. > > > > It is a very small one and at the moment I don't have any data inside. > > > > The whole backup file size is 100Kb. > > > > > > > > 1. I backed up my db using mysql administrator. > > It created a back up file with all tables, views and sp's, but when I tried > > a restore it got errors like. > > "Could not handle this statement etc. > > > > > > 2. I tried : mysqldump -uroot -pmypassword dbname > backup.sql > > And then mysqldump -uroot -pmypassword newDbName < backup.sql > > I didn't get any error. > > The shell printed to the screen the backup file completely only without the > > table script part. > > > > It Created a backup file only for the tables (why ? a minute ago I did the > > backup with the same tool). > > But after restoring, the new db was still empty. > > > > > > 3. I tried to restore with mysql > -uroot -pmypassword newDbName < > > backup.sql > > But I got the same results. > > > > > > > > > > > > It should be a very simple and basic issue. > > Why everything is so hard with mysql ? > > > > > > > > Is there any really good and quick forum for mySql ? I posted some new > > thread in mysql.com at the past few days but never got answered. > > > > > > > > Is it just me or that's the life on the mysql planet ? > > > > > > > > I now try this mailing-list. I hope you can help me. > > > > > > > > Thanks in advance > > > > Barak > > You are in luck as the mailing list is quite active. > > Look at your actual dump file. It is simply a SQL script that will > create all of the "elements" of the database and populate them with > data (if you had any). My suspicion is that you have something that > isn't quoted that needed to be. > > mysqldump has several options. You can see them with the command: > > mysqldump --help > > -or- refer to the manual > > http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html > > try dumping your database again, this time use the -r= and -Q > options. That does two things: > > a) it avoids adding CR characters at the end of every line > b) it puts backticks around EVERYTHING that needs them (table names, > column names, etc) > > > mysqldump -uroot -pmypassword -r backup.sql -Q dbname > > Shawn Green > Database Administrator > Unimin Corporation - Spruce Pine
RE: urgent : PLEASE HELP - problems with back up and restore
There's a new option added in 5.0.13: -R (--routines) It's designed designed specifically to dump SPROCs and FUNCTIONs. I thought it would have been turned on by default but I guess it wasn't. Add that to the list of options and check your dump results again. I refer you again to the manual for additional warnings and cautions. http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html Shawn Green Database Administrator Unimin Corporation - Spruce Pine "Barak Mery" <[EMAIL PROTECTED]> wrote on 11/23/2005 02:23:42 PM: > Well Shawn, > > First of thanks for the quick result. > > I tried your suggestion but it didn’t help no sp and no restore. > > It only shrinked the backup file (by deleting the cr). > > Is there any log file where I can trace that kind of erros ? > > Barak > > > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Wednesday, November 23, 2005 9:07 PM > To: Barak Mery > Cc: mysql@lists.mysql.com > Subject: Re: urgent : PLEASE HELP - problems with back up and restore > > > > "Barak Mery" <[EMAIL PROTECTED]> wrote on 11/23/2005 01:51:37 PM: > > > Hi, > > > > > > > > I'm really desperate on this on. > > > > After struggling with some really weird bugs I finally finished my project. > > > > > > > > Buut I can't perform a good backup and restore. > > > > > > > > I'm using : > > > > MySql 5.0.16-nt (essentials version) > > > > Windows xp > > > > The DB contains tables, vw's and sp's. > > > > It is a very small one and at the moment I don't have any data inside. > > > > The whole backup file size is 100Kb. > > > > > > > > 1. I backed up my db using mysql administrator. > > It created a back up file with all tables, views and sp's, but when I tried > > a restore it got errors like. > > "Could not handle this statement etc. > > > > > > 2. I tried : mysqldump -uroot -pmypassword dbname > backup.sql > > And then mysqldump -uroot -pmypassword newDbName < backup.sql > > I didn't get any error. > > The shell printed to the screen the backup file completely only without the > > table script part. > > > > It Created a backup file only for the tables (why ? a minute ago I did the > > backup with the same tool). > > But after restoring, the new db was still empty. > > > > > > 3. I tried to restore with mysql > -uroot -pmypassword newDbName < > > backup.sql > > But I got the same results. > > > > > > > > > > > > It should be a very simple and basic issue. > > Why everything is so hard with mysql ? > > > > > > > > Is there any really good and quick forum for mySql ? I posted some new > > thread in mysql.com at the past few days but never got answered. > > > > > > > > Is it just me or that's the life on the mysql planet ? > > > > > > > > I now try this mailing-list. I hope you can help me. > > > > > > > > Thanks in advance > > > > Barak > > You are in luck as the mailing list is quite active. > > Look at your actual dump file. It is simply a SQL script that will > create all of the "elements" of the database and populate them with > data (if you had any). My suspicion is that you have something that > isn't quoted that needed to be. > > mysqldump has several options. You can see them with the command: > > mysqldump --help > > -or- refer to the manual > > http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html > > try dumping your database again, this time use the -r= and -Q > options. That does two things: > > a) it avoids adding CR characters at the end of every line > b) it puts backticks around EVERYTHING that needs them (table names, > column names, etc) > > > mysqldump -uroot -pmypassword -r backup.sql -Q dbname > > Shawn Green > Database Administrator > Unimin Corporation - Spruce Pine
RE: urgent : PLEASE HELP - problems with back up and restore
Well Shawn, First of thanks for the quick result. I tried your suggestion but it didn't help no sp and no restore. It only shrinked the backup file (by deleting the cr). Is there any log file where I can trace that kind of erros ? Barak _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 23, 2005 9:07 PM To: Barak Mery Cc: mysql@lists.mysql.com Subject: Re: urgent : PLEASE HELP - problems with back up and restore "Barak Mery" <[EMAIL PROTECTED]> wrote on 11/23/2005 01:51:37 PM: > Hi, > > > > I'm really desperate on this on. > > After struggling with some really weird bugs I finally finished my project. > > > > Buut I can't perform a good backup and restore. > > > > I'm using : > > MySql 5.0.16-nt (essentials version) > > Windows xp > > The DB contains tables, vw's and sp's. > > It is a very small one and at the moment I don't have any data inside. > > The whole backup file size is 100Kb. > > > > 1. I backed up my db using mysql administrator. > It created a back up file with all tables, views and sp's, but when I tried > a restore it got errors like. > "Could not handle this statement etc. > > > 2. I tried : mysqldump -uroot -pmypassword dbname > backup.sql > And then mysqldump -uroot -pmypassword newDbName < backup.sql > I didn't get any error. > The shell printed to the screen the backup file completely only without the > table script part. > > It Created a backup file only for the tables (why ? a minute ago I did the > backup with the same tool). > But after restoring, the new db was still empty. > > > 3. I tried to restore with mysql > -uroot -pmypassword newDbName < > backup.sql > But I got the same results. > > > > > > It should be a very simple and basic issue. > Why everything is so hard with mysql ? > > > > Is there any really good and quick forum for mySql ? I posted some new > thread in mysql.com at the past few days but never got answered. > > > > Is it just me or that's the life on the mysql planet ? > > > > I now try this mailing-list. I hope you can help me. > > > > Thanks in advance > > Barak You are in luck as the mailing list is quite active. Look at your actual dump file. It is simply a SQL script that will create all of the "elements" of the database and populate them with data (if you had any). My suspicion is that you have something that isn't quoted that needed to be. mysqldump has several options. You can see them with the command: mysqldump --help -or- refer to the manual http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html try dumping your database again, this time use the -r= and -Q options. That does two things: a) it avoids adding CR characters at the end of every line b) it puts backticks around EVERYTHING that needs them (table names, column names, etc) mysqldump -uroot -pmypassword -r backup.sql -Q dbname Shawn Green Database Administrator Unimin Corporation - Spruce Pine
Re: urgent : PLEASE HELP - problems with back up and restore
"Barak Mery" <[EMAIL PROTECTED]> wrote on 11/23/2005 01:51:37 PM: > Hi, > > > > I'm really desperate on this on. > > After struggling with some really weird bugs I finally finished my project. > > > > Buut I can't perform a good backup and restore. > > > > I'm using : > > MySql 5.0.16-nt (essentials version) > > Windows xp > > The DB contains tables, vw's and sp's. > > It is a very small one and at the moment I don't have any data inside. > > The whole backup file size is 100Kb. > > > > 1. I backed up my db using mysql administrator. > It created a back up file with all tables, views and sp's, but when I tried > a restore it got errors like. > "Could not handle this statement etc. > > > 2. I tried : mysqldump -uroot -pmypassword dbname > backup.sql > And then mysqldump -uroot -pmypassword newDbName < backup.sql > I didn't get any error. > The shell printed to the screen the backup file completely only without the > table script part. > > It Created a backup file only for the tables (why ? a minute ago I did the > backup with the same tool). > But after restoring, the new db was still empty. > > > 3. I tried to restore with mysql > -uroot -pmypassword newDbName < > backup.sql > But I got the same results. > > > > > > It should be a very simple and basic issue. > Why everything is so hard with mysql ? > > > > Is there any really good and quick forum for mySql ? I posted some new > thread in mysql.com at the past few days but never got answered. > > > > Is it just me or that's the life on the mysql planet ? > > > > I now try this mailing-list. I hope you can help me. > > > > Thanks in advance > > Barak You are in luck as the mailing list is quite active. Look at your actual dump file. It is simply a SQL script that will create all of the "elements" of the database and populate them with data (if you had any). My suspicion is that you have something that isn't quoted that needed to be. mysqldump has several options. You can see them with the command: mysqldump --help -or- refer to the manual http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html try dumping your database again, this time use the -r= and -Q options. That does two things: a) it avoids adding CR characters at the end of every line b) it puts backticks around EVERYTHING that needs them (table names, column names, etc) mysqldump -uroot -pmypassword -r backup.sql -Q dbname Shawn Green Database Administrator Unimin Corporation - Spruce Pine
urgent : PLEASE HELP - problems with back up and restore
Hi, I'm really desperate on this on. After struggling with some really weird bugs I finally finished my project. Buut I can't perform a good backup and restore. I'm using : MySql 5.0.16-nt (essentials version) Windows xp The DB contains tables, vw's and sp's. It is a very small one and at the moment I don't have any data inside. The whole backup file size is 100Kb. 1. I backed up my db using mysql administrator. It created a back up file with all tables, views and sp's, but when I tried a restore it got errors like. "Could not handle this statement etc. 2. I tried : mysqldump -uroot -pmypassword dbname > backup.sql And then mysqldump -uroot -pmypassword newDbName < backup.sql I didn't get any error. The shell printed to the screen the backup file completely only without the table script part. It Created a backup file only for the tables (why ? a minute ago I did the backup with the same tool). But after restoring, the new db was still empty. 3. I tried to restore with mysql > -uroot -pmypassword newDbName < backup.sql But I got the same results. It should be a very simple and basic issue. Why everything is so hard with mysql ? Is there any really good and quick forum for mySql ? I posted some new thread in mysql.com at the past few days but never got answered. Is it just me or that's the life on the mysql planet ? I now try this mailing-list. I hope you can help me. Thanks in advance Barak
Possible? Urgent please.
Using OpenRowSet Transact SQL, I want to view/obtain data from MySql
using this function in "MS SQL Query Analyzer". Can I do this at all?
I have MyODBC driver and the relevant OLE DB provider to connect to
MySQL db, I can connect to MySQL db, but having problem with the last
parameter (table name) in the function. Query Analyzer reports the
following:
"A four-part name was supplied, but the provider does not expose the
necessary interfaces to use a catalog and/or schema."
SELECT a.*
FROM OPENROWSET('MSDASQL',
'DRIVER={MySQL ODBC 3.51 Driver};SERVER=LocalHhost;UID=root;PWD=test',
testdb.table1) AS a
regards
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: help urgent please
One thing Jim didn't mention is that mysqldump is not a mysql client command but a standalone executable. Run it from a shell prompt (DOS prompt if you are using windows) Shawn Green Database Administrator Unimin Corporation - Spruce Pine "Jim Grill" <[EMAIL PROTECTED]> wrote on 09/09/2004 11:47:55 AM: > > > > -- > > help please > > > > please tell me how to extract a script file of a database from mysql > commandprompt. > > > > s.deepak > > > > > > This life is a hard fact; work your way through it boldly, though it may > be adamantine; no matter, the soul is stronger > > > > Swami Vivekananda > > > > Are you looking for mysqldump?? If you want to produce a dump file of a > table: > > mysqldump -u yourusername -p --add-drop-table dbname tablename > > tablename.sql > > to do the whole database: > > mysqldump -u yourusername -p --add-drop-table dbname > dbname.sql > > also do "man mysqldump" or see > http://dev.mysql.com/doc/mysql/en/mysqldump.html > > The "--add-drop-table" will add a "DROP TABLE IF EXISTS tablename" to your > script before creating and populating the tables. This is useful when > restoring a possibly corrupt table. > > Jim Grill > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] >
Re: help urgent please
> > -- > help please > > please tell me how to extract a script file of a database from mysql commandprompt. > > s.deepak > > > This life is a hard fact; work your way through it boldly, though it may be adamantine; no matter, the soul is stronger > > Swami Vivekananda > Are you looking for mysqldump?? If you want to produce a dump file of a table: mysqldump -u yourusername -p --add-drop-table dbname tablename > tablename.sql to do the whole database: mysqldump -u yourusername -p --add-drop-table dbname > dbname.sql also do "man mysqldump" or see http://dev.mysql.com/doc/mysql/en/mysqldump.html The "--add-drop-table" will add a "DROP TABLE IF EXISTS tablename" to your script before creating and populating the tables. This is useful when restoring a possibly corrupt table. Jim Grill -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
help urgent please
-- help please please tell me how to extract a script file of a database from mysql commandprompt. s.deepak This life is a hard fact; work your way through it boldly, though it may be adamantine; no matter, the soul is stronger Swami Vivekananda -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Innodb querry optimizer suddenly making TERRIBLE choices? Urgent, Please help!
Joe, - Original Message - From: ""Joe Smith"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Monday, December 23, 2002 6:41 AM Subject: Innodb querry optimizer suddenly making TERRIBLE choices? Urgent, Please help! > I'm in a bit of a tough spot -- My innodb table of WebActionLogs (which > has 1 million rows spread out over the last year and a half) has suddenly > stopped using 'TimeInitiated' to select only the last 24 hours of data > (usually less than 7,500 rows), and now wants to copy all 1 million rows to > a temporary table no matter what I do!I tried adding a 'USE INDEX > (TimeInitiated_ind)', it STILL does the longest possible query by copying > everything to a temporary table first. > > Suddenly hundreds of queries that were working fine yesterday and ran under > 0.1 seconds are taking 40 to 50 seconds and ending up in the slow query log. > This has been working fine for months. > > Is there a way to FORCE innodb to use the index whethere it thinks it's > faster or not? I know it will be 400x faster if it does but USE INDEX > apparently has no effect. unfortunately USE INDEX has a a bit misleading name. It only bans MySQL from using any OTHER index than the ones listed in the argument, but it does not ban MySQL from using a table scan. We have talked that Monty should introduce a new clause FORCE INDEX(indexname) which would ban table scans. ... > +-+ > | VERSION() | > +-+ > | 3.23.51-log | > +-+ > > Thanks in advance for any clues! Please upgrade to 3.23.54b http://www.mysql.com/downloads/mysql-max-3.23.html. I have tuned the optimizer to favor index searches over table scans. > Joe Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com sql query - 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
Innodb querry optimizer suddenly making TERRIBLE choices? Urgent, Please help!
I'm in a bit of a tough spot -- My innodb table of WebActionLogs (which has 1 million rows spread out over the last year and a half) has suddenly stopped using 'TimeInitiated' to select only the last 24 hours of data (usually less than 7,500 rows), and now wants to copy all 1 million rows to a temporary table no matter what I do!I tried adding a 'USE INDEX (TimeInitiated_ind)', it STILL does the longest possible query by copying everything to a temporary table first. Suddenly hundreds of queries that were working fine yesterday and ran under 0.1 seconds are taking 40 to 50 seconds and ending up in the slow query log. This has been working fine for months. Is there a way to FORCE innodb to use the index whethere it thinks it's faster or not? I know it will be 400x faster if it does but USE INDEX apparently has no effect. I ran a 'check table WebActionLogs' which sait it was OK. I had a similar problem when this table was Myisam that was fixed by 'Analyze'ing it but that's not an available option for Innodb. mysql> explain SELECT DISTINCT UserName FROM WebActionLogs USE INDEX (TimeInitiated_ind) WHERE TimeInitiated > NOW() - INTERVAL 24 HOUR AND TimeInitiated < NOW() + INTERVAL 300 SECOND AND Id = 'xx.xx.44.17_3338_1039529682539_1248'; +--+---+---+--+-+--+ -++ | table| type | possible_keys | key | key_len | ref | rows| Extra | +--+---+---+--+-+--+ -++ | WebActionLogs| index | TimeInitiated_ind | UserName_idx | 31 | NULL | 1026114 | where used | If I remove the DISTINCT, no index is used!!! mysql> explain SELECT UserTelephoneNumber FROM CallMeBackLogs -> USE INDEX (TimeInitiated_ind) -> WHERE TimeInitiated > NOW() - INTERVAL 24 HOUR -> AND TimeInitiated < NOW() + INTERVAL 300 SECOND -> AND Guid = 'xx.xx.44.17_3338_1039529682539_1248'; +--+--+---+--+-+--+- ++ | table| type | possible_keys | key | key_len | ref | rows | Extra | +--+--+---+--+-+--+- ++ | WebActionLogs| ALL | TimeInitiated_ind | NULL |NULL | NULL | 1081857 | where used | +-+ | VERSION() | +-+ | 3.23.51-log | +-+ Thanks in advance for any clues! Joe - 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: Urgent: Please look at this error
It looks like you don't have a path to that library. Once you find the true location of libpthread.so, add that directory path to the file /etc/ld.conf. After that is done, run: ldconfig -v as root and try again. On Wed, 2002-03-20 at 09:13, Amrita Basu wrote: > Hi, I am using Redhat 6.2 kernel 2.2.20 and am getting > this error below. I know that these paths are > incorrect , should be /jive/usr/biosym/235 instead > of /usr/biosym... where do I change this? Which file? > Sorry if this is obvious, but I am new to mysql. > Thanks, > Amrita > > unknown user id: mysql > Starting mysqld daemon with databases from > /oscar2/mysql/mysql-3.23.47-sgi-irix6.5-mips/data > > 4673:/oscar2/mysql/mysql-3.23.47-sgi-irix6.5-mips/bin/mysqld: > rld: > Fatal Error: Cannot Successfully map soname > 'libpthread.so' under any of > the filenames > >/usr/biosym/235/irix51r4/biosymso/libpthread.so:/usr/lib32/libpthread.so:/usr/lib32/internal/libpthread.so:/lib32/libpthread.so:/opt/lib32/libpthread.so:/usr/biosym/235/irix51r4/biosymso/libpthread.so.1:/usr/lib32/libpthread.so.1:/usr/lib32/internal/libpthread.so.1:/lib32/libpthread.so.1:/opt/lib32/libpthread.so.1: > > 020319 18:46:10 mysqld ended > > > __ > Do You Yahoo!? > Yahoo! Sports - live college hoops coverage > http://sports.yahoo.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
Urgent: Please look at this error
Hi, I am using Redhat 6.2 kernel 2.2.20 and am getting this error below. I know that these paths are incorrect , should be /jive/usr/biosym/235 instead of /usr/biosym... where do I change this? Which file? Sorry if this is obvious, but I am new to mysql. Thanks, Amrita unknown user id: mysql Starting mysqld daemon with databases from /oscar2/mysql/mysql-3.23.47-sgi-irix6.5-mips/data 4673:/oscar2/mysql/mysql-3.23.47-sgi-irix6.5-mips/bin/mysqld: rld: Fatal Error: Cannot Successfully map soname 'libpthread.so' under any of the filenames /usr/biosym/235/irix51r4/biosymso/libpthread.so:/usr/lib32/libpthread.so:/usr/lib32/internal/libpthread.so:/lib32/libpthread.so:/opt/lib32/libpthread.so:/usr/biosym/235/irix51r4/biosymso/libpthread.so.1:/usr/lib32/libpthread.so.1:/usr/lib32/internal/libpthread.so.1:/lib32/libpthread.so.1:/opt/lib32/libpthread.so.1: 020319 18:46:10 mysqld ended __ Do You Yahoo!? Yahoo! Sports - live college hoops coverage http://sports.yahoo.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: Not Urgent . Please Don't care. (Can't Connect to Mysql Server on 192.9.200.2 (10055))
Hello. On Sat, Feb 03, 2001 at 01:54:14AM +0200, [EMAIL PROTECTED] wrote: > Dear Benjamin. > I firstly very very thanks for your interest. > This is my 3'rd mail with same question and you 're the first one who > reply. Well, it might be due to the fact that you have a rather unusual use pattern. [...] > > > > Description: > > > > I am connecting from Visual Basic 6 to Mysql via > > > > ODBC DSN. When i made 94 sleeped connection after 94 can't connect to > a > > > > server. It says : [TCX][MYODBC]Can't Connect to Mysql Server on > > > 192.9.200.2 > > > > (10055) > > > Is it fault of myodbc or mysql server? > > > > Is it normal. If there a maximum connection limit for process ? > > > > No. Your process is only limited by your OS. E.g. Linux defaults to a > > limit of 256 sockets per process. I don't know about Windows. > I know but i tried it on 1 GB RAM and dual processor PIII 700 MHZ on winnt 4 > with service pack 6 a. Well, your resources (e.g. memory) normally don't influence the default configuration automatically. That means, you should consult the usual Window NT resources (web pages, mailing lists?) how to change the process limit. [...] > > > > I think it is abnormal cause everyone is talking about > > > > 10.000 Web Hit. > > > > Sorry? You can handle 10.000 web hits with only one connection. > i am not interested about web. it works. no problem. Well, it was your example. ;-) [...] > Think a scenario : > You connect via ODBC or Data Environment from VB > then you get a recordset. > You will show this recordset on a grid. (excel style spreadsheet.) > if you use additem method , you can loop recordset and > manually add rows into grid then close recordset no problem. > > but if you bound grid into that dao object then until program or form close > it run as a sleep process. Well, that's the problem. It is usually (not only with MySQL) a good idea to block resources as short as possible. The suggested program doesn't do that. Even if the connection is idle, it blocks a connection. > and if you even use 3 connection for program , if max sleep process > is limited to 90 (due to your hardware configuration , but even if > you use 1 gb ram it is limited to max 120) that means maximum 30 > user will be execute your program. I assume that is only a parameter you have to change within NT. [...] > i have a critical product(which is written in vb for end users) > that needs at least 150 concurrent sleeped process to run. Well, but 150 concurrent connections may not be a problem even for NT *eg*. So, as said above, I suggest you check out the appropriate NT resources how to change the process limit (in hope that this is really the wall you hit, but it sounds so). Bye, Benjamin. - 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: Not Urgent . Please Don't care. (Can't Connect to Mysql Server on 192.9.200.2 (10055))
- Original Message - From: Yusuf Incekara <[EMAIL PROTECTED]> To: Benjamin Pflugmann <[EMAIL PROTECTED]> Cc: Mysql Mailing list <[EMAIL PROTECTED]> Sent: Saturday, February 03, 2001 1:54 AM Subject: Re: Not Urgent . Please Don't care. (Can't Connect to Mysql Server on 192.9.200.2 (10055)) > Dear Benjamin. > I firstly very very thanks for your interest. > This is my 3'rd mail with same question and you 're the first one who > reply. > > - Original Message - > From: Benjamin Pflugmann <[EMAIL PROTECTED]> > To: Yusuf Incekara <[EMAIL PROTECTED]> > Cc: Mysql Mailing list <[EMAIL PROTECTED]> > Sent: Friday, February 02, 2001 2:52 AM > Subject: Re: Not Urgent . Please Don't care. (Can't Connect to Mysql Server > on 192.9.200.2 (10055)) > > > > Hi. > > > > On Thu, Feb 01, 2001 at 08:18:45PM +0200, [EMAIL PROTECTED] wrote: > > > Would you please offer me something please ? > > > > > > > From: [EMAIL PROTECTED] > > > > To: [EMAIL PROTECTED] > > > > Subject: Mysql Bug ? (Can't Connect to Mysql Server on 192.9.200.2 > > > (10055)) > > > > > > > > > > > > Description: > > > > I am connecting from Visual Basic 6 to Mysql via > > > > ODBC DSN. When i made 94 sleeped connection after 94 can't connect to > a > > > > server. It says : [TCX][MYODBC]Can't Connect to Mysql Server on > > > 192.9.200.2 > > > > (10055) > > > Is it fault of myodbc or mysql server? > > > > Is it normal. If there a maximum connection limit for process ? > > > > No. Your process is only limited by your OS. E.g. Linux defaults to a > > limit of 256 sockets per process. I don't know about Windows. > I know but i tried it on 1 GB RAM and dual processor PIII 700 MHZ on winnt 4 > with service pack 6 a. > There is a concurrent sleeped process limit. Same on linux too also. > > > > > > > I think it is abnormal cause everyone is talking about > > > > 10.000 Web Hit. > > > > Sorry? You can handle 10.000 web hits with only one connection. > i am not interested about web. it works. no problem. > if you just create a server object on asp. loop the recordset. then close. > no problem. cause you only open 1 process then close. and it take 1 secs. > example. > > Think a scenario : > You connect via ODBC or Data Environment from VB > then you get a recordset. > You will show this recordset on a grid. (excel style spreadsheet.) > if you use additem method , you can loop recordset and > manually add rows into grid then close recordset no problem. > > but if you bound grid into that dao object then until program or form close > it run as a sleep process. > > and if you even use 3 connection for program , > if max sleep process is limited to 90 (due to your hardware configuration , > but even if you use 1 gb ram > it is limited to max 120) that means maximum 30 user will be execute your > program. > > and it is not satify us. > > > > > > Is it cause from sleeped process list ? > > > > Quite probably. Why do you need so much sleeping processes? Maybe > > there is a misconception about the need of them? > mentioned above > > > > > I increased maximum connection to 200 but it not works. I think > > > > it is not related with maximum connection. It is related with > > > > maximum process number. > > > > Why do you get so much processes? Do you really get so much hits? If > > so, maybe someone else can help (I have no clue about tuning Windows > > systems). > yes i really need this. as i mentioned above every executed compiled > software > will be needed at least 3 connection till to unloaded. > > > > > > > How-To-Repeat: > > > > Run this code on Microsoft Visual Basic 6 ENT Edition. > > > > > > > > For i = 1 To 200 > > > > Set Temp_Bag(i) = New ADODB.Connection > > > > Temp_Bag(i).Open "DSN=Avukatpro;UID=avukatpro;PWD=avukatpro" > > > > Next i > > > > It hangs 94 on Winnt. It hangs 60 on Win 95. It hangs 50 on Win98 SE. > > > > Well, do you have a production situation that hits the wall? If not, I > > wouldn't care about it. One of my servers delivers about 5.000.000 > > queries (300.000 web hits) a day with only 10-20 concurrent > > connections. (Not, that there is no need for hundreds of connections > > in some applications, but most time you don't need so much). > > i have a critical product(
Re: Not Urgent . Please Don't care. (Can't Connect to Mysql Server on 192.9.200.2 (10055))
Dear Benjamin. I firstly very very thanks for your interest. This is my 3'rd mail with same question and you 're the first one who reply. - Original Message - From: Benjamin Pflugmann <[EMAIL PROTECTED]> To: Yusuf Incekara <[EMAIL PROTECTED]> Cc: Mysql Mailing list <[EMAIL PROTECTED]> Sent: Friday, February 02, 2001 2:52 AM Subject: Re: Not Urgent . Please Don't care. (Can't Connect to Mysql Server on 192.9.200.2 (10055)) > Hi. > > On Thu, Feb 01, 2001 at 08:18:45PM +0200, [EMAIL PROTECTED] wrote: > > Would you please offer me something please ? > > > > > From: [EMAIL PROTECTED] > > > To: [EMAIL PROTECTED] > > > Subject: Mysql Bug ? (Can't Connect to Mysql Server on 192.9.200.2 > > (10055)) > > > > > > > > > Description: > > > I am connecting from Visual Basic 6 to Mysql via > > > ODBC DSN. When i made 94 sleeped connection after 94 can't connect to a > > > server. It says : [TCX][MYODBC]Can't Connect to Mysql Server on > > 192.9.200.2 > > > (10055) > > Is it fault of myodbc or mysql server? > > > Is it normal. If there a maximum connection limit for process ? > > No. Your process is only limited by your OS. E.g. Linux defaults to a > limit of 256 sockets per process. I don't know about Windows. I know but i tried it on 1 GB RAM and dual processor PIII 700 MHZ on winnt 4 with service pack 6 a. There is a concurrent sleeped process limit. Same on linux too also. > > > > I think it is abnormal cause everyone is talking about > > > 10.000 Web Hit. > > Sorry? You can handle 10.000 web hits with only one connection. i am not interested about web. it works. no problem. if you just create a server object on asp. loop the recordset. then close. no problem. cause you only open 1 process then close. and it take 1 secs. example. Think a scenario : You connect via ODBC or Data Environment from VB then you get a recordset. You will show this recordset on a grid. (excel style spreadsheet.) if you use additem method , you can loop recordset and manually add rows into grid then close recordset no problem. but if you bound grid into that dao object then until program or form close it run as a sleep process. and if you even use 3 connection for program , if max sleep process is limited to 90 (due to your hardware configuration , but even if you use 1 gb ram it is limited to max 120) that means maximum 30 user will be execute your program. and it is not satify us. > > > Is it cause from sleeped process list ? > > Quite probably. Why do you need so much sleeping processes? Maybe > there is a misconception about the need of them? mentioned above > > > I increased maximum connection to 200 but it not works. I think > > > it is not related with maximum connection. It is related with > > > maximum process number. > > Why do you get so much processes? Do you really get so much hits? If > so, maybe someone else can help (I have no clue about tuning Windows > systems). yes i really need this. as i mentioned above every executed compiled software will be needed at least 3 connection till to unloaded. > > > > How-To-Repeat: > > > Run this code on Microsoft Visual Basic 6 ENT Edition. > > > > > > For i = 1 To 200 > > > Set Temp_Bag(i) = New ADODB.Connection > > > Temp_Bag(i).Open "DSN=Avukatpro;UID=avukatpro;PWD=avukatpro" > > > Next i > > > It hangs 94 on Winnt. It hangs 60 on Win 95. It hangs 50 on Win98 SE. > > Well, do you have a production situation that hits the wall? If not, I > wouldn't care about it. One of my servers delivers about 5.000.000 > queries (300.000 web hits) a day with only 10-20 concurrent > connections. (Not, that there is no need for hundreds of connections > in some applications, but most time you don't need so much). i have a critical product(which is written in vb for end users) that needs at least 150 concurrent sleeped process to run. > > [...] > > > Release: mysql-3.23.26-beta > > > > > > Exectutable: mysqld-nt and mysqld-opt > > > Environment: PIII 700 MHZ Intel,256 MB RAM with WinNT4 , > > > Same Problem on PIII MHZ Intel with 128 MB Ram > > > System:WinNT4 with Service Pack 6a, Internet Explorer 5 > > > Same problem on Windows 95 Osr 2 > > > Same Problem on Windows 98 SE > [...] > > Bye, > > Benjamin. > > - 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: Not Urgent . Please Don't care. (Can't Connect to Mysql Server on 192.9.200.2 (10055))
Hi. On Thu, Feb 01, 2001 at 08:18:45PM +0200, [EMAIL PROTECTED] wrote: > Would you please offer me something please ? > > > From: [EMAIL PROTECTED] > > To: [EMAIL PROTECTED] > > Subject: Mysql Bug ? (Can't Connect to Mysql Server on 192.9.200.2 > (10055)) > > > > > > Description: > > I am connecting from Visual Basic 6 to Mysql via > > ODBC DSN. When i made 94 sleeped connection after 94 can't connect to a > > server. It says : [TCX][MYODBC]Can't Connect to Mysql Server on > 192.9.200.2 > > (10055) > Is it fault of myodbc or mysql server? > > Is it normal. If there a maximum connection limit for process ? No. Your process is only limited by your OS. E.g. Linux defaults to a limit of 256 sockets per process. I don't know about Windows. > > I think it is abnormal cause everyone is talking about > > 10.000 Web Hit. Sorry? You can handle 10.000 web hits with only one connection. > Is it cause from sleeped process list ? Quite probably. Why do you need so much sleeping processes? Maybe there is a misconception about the need of them? > > I increased maximum connection to 200 but it not works. I think > > it is not related with maximum connection. It is related with > > maximum process number. Why do you get so much processes? Do you really get so much hits? If so, maybe someone else can help (I have no clue about tuning Windows systems). > > How-To-Repeat: > > Run this code on Microsoft Visual Basic 6 ENT Edition. > > > > For i = 1 To 200 > > Set Temp_Bag(i) = New ADODB.Connection > > Temp_Bag(i).Open "DSN=Avukatpro;UID=avukatpro;PWD=avukatpro" > > Next i > > It hangs 94 on Winnt. It hangs 60 on Win 95. It hangs 50 on Win98 SE. Well, do you have a production situation that hits the wall? If not, I wouldn't care about it. One of my servers delivers about 5.000.000 queries (300.000 web hits) a day with only 10-20 concurrent connections. (Not, that there is no need for hundreds of connections in some applications, but most time you don't need so much). [...] > > Release: mysql-3.23.26-beta > > > > Exectutable: mysqld-nt and mysqld-opt > > Environment: PIII 700 MHZ Intel,256 MB RAM with WinNT4 , > > Same Problem on PIII MHZ Intel with 128 MB Ram > > System:WinNT4 with Service Pack 6a, Internet Explorer 5 > > Same problem on Windows 95 Osr 2 > > Same Problem on Windows 98 SE [...] Bye, Benjamin. - 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
Not Urgent . Please Don't care. (Can't Connect to Mysql Server on 192.9.200.2 (10055))
Would you please offer me something please ? > From: [EMAIL PROTECTED] > To: [EMAIL PROTECTED] > Subject: Mysql Bug ? (Can't Connect to Mysql Server on 192.9.200.2 (10055)) > > > Description: > I am connecting from Visual Basic 6 to Mysql via > ODBC DSN. When i made 94 sleeped connection after 94 can't connect to a > server. It says : [TCX][MYODBC]Can't Connect to Mysql Server on 192.9.200.2 > (10055) Is it fault of myodbc or mysql server? > Is it normal. If there a maximum connection limit for process ? > I think it is abnormal cause everyone is talking about > 10.000 Web Hit. Is it cause from sleeped process list ? > I increased maximum connection to 200 but it not works. > I think it is not related with maximum connection . It is related with > maximum process number. > > > How-To-Repeat: > Run this code on Microsoft Visual Basic 6 ENT Edition. > > For i = 1 To 200 > Set Temp_Bag(i) = New ADODB.Connection > Temp_Bag(i).Open "DSN=Avukatpro;UID=avukatpro;PWD=avukatpro" > Next i > It hangs 94 on Winnt. It hangs 60 on Win 95. It hangs 50 on Win98 SE. > > > Fix: > Any offer? What means 10055 ? I check-out documents. Can't see any > recomend or definition for this error number. > > Additional Information : > Host: 3.23.30-gamma > ClientInfo: 3.23.6-alpha > HostInfo: 192.9.200.2 via TCP/IP > ProtoInfo: 10 > > I stopped on 93 process and got process list. It is attached. > > > Synopsis: > Submitter-Id: Yusuf Incekara > Originator: Yusuf Incekara > Organization: Avukatpro Limited Sirketi > MySQL support: None > Severity: Critical > Priority: High > Category: mysqld, ODBC > Class: sw-bug,ODBC-bug > Release: mysql-3.23.26-beta > > Exectutable: mysqld-nt and mysqld-opt > Environment: PIII 700 MHZ Intel,256 MB RAM with WinNT4 , > Same Problem on PIII MHZ Intel with 128 MB Ram > System:WinNT4 with Service Pack 6a, Internet Explorer 5 > Same problem on Windows 95 Osr 2 > Same Problem on Windows 98 SE > Compiler: ? > Architecture: i686 > > +-+---+---+---+-+--+---+--+ | Id | User | Host | db| Command | Time | State | Info | +-+---+---+---+-+--+---+--+ | 1 | root | INCEKARA2 | mysql | Sleep | 1114 | | | | 189 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 190 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 191 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 192 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 193 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 194 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 195 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 196 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 197 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 198 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 199 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 200 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 201 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 202 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 203 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 204 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 205 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 206 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 207 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 208 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 209 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 210 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 211 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 212 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 213 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 214 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 215 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 216 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 217 | avukatpro | INCEKARA2 | avukatpro | Sleep | 16 | | | | 218 | avukatpro | INCEKARA2 | avukatpr
