mysql5.4 bugs about mysqladmin??
Hi,I'm using mysql5.4-beta now.when I use flow command ,it does not works,is mysql5.4 bug? The command mysqladmin -p -r --sleep=1 --count=100 extended-status It run only one time. Thanks! -邮件原件- 发件人: mos [mailto:mo...@fastmail.fm] 发送时间: 2009年5月18日 2:14 收件人: mysql@lists.mysql.com 主题: Problem setting up slow logging in my,ini file I'm having a problem defining slow logging file in my.ini (Windows XP). I'm using MySQL 5.1.30. In the MySQL reference manual it says: As of MySQL 5.1.29, the --log-slow-queries option is deprecated and will be removed (along with the log_slow_queries system variable) in MySQL 7.0. Instead, use the --slow_query_log option to enable the slow query log and the --slow_query_log_file=file_name option to set the slow query log file name. So my.ini has: [mysqld] general_log=1 log-output=FILE general_log_file=LOG.TXT slow_query_log=1 slow_query_log_file=SLOWLOG.TXT After I restart MySQL, the variables have: Variable_nameValue --- -- log ON log_bin OFF log_output FILE log_queries_not_using_indexesOFF log_slow_queries ON log_warnings 1 slow_query_log ON slow_query_log_file OFF sql_log_bin ON sql_log_off OFF sql_log_update ON So why is the variable slow_query_log_file set to OFF because it is not boolean and should be a file name? Why isn't it set to the file name SLOWLOG.TXT? TIA Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=yanwei.z...@opi-corp.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: load data into temporary table
Hi, mysql create temporary table t(i int); mysql \! echo 1 /tmp/data.txt mysql load data infile '/tmp/data.txt' into table t; Query OK, 1 row affected (0.00 sec) Records: 1 Deleted: 0 Skipped: 0 Warnings: 0 mysql select * from t; +--+ | i| +--+ |1 | +--+ 1 row in set (0.00 sec) Best Regards, -Janek, CMDEV 5.0. StudyLink. Helping People Realise Their Potential. http://studylink.com On Tue, 2009-05-19 at 02:57 +0100, Alex K wrote: Hello, Would anyone know how to load data infile into a temporary table? Thank you, Alex -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: load data into temporary table
Thank you but the real problem occurs when you don't know the schema of the table in advance. If data.txt has two columns columns how can I still load it in a temporary table? I'm asking this question because I'd like to add an import csv feature to a web application. I know that you can load data infile into table without specifying the schema of this table but it does not look like you can do load data infile into a temporary table. Thank you, Alex 2009/5/19 Janek Bogucki janek.bogu...@studylink.com: Hi, mysql create temporary table t(i int); mysql \! echo 1 /tmp/data.txt mysql load data infile '/tmp/data.txt' into table t; Query OK, 1 row affected (0.00 sec) Records: 1 Deleted: 0 Skipped: 0 Warnings: 0 mysql select * from t; +--+ | i | +--+ | 1 | +--+ 1 row in set (0.00 sec) Best Regards, -Janek, CMDEV 5.0. StudyLink. Helping People Realise Their Potential. http://studylink.com On Tue, 2009-05-19 at 02:57 +0100, Alex K wrote: Hello, Would anyone know how to load data infile into a temporary table? Thank you, Alex -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=alex.ksi...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
row level lock
Hi all How to use the row level locaking in innodb , i dont know, even in my friend circle also , they are not worked in the row level locking and all , Can u please tell som brifly also with some example snippet's thanks -- உங்கள் நண்பன் பரணி குமார் Regards B.S.Bharanikumar POST YOUR OPINION http://bharanikumariyerphp.site88.net/bharanikumar/
mysql not able to import mysqldump file
Hello: I have a database with several double columns in the tables. I used mysqldump to dump the data from the primary database and I am trying to import it into a secondary database. I am importing the data by passing the generated sql file to the mysql command line client. When I do that, I am getting this error: Illegal double '1.79769313486232e+308' value found during parsing Any ideas how to fix this? Thanks, Neil -- Neil Aggarwal, (832)245-7314, www.JAMMConsulting.com Eliminate junk email and reclaim your inbox. Visit http://www.spammilter.com for details. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
What is wrong with this SYNTAX?
It is complaining about near STRCMP. CREATE TRIGGER bgp.tglobal BEFORE UPDATE on bgp.global FOR EACH ROW BEGIN IF STRCMP(NEW.Variable_name,'ASN') != 0 THEN set NEW.Variable_name=NULL; ELSEIF STRCMP(NEW.Variable_name, 'RouterId') != 0 THEN set NEW.Variable_name=NULL ELSEIF STRCMP(NEW.Variable_name, 'ASN') != 0 THEN set NEW.Value=CONVERT(CONVERT(NEW.Value, UNSIGNED), CHAR); ELSEIF STRCMP(NEW.Variable_name, 'RouterId') != 0 THEN set NEW.Value=INET_NTOA(INET_ATON(NEW.Value)); ENDIF END Thanks in advance! Alex
RE: What is wrong with this SYNTAX?
DELIMITER $$ CREATE TRIGGER bgp.tglobal BEFORE UPDATE on bgp.global FOR EACH ROW BEGIN IF STRCMP(NEW.Variable_name,'ASN') != 0 THEN set NEW.Variable_name=NULL; ELSEIF STRCMP(NEW.Variable_name, 'RouterId') != 0 THEN set NEW.Variable_name=NULL (-- Missing Semicolon) ELSEIF STRCMP(NEW.Variable_name, 'ASN') != 0 THEN (-- Same as IF) set NEW.Value=CONVERT(CONVERT(NEW.Value, UNSIGNED), CHAR); ELSEIF STRCMP(NEW.Variable_name, 'RouterId') != 0 THEN (-- Same as First ELSEIF) set NEW.Value=INET_NTOA(INET_ATON(NEW.Value)); ENDIF END; DELIMITER ; Rolando A. Edwards MySQL DBA (CMDBA) 155 Avenue of the Americas, Fifth Floor New York, NY 10013 212-625-5307 (Work) 201-660-3221 (Cell) AIM : RolandoLogicWorx Skype : RolandoLogicWorx redwa...@logicworks.net -Original Message- From: Alex Katebi [mailto:alex.kat...@gmail.com] Sent: Tuesday, May 19, 2009 10:33 AM To: mysql@lists.mysql.com Subject: What is wrong with this SYNTAX? It is complaining about near STRCMP. CREATE TRIGGER bgp.tglobal BEFORE UPDATE on bgp.global FOR EACH ROW BEGIN IF STRCMP(NEW.Variable_name,'ASN') != 0 THEN set NEW.Variable_name=NULL; ELSEIF STRCMP(NEW.Variable_name, 'RouterId') != 0 THEN set NEW.Variable_name=NULL ELSEIF STRCMP(NEW.Variable_name, 'ASN') != 0 THEN set NEW.Value=CONVERT(CONVERT(NEW.Value, UNSIGNED), CHAR); ELSEIF STRCMP(NEW.Variable_name, 'RouterId') != 0 THEN set NEW.Value=INET_NTOA(INET_ATON(NEW.Value)); ENDIF END Thanks in advance! Alex -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: mysql not able to import mysqldump file
Hi Niel, What version is the mysql dump from? Are you importing to a different version? Could you show the line from the file that is generating the error? Regards, Gavin Towey -Original Message- From: Neil Aggarwal [mailto:n...@jammconsulting.com] Sent: Tuesday, May 19, 2009 6:56 AM To: mysql@lists.mysql.com Subject: mysql not able to import mysqldump file Hello: I have a database with several double columns in the tables. I used mysqldump to dump the data from the primary database and I am trying to import it into a secondary database. I am importing the data by passing the generated sql file to the mysql command line client. When I do that, I am getting this error: Illegal double '1.79769313486232e+308' value found during parsing Any ideas how to fix this? Thanks, Neil -- Neil Aggarwal, (832)245-7314, www.JAMMConsulting.com Eliminate junk email and reclaim your inbox. Visit http://www.spammilter.com for details. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=gto...@ffn.com The information contained in this transmission may contain privileged and confidential information. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: load data into temporary table
Hi Alex, It is true that use LOAD DATA INFILE you do need to know the schema of the table. I'm not sure how useful it would be to import arbitrary data if you don't have some expectations about what that data is. There are a couple options for you: 1. Make sure your users upload a CSV is a specific format, reject non-conforming input. 2. Let your script transform the user uploaded CSV file into the format the database is expecting. 3. Have your script simply parse the user uploaded CSV and generate insert statements as needed. Just because you want to accept CSV from your app, does not mean you must use LOAD DATA INFILE to get the data into MySQL. Regards, Gavin Towey -Original Message- From: alex.ksi...@gmail.com [mailto:alex.ksi...@gmail.com] On Behalf Of Alex K Sent: Tuesday, May 19, 2009 5:43 AM To: MySQL General List Subject: Re: load data into temporary table Thank you but the real problem occurs when you don't know the schema of the table in advance. If data.txt has two columns columns how can I still load it in a temporary table? I'm asking this question because I'd like to add an import csv feature to a web application. I know that you can load data infile into table without specifying the schema of this table but it does not look like you can do load data infile into a temporary table. Thank you, Alex 2009/5/19 Janek Bogucki janek.bogu...@studylink.com: Hi, mysql create temporary table t(i int); mysql \! echo 1 /tmp/data.txt mysql load data infile '/tmp/data.txt' into table t; Query OK, 1 row affected (0.00 sec) Records: 1 Deleted: 0 Skipped: 0 Warnings: 0 mysql select * from t; +--+ | i| +--+ |1 | +--+ 1 row in set (0.00 sec) Best Regards, -Janek, CMDEV 5.0. StudyLink. Helping People Realise Their Potential. http://studylink.com On Tue, 2009-05-19 at 02:57 +0100, Alex K wrote: Hello, Would anyone know how to load data infile into a temporary table? Thank you, Alex -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=alex.ksi...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=gto...@ffn.com The information contained in this transmission may contain privileged and confidential information. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: mysql not able to import mysqldump file
Gavin: Both servers are mysql-server.x86_64 5.0.45-7.el5 installed using yum on CentOS 5. I was able to work around it by doing a global replace of that string with 1.79769313486e+308 since it apparently just barely exceeded the max double value. The values were originally stored using the Java Double.MAX_VALUE constant over JDBC. There should not be this inconsistency between what mysqldump creates and what the server can handle since the platform and version are exactly the same. Having said that, there is an easy fix so it is not a big deal. Thanks, Neil -- Neil Aggarwal, (832)245-7314, www.JAMMConsulting.com Eliminate junk email and reclaim your inbox. Visit http://www.spammilter.com for details. -Original Message- From: Gavin Towey [mailto:gto...@ffn.com] Sent: Tuesday, May 19, 2009 1:05 PM To: Neil Aggarwal; mysql@lists.mysql.com Subject: RE: mysql not able to import mysqldump file Hi Niel, What version is the mysql dump from? Are you importing to a different version? Could you show the line from the file that is generating the error? Regards, Gavin Towey -Original Message- From: Neil Aggarwal [mailto:n...@jammconsulting.com] Sent: Tuesday, May 19, 2009 6:56 AM To: mysql@lists.mysql.com Subject: mysql not able to import mysqldump file Hello: I have a database with several double columns in the tables. I used mysqldump to dump the data from the primary database and I am trying to import it into a secondary database. I am importing the data by passing the generated sql file to the mysql command line client. When I do that, I am getting this error: Illegal double '1.79769313486232e+308' value found during parsing Any ideas how to fix this? Thanks, Neil -- Neil Aggarwal, (832)245-7314, www.JAMMConsulting.com Eliminate junk email and reclaim your inbox. Visit http://www.spammilter.com for details. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=gto...@ffn.com The information contained in this transmission may contain privileged and confidential information. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: mysql not able to import mysqldump file
Neil- http://wiki.seas.harvard.edu/geos-chem/index.php/Floating_point_math_issues so a value this large or small would only be true for 8byte double datatype Curious as to what the original Table/Column datatype is hth Martin __ Jogi és Bizalmassági kinyilatkoztatás/Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Ez az üzenet bizalmas. Ha nem ön az akinek szánva volt, akkor kérjük, hogy jelentse azt nekünk vissza. Semmiféle továbbítása vagy másolatának készítése nem megengedett. Ez az üzenet csak ismeret cserét szolgál és semmiféle jogi alkalmazhatósága sincs. Mivel az electronikus üzenetek könnyen megváltoztathatóak, ezért minket semmi felelöség nem terhelhet ezen üzenet tartalma miatt. Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. From: n...@jammconsulting.com To: mysql@lists.mysql.com Subject: RE: mysql not able to import mysqldump file Date: Tue, 19 May 2009 13:40:43 -0500 Gavin: Both servers are mysql-server.x86_64 5.0.45-7.el5 installed using yum on CentOS 5. I was able to work around it by doing a global replace of that string with 1.79769313486e+308 since it apparently just barely exceeded the max double value. The values were originally stored using the Java Double.MAX_VALUE constant over JDBC. There should not be this inconsistency between what mysqldump creates and what the server can handle since the platform and version are exactly the same. Having said that, there is an easy fix so it is not a big deal. Thanks, Neil -- Neil Aggarwal, (832)245-7314, www.JAMMConsulting.com Eliminate junk email and reclaim your inbox. Visit http://www.spammilter.com for details. -Original Message- From: Gavin Towey [mailto:gto...@ffn.com] Sent: Tuesday, May 19, 2009 1:05 PM To: Neil Aggarwal; mysql@lists.mysql.com Subject: RE: mysql not able to import mysqldump file Hi Niel, What version is the mysql dump from? Are you importing to a different version? Could you show the line from the file that is generating the error? Regards, Gavin Towey -Original Message- From: Neil Aggarwal [mailto:n...@jammconsulting.com] Sent: Tuesday, May 19, 2009 6:56 AM To: mysql@lists.mysql.com Subject: mysql not able to import mysqldump file Hello: I have a database with several double columns in the tables. I used mysqldump to dump the data from the primary database and I am trying to import it into a secondary database. I am importing the data by passing the generated sql file to the mysql command line client. When I do that, I am getting this error: Illegal double '1.79769313486232e+308' value found during parsing Any ideas how to fix this? Thanks, Neil -- Neil Aggarwal, (832)245-7314, www.JAMMConsulting.com Eliminate junk email and reclaim your inbox. Visit http://www.spammilter.com for details. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=gto...@ffn.com The information contained in this transmission may contain privileged and confidential information. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=mgai...@hotmail.com _ Hotmail® has a new way to see what's up with your friends. http://windowslive.com/Tutorial/Hotmail/WhatsNew?ocid=TXT_TAGLM_WL_HM_Tutorial_WhatsNew1_052009
RE: What is wrong with this SYNTAX?
DELIMITER $$ CREATE TRIGGER bgp.tglobal BEFORE UPDATE on bgp.global FOR EACH ROW BEGIN IF STRCMP(NEW.Variable_name,'ASN') != 0 THEN set NEW.Variable_name=NULL; ELSEIF STRCMP(NEW.Variable_name, 'RouterId') != 0 THEN set NEW.Variable_name=NULL (-- Missing Semicolon) ELSEIF STRCMP(NEW.Variable_name, 'ASN') != 0 THEN (-- Same as IF) set NEW.Value=CONVERT(CONVERT(NEW.Value, UNSIGNED), CHAR); ELSEIF STRCMP(NEW.Variable_name, 'RouterId') != 0 THEN (-- Same as First ELSEIF) set NEW.Value=INET_NTOA(INET_ATON(NEW.Value)); ENDIF (-- Missing Semicolon) END; DELIMITER ; Rolando A. Edwards MySQL DBA (CMDBA) 155 Avenue of the Americas, Fifth Floor New York, NY 10013 212-625-5307 (Work) 201-660-3221 (Cell) AIM Skype : RolandoLogicWorx redwa...@logicworks.net -Original Message- From: Rolando Edwards [mailto:redwa...@logicworks.net] Sent: Tuesday, May 19, 2009 12:40 PM To: Alex Katebi; mysql@lists.mysql.com Subject: RE: What is wrong with this SYNTAX? DELIMITER $$ CREATE TRIGGER bgp.tglobal BEFORE UPDATE on bgp.global FOR EACH ROW BEGIN IF STRCMP(NEW.Variable_name,'ASN') != 0 THEN set NEW.Variable_name=NULL; ELSEIF STRCMP(NEW.Variable_name, 'RouterId') != 0 THEN set NEW.Variable_name=NULL (-- Missing Semicolon) ELSEIF STRCMP(NEW.Variable_name, 'ASN') != 0 THEN (-- Same as IF) set NEW.Value=CONVERT(CONVERT(NEW.Value, UNSIGNED), CHAR); ELSEIF STRCMP(NEW.Variable_name, 'RouterId') != 0 THEN (-- Same as First ELSEIF) set NEW.Value=INET_NTOA(INET_ATON(NEW.Value)); ENDIF END; DELIMITER ; Rolando A. Edwards MySQL DBA (CMDBA) 155 Avenue of the Americas, Fifth Floor New York, NY 10013 212-625-5307 (Work) 201-660-3221 (Cell) AIM : RolandoLogicWorx Skype : RolandoLogicWorx redwa...@logicworks.net -Original Message- From: Alex Katebi [mailto:alex.kat...@gmail.com] Sent: Tuesday, May 19, 2009 10:33 AM To: mysql@lists.mysql.com Subject: What is wrong with this SYNTAX? It is complaining about near STRCMP. CREATE TRIGGER bgp.tglobal BEFORE UPDATE on bgp.global FOR EACH ROW BEGIN IF STRCMP(NEW.Variable_name,'ASN') != 0 THEN set NEW.Variable_name=NULL; ELSEIF STRCMP(NEW.Variable_name, 'RouterId') != 0 THEN set NEW.Variable_name=NULL ELSEIF STRCMP(NEW.Variable_name, 'ASN') != 0 THEN set NEW.Value=CONVERT(CONVERT(NEW.Value, UNSIGNED), CHAR); ELSEIF STRCMP(NEW.Variable_name, 'RouterId') != 0 THEN set NEW.Value=INET_NTOA(INET_ATON(NEW.Value)); ENDIF END Thanks in advance! Alex -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=redwa...@logicworks.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: mysql not able to import mysqldump file
Martin: Both tables have double for the column. Neil -- Neil Aggarwal, (832)245-7314, www.JAMMConsulting.com Eliminate junk email and reclaim your inbox. Visit http://www.spammilter.com for details. -Original Message- From: Martin Gainty [mailto:mgai...@hotmail.com] Sent: Tuesday, May 19, 2009 2:37 PM To: n...@jammconsulting.com; mysql@lists.mysql.com Subject: RE: mysql not able to import mysqldump file Neil- http://wiki.seas.harvard.edu/geos-chem/index.php/Floating_poin t_math_issues so a value this large or small would only be true for 8byte double datatype Curious as to what the original Table/Column datatype is hth Martin __ Jogi és Bizalmassági kinyilatkoztatás/Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Ez az üzenet bizalmas. Ha nem ön az akinek szánva volt, akkor kérjük, hogy jelentse azt nekünk vissza. Semmiféle továbbítása vagy másolatának készítése nem megengedett. Ez az üzenet csak ismeret cserét szolgál és semmiféle jogi alkalmazhatósága sincs. Mivel az electronikus üzenetek könnyen megváltoztathatóak, ezért minket semmi felelöség nem terhelhet ezen üzenet tartalma miatt. Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. From: n...@jammconsulting.com To: mysql@lists.mysql.com Subject: RE: mysql not able to import mysqldump file Date: Tue, 19 May 2009 13:40:43 -0500 Gavin: Both servers are mysql-server.x86_64 5.0.45-7.el5 installed using yum on CentOS 5. I was able to work around it by doing a global replace of that string with 1.79769313486e+308 since it apparently just barely exceeded the max double value. The values were originally stored using the Java Double.MAX_VALUE constant over JDBC. There should not be this inconsistency between what mysqldump creates and what the server can handle since the platform and version are exactly the same. Having said that, there is an easy fix so it is not a big deal. Thanks, Neil -- Neil Aggarwal, (832)245-7314, www.JAMMConsulting.com Eliminate junk email and reclaim your inbox. Visit http://www.spammilter.com for details. -Original Message- From: Gavin Towey [mailto:gto...@ffn.com] Sent: Tuesday, May 19, 2009 1:05 PM To: Neil Aggarwal; mysql@lists.mysql.com Subject: RE: mysql not able to import mysqldump file Hi Niel, What version is the mysql dump from? Are you importing to a different version? Could you show the line from the file that is generating the error? Regards, Gavin Towey -Original Message- From: Neil Aggarwal [mailto:n...@jammconsulting.com] Sent: Tuesday, May 19, 2009 6:56 AM To: mysql@lists.mysql.com Subject: mysql not able to import mysqldump file Hello: I have a database with several double columns in the tables. I used mysqldump to dump the data from the primary database and I am trying to import it into a secondary database. I am importing the data by passing the generated sql file to the mysql command line client. When I do that, I am getting this error: Illegal double '1.79769313486232e+308' value found during parsing Any ideas how to fix this? Thanks, Neil -- Neil Aggarwal, (832)245-7314, www.JAMMConsulting.com Eliminate junk email and reclaim your inbox. Visit http://www.spammilter.com for details. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=gto...@ffn.com The information contained in this transmission may contain privileged and confidential information. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the
