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
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: 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
