Re: error code 139 innodb

2009-10-15 Thread Kyong Kim 
Raj,
Yup. It's that bug.
I got the row size to below 8K and the insertion takes place fine.
Thanks for pointing me in the right direction.
Kyong

On Wed, Oct 14, 2009 at 10:31 AM, Raj Shekhar  wrote:
> Kyong Kim  gmail.com> writes:
>
>> For sure all of our columns combined do not exceed 64K. We're using
>> latin 1 character set.
>> I don't think we would be running into the 8K limit on row length
>> since the culprit seems to be data being inserted into VARCHAR(255)
>> column.
>
> Can you show us your "create table"?
>
> This might be a known bug http://bugs.mysql.com/bug.php?id=25945
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=kykim...@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

Re: Inserting an Image

2009-10-15 Thread Michael Dykman 
Victor,

again, your question has more to do with python usage than MySQL
per-se..  you would be better off pursuing these questions in a python
forum.

 - michael dykman

On Thu, Oct 15, 2009 at 3:28 PM, Gavin Towey  wrote:
> "Image in string form"  sounds like you're not inserting binary data, rather 
> some sort of encoded data.  Even if it is binary, you'll have to escape at 
> least end quote characters, you can see clearly at the top of your data there 
> is :
> 'ÿØÿà JFIF ÿÛC "" $(4,$&1'
>
>
> Another thing to think about is storing image data directly in a database is 
> often not a good idea. See these links for more info:
>
> http://mysqldump.azundris.com/archives/36-Serving-Images-From-A-Database.html 
> and http://hashmysql.org/index.php?title=Storing_files_in_the_database
>
> Regards,
> Gavin Towey
>
> -Original Message-
> From: Victor Subervi [mailto:victorsube...@gmail.com]
> Sent: Thursday, October 15, 2009 12:05 PM
> To: mysql@lists.mysql.com
> Subject: Inserting an Image
>
> Hi;
> I have successfully inserted images, like yesterday, before into MySQL with
> the following code:
>
>      sql = 'update productsX set pic1="%s" where ID=2;' % pic1
>      cursor.execute(sql)
> where pic1 is simply an image uploaded through a form then sent over without
> any alteration to another (python) script that uploads it.  Printing it out
> looks like this (other variables included):
>
> update productsX set Name=%s, Title=%s, Description=%s, Price=%s,
> Bedrooms=%s, Bathrooms=%s, Conditions=%s, Acreage=%s, Construction=%s,
> Location=%s, Estate=%s, Address=%s, Furnished=%s, pic1=%s, pic2=%s, pic3=%s,
> pic4=%s, pic5=%s, pic6=%s where ID=%s;', ('name1', 'title1', 'descr1',
> '1.1', '2', '1', 'New', '1.5', 'New', 'arbor', 'abor', 'abor', 'Furnished',
> 'ÿØÿà JFIF ÿÛC "" $(4,$&1' -=-157:::#+?D?8C49:7ÿÛC 7%
> %77ÿÀ y| " ÿÄ ÿÄM !1A Qa "qs
> ³ 27Bbc‚ #46Rrt‘¡±² $'3C’%5DTUƒ“¢£ÑñÿÄ ÿÄ ÿÚ ?œ*‹RP’¥¨% d’pªÔcµkä«”øZ Âá îj
> Xêxö, `...@$ý <%6...@$ý> ô¨2mÒžÚ ¦ ÚRÑ¥¬ò guD|!%bO :ðç’ Z…æµËÚvsM¡·¢&T ‘œ¬ ºâ
> “ñ â1Ò¶¶KT[%¦-² {‘£6 Ô÷“âNI=äÒfÓ ø/RhËîR”³q1 QüÇ“ƒŸ ƒE Š Š( (¢Š Š( (¢Š Š( ×ê
> ´{ –mÒYü VTâ†pUŽI $à Qvà ɼÜ/ZÒì{IrÝ,´£È x ß #¸$Š·÷F_Ë ë}……áRTdH ó
> Á#ÐU“ö*DÙõ¨Yt]ž îêÑ +p}5ùêÿ¹F † vã Êöy5Ô‚\ˆëO Žc 'ö(Óõku-´^4õÊÚ Ú£8Ðð%$ ì84
> Ú*ø G¥­·T Vû#µc æ ·uÏ; Ö"ÓusN\\Ü‹5{ÑʸvoòÝû@ é ¼×CP U
> ¤¡%KPJR2I8T+´½¨®{ß{:)kzD‡; &2~1' ¤“ ïÙßA¶Õº®íª5 Ñú AiMçá ’O ’8 •tÆpHâNÇ
> Uºl¤Ûmë¸é«ÝÙ øéí û’7�...@guc q Ó ŠhÙ¶ cFØ Í\çðäLJÎ^8$} ä í=i² Aj ©ôœ «‰J_u
> /¥<ƒ‰%*áÓˆÎ;ˆ¦ TÐö©6)WûjØZ`ü dÂsæ–ÝHQB E@ m5Ð QE EbÜî
> íP]›q’Üx̧yn8pÿ߇3IP5–¨¿´©úgL2å©K)aéÒû ¼ 5 ã‚s 8žT æÕæ*ýµ)Q’­ä4óp› ¦0 ?ÌU]B
> r + ç\»]_"éŸ pTŒŸXU] Èò ­ “¬gK ®tTxò^i‰ É 4‡ Rè ¤ à8 Y«›` üM ]ߊ󌼀ÑK
> ,¥Iü29 ƃž6™iU‡]Ý£ È/²G 5~xÇ£8öT۱͡§SÀ ›«¿éˆÈॠÆ[ ;ô‡Qן~4»vÒOܬðu ”ëÐÙ Ë
> %®a d“Ÿ g ¨Ãe1. õõœÛ æû2 ëËG$4>9' )$xç h3ö‰´Ë®­ ôHî.%œ,†ã ຠx S× ‡Ž3Nû
> ÐËAûêº5Œ‚ˆ ¨qÁৠˆ ÓÜh±ìËOÏÚV¢‰ >`ÛTíÅß «.¤¨¥Gžè<€ãŽg½ãP<ìM£h¸1 [ ÌÄ®;J)mA-
> ÐR8 :g• ãXjû> ‚™W‡Ô „†Xho8é ÷G‡yÀâ8ñ ‡¤õ5ëQ¥‰Ÿ{žCjxo7"LÑÚ­ à ØG#Ú‡ ‘ž¨ t
> –›-LjFžhÈÂXy¥(… \8) ŽJð} -ÜKp¬’ T–PÔu œî €“Œ ” ôTc¢ö…§íZ Ò«õùµMì h‚µ<öwŽ7€É
> 1Î’šÛ2­7 ó ";= & b*Sê e Æ7xž|p è:@Ö[YÓÚq.1 Ñs¸'€b2 BOÓ_!è > ¡
> ¦²Özòbm©}÷ƒêÂ`ÂFâ ¤ $ õ Š•vq±è–bÍÏR†æ\ ˆÃÎiƒãùê °tÏ A‡§4Þ Ú<ÆoÚíkfÐ… õ¤
> %ÁÑE<Â|Oœ¯ ŒÌM4Û-!¦ ”6€ ”$`$ @ ‚½t¢ƒˆ_Bš}Æ× ä(¥Yç k®vqyM÷DÚf…ï9äéiîþÑ
> j³é#>‚+™ö‘lU§]^¢) 'Ê”êüÅùéýÊ ñ÷?jÔÛ®¯iÙ®nÇœ­øÅG‚^ ˆû@ j...@ëa#럔 ú̯všÈÛGÉ
> ë†|Ö½ò*θÇßö„â3å2º}ZjþÙ¾M/_ ß½E t_Ä™õiþ °ÖZogV÷ m qŽ¾´¤ ¼:°2zð律¿‰³êÓü)/bC
> 7¶ Ë´ ß.€Ò ÿJ:ÛÕÀ÷J«ZÍá i:9ò•(5 ಔŽ' ƒŠ½¥‡ö¡­x ‡ Ž>©UMT3µ- ×ðSýÐ 5†Ñ5
> «.³6Yf Õ‘ ºØ‚ ê¬ ½Ô±"T‰Kß’û¯+½Å• ßSVÕö[c´Yn ŠÔãñ”…¡F Âšó–” Þ© vq“ÝÀVÝ
> Óp!?"D«„· aj kJ ¼ xà óñ çÆ vC¨e†Öë‹8J ’¢£à :~Ùö˦ê‰Ó ¹H6æ 8–ä6¤ öñ Ýð :ž]ƦM
> Zíñ´%®lxqÛ”ûJ/>†ÀZüõsW3Ê«³ÒF©Öé<…Ñ'ö¢ ƒKi[6•…äÖhik{ £ªóœt÷©\Ï£ è
> nv´¡%...@ÉrŽ«sfg Ùs^C1ÙI[Ž,à$ ¦¢ØÓåm_Pöl¡Ö4m¹à§w I¸:8„Ÿ£Èîô ø‘º Í t¢‚
> û¢t–˜š–*2 ix †r… i)ÏèÔ Ë®0ò ejmÆÔ …¤à¤Ž ħ]«r ë E¾sIz4†Ã

RE: Inserting an Image

2009-10-15 Thread Gavin Towey 
"Image in string form"  sounds like you're not inserting binary data, rather 
some sort of encoded data.  Even if it is binary, you'll have to escape at 
least end quote characters, you can see clearly at the top of your data there 
is :
'ÿØÿà JFIF ÿÛC "" $(4,$&1'


Another thing to think about is storing image data directly in a database is 
often not a good idea. See these links for more info:

http://mysqldump.azundris.com/archives/36-Serving-Images-From-A-Database.html 
and http://hashmysql.org/index.php?title=Storing_files_in_the_database

Regards,
Gavin Towey

-Original Message-
From: Victor Subervi [mailto:victorsube...@gmail.com]
Sent: Thursday, October 15, 2009 12:05 PM
To: mysql@lists.mysql.com
Subject: Inserting an Image

Hi;
I have successfully inserted images, like yesterday, before into MySQL with
the following code:

  sql = 'update productsX set pic1="%s" where ID=2;' % pic1
  cursor.execute(sql)
where pic1 is simply an image uploaded through a form then sent over without
any alteration to another (python) script that uploads it.  Printing it out
looks like this (other variables included):

update productsX set Name=%s, Title=%s, Description=%s, Price=%s,
Bedrooms=%s, Bathrooms=%s, Conditions=%s, Acreage=%s, Construction=%s,
Location=%s, Estate=%s, Address=%s, Furnished=%s, pic1=%s, pic2=%s, pic3=%s,
pic4=%s, pic5=%s, pic6=%s where ID=%s;', ('name1', 'title1', 'descr1',
'1.1', '2', '1', 'New', '1.5', 'New', 'arbor', 'abor', 'abor', 'Furnished',
'ÿØÿà JFIF ÿÛC "" $(4,$&1' -=-157:::#+?D?8C49:7ÿÛC 7%
%77ÿÀ y| " ÿÄ ÿÄM !1A Qa "qs
³ 27Bbc‚ #46Rrt‘¡±² $'3C’%5DTUƒ“¢£ÑñÿÄ ÿÄ ÿÚ ?œ*‹RP’¥¨% d’pªÔcµkä«”øZ Âá îj
Xêxö, `...@$ý <%6...@$ý> ô¨2mÒžÚ ¦ ÚRÑ¥¬ò guD|!%bO :ðç’ Z…æµËÚvsM¡·¢&T ‘œ¬ ºâ
“ñ â1Ò¶¶KT[%¦-² {‘£6 Ô÷“âNI=äÒfÓ ø/RhËîR”³q1 QüÇ“ƒŸ ƒE Š Š( (¢Š Š( (¢Š Š( ×ê
´{ –mÒYü VTâ†pUŽI $à Qvà ɼÜ/ZÒì{IrÝ,´£È x ß #¸$Š·÷F_Ë ë}……áRTdH ó
Á#ÐU“ö*DÙõ¨Yt]ž îêÑ +p}5ùêÿ¹F † vã Êöy5Ô‚\ˆëO Žc 'ö(Óõku-´^4õÊÚ Ú£8Ðð%$ ì84
Ú*ø G¥­·T Vû#µc æ ·uÏ; Ö"ÓusN\\Ü‹5{ÑʸvoòÝû@ é ¼×CP U
¤¡%KPJR2I8T+´½¨®{ß{:)kzD‡; &2~1' ¤“ ïÙßA¶Õº®íª5 Ñú AiMçá ’O ’8 •tÆpHâNÇ
Uºl¤Ûmë¸é«ÝÙ øéí û’7�...@guc q Ó ŠhÙ¶ cFØ Í\çðäLJÎ^8$} ä í=i² Aj ©ôœ «‰J_u
/¥<ƒ‰%*áÓˆÎ;ˆ¦ TÐö©6)WûjØZ`ü dÂsæ–ÝHQB E@ m5Ð QE EbÜî
íP]›q’Üx̧yn8pÿ߇3IP5–¨¿´©úgL2å©K)aéÒû ¼ 5 ã‚s 8žT æÕæ*ýµ)Q’­ä4óp› ¦0 ?ÌU]B
r + ç\»]_"éŸ pTŒŸXU] Èò ­ “¬gK ®tTxò^i‰ É 4‡ Rè ¤ à8 Y«›` üM ]ߊ󌼀ÑK
,¥Iü29 ƃž6™iU‡]Ý£ È/²G 5~xÇ£8öT۱͡§SÀ ›«¿éˆÈॠÆ[ ;ô‡Qן~4»vÒOܬðu ”ëÐÙ Ë
%®a d“Ÿ g ¨Ãe1. õõœÛ æû2 ëËG$4>9' )$xç h3ö‰´Ë®­ ôHî.%œ,†ã ຠx S× ‡Ž3Nû
ÐËAûêº5Œ‚ˆ ¨qÁৠˆ ÓÜh±ìËOÏÚV¢‰ >`ÛTíÅß «.¤¨¥Gžè<€ãŽg½ãP<ìM£h¸1 [ ÌÄ®;J)mA-
ÐR8 :g• ãXjû> ‚™W‡Ô „†Xho8é ÷G‡yÀâ8ñ ‡¤õ5ëQ¥‰Ÿ{žCjxo7"LÑÚ­ à ØG#Ú‡ ‘ž¨ t
–›-LjFžhÈÂXy¥(… \8) ŽJð} -ÜKp¬’ T–PÔu œî €“Œ ” ôTc¢ö…§íZ Ò«õùµMì h‚µ<öwŽ7€É
1Î’šÛ2­7 ó ";= & b*Sê e Æ7xž|p è:@Ö[YÓÚq.1 Ñs¸'€b2 BOÓ_!è > ¡
¦²Özòbm©}÷ƒêÂ`ÂFâ ¤ $ õ Š•vq±è–bÍÏR†æ\ ˆÃÎiƒãùê °tÏ A‡§4Þ Ú<ÆoÚíkfÐ… õ¤
%ÁÑE<Â|Oœ¯ ŒÌM4Û-!¦ ”6€ ”$`$ @ ‚½t¢ƒˆ_Bš}Æ× ä(¥Yç k®vqyM÷DÚf…ï9äéiîþÑ
j³é#>‚+™ö‘lU§]^¢) 'Ê”êüÅùéýÊ ñ÷?jÔÛ®¯iÙ®nÇœ­øÅG‚^ ˆû@ j...@ëa#럔 ú̯všÈÛGÉ
ë†|Ö½ò*θÇßö„â3å2º}ZjþÙ¾M/_ ß½E t_Ä™õiþ °ÖZogV÷ m qŽ¾´¤ ¼:°2zð律¿‰³êÓü)/bC
7¶ Ë´ ß.€Ò ÿJ:ÛÕÀ÷J«ZÍá i:9ò•(5 ಔŽ' ƒŠ½¥‡ö¡­x ‡ Ž>©UMT3µ- ×ðSýÐ 5†Ñ5
«.³6Yf Õ‘ ºØ‚ ê¬ ½Ô±"T‰Kß’û¯+½Å• ßSVÕö[c´Yn ŠÔãñ”…¡F Âšó–” Þ© vq“ÝÀVÝ
Óp!?"D«„· aj kJ ¼ xà óñ çÆ vC¨e†Öë‹8J ’¢£à :~Ùö˦ê‰Ó ¹H6æ 8–ä6¤ öñ Ýð :ž]ƦM
Zíñ´%®lxqÛ”ûJ/>†ÀZüõsW3Ê«³ÒF©Öé<…Ñ'ö¢ ƒKi[6•…äÖhik{ £ªóœt÷©\Ï£ è
nv´¡%...@ÉrŽ«sfg Ùs^C1ÙI[Ž,à$ ¦¢ØÓåm_Pöl¡Ö4m¹à§w I¸:8„Ÿ£Èîô ø‘º Í t¢‚
û¢t–˜š–*2 ix †r… i)ÏèÔ Ë®0ò ejmÆÔ …¤à¤Ž ƒß]«r ë E¾sIz4†Ën¶z¤ÿ Mr¶Ñt ý
r)XSö×T|šVï ôUÜ¡ûù ‘lÚÑ:Æû ]x¡7 Ò¤·1± Ù , C>ÐGJzÛ ÎÍoCêÛ<¾µ l‡å
Çë•üŠ©ûlc;6½z¶ýê( bþ&Ï«O𤽉üœ[}cþùtç b ‡ ÓËÐ)7bß'vÿ[#ß.€ÒÃûQÖ¼? Ç
VªóªømOCäsn~?é ®™9Úž²çýÄ ŸVkΫùTÐÞ® ¹ ÷¶¿“k¯¥Ÿ|Šm›Ÿ‚_#ýÝXéóiOm_&· ù>ù Ëw—
†Có$Â

Re: Inserting an Image

2009-10-15 Thread Jo�o C�ndido de Souza Neto 
The first thing I think I have to sey is "it´s not a good idea to save image 
data in a mysql table field", the best way is to save the file in your file 
system and the file name in the table field, but, if you like to do that, 
it´s better to be a blob field.

"Victor Subervi"  escreveu na mensagem 
news:4dc0cfea0910151204m783904b3uaae1467931a30...@mail.gmail.com...
> Hi;
> I have successfully inserted images, like yesterday, before into MySQL 
> with
> the following code:
>
>  sql = 'update productsX set pic1="%s" where ID=2;' % pic1
>  cursor.execute(sql)
> where pic1 is simply an image uploaded through a form then sent over 
> without
> any alteration to another (python) script that uploads it.  Printing it 
> out
> looks like this (other variables included):
>
> update productsX set Name=%s, Title=%s, Description=%s, Price=%s,
> Bedrooms=%s, Bathrooms=%s, Conditions=%s, Acreage=%s, Construction=%s,
> Location=%s, Estate=%s, Address=%s, Furnished=%s, pic1=%s, pic2=%s, 
> pic3=%s,
> pic4=%s, pic5=%s, pic6=%s where ID=%s;', ('name1', 'title1', 'descr1',
> '1.1', '2', '1', 'New', '1.5', 'New', 'arbor', 'abor', 'abor', 
> 'Furnished',
> 'ÿØÿà JFIF ÿÛC "" $(4,$&1' -=-157:::#+?D?8C49:7ÿÛC 7%
> %77ÿÀ y| " ÿÄ ÿÄM !1A Qa 
> "qs
> ³ 27Bbc, #46Rrt'¡±² $'3C'%5DTUf"¢£ÑñÿÄ ÿÄ ÿÚ ?o* îj
> Xêxö, `...@$ý <%6...@$ý> ô¨2mÒzÚ ¦ ÚRÑ¥¬ò guD|!%bO :ðç' Z.æµËÚvsM¡·¢&T 'o¬ ºâ
> "ñ â1Ò¶¶KT[%¦-² {'£6 Ô÷"âNI=äÒfÓ ø/RhËîR"³q1 QüÇ"fY fE S S( (¢S S( (¢S 
> S( ×ê
> ´{ -mÒYü VTâ?pUZI $à Qvà ɼÜ/ZÒì{IrÝ,´£È x ß #¸$S·÷F_Ë ë}..áRTdH ó
> Á#ÐU"ö*DÙõ¨Yt]z îêÑ +p}5ùêÿ¹F ? vã Êöy5Ô,\^ëO Zc 'ö(Óõku-´^4õÊÚ Ú£8Ðð%$ 
> ì84
> Ú*ø G¥­·T Vû#µc æ ·uÏ; Ö"ÓusN\\Ü<5{ÑʸvoòÝû@ é ¼×CP U
> ¤¡%KPJR2I8T+´½¨®{ß{:)kzD?; &2~1' ¤" ïÙßA¶Õº®íª5 Ñú AiMçá 'O '8 .tÆpHâNÇ
> Uºl¤Ûmë¸é«ÝÙ øéí û'7�...@guc q Ó ShÙ¶ cFØ Í\çðäÇ?Î^8$} ä í=i² Aj ©ôo «?J_u
> /¥ íP]>q'Üx̧yn8pÿß?3IP5-¨¿´©úgL2å©K)aéÒû ¼ 5 ã,s 8zT æÕæ*ýµ)Q'­ä4óp> ¦0 
> ?ÌU]B
> r + ç\»]_"éY pTOYXU] Èò ­ "¬gK ®tTxò^i? É 4? Rè ¤ à8 Y«>` üM ]ßSóO¼?ÑK
> ,¥Iü29 Æfz6TiU?]Ý£ È/²G 5~xÇ£8öT۱͡§SÀ >«¿é^ÈॠÆ[ ;ô?Q×Y~4»vÒOܬðu "ëÐÙ 
> Ë
> %®a d"Y g ¨Ãe1. õõoÛ æû2 ëËG$4>9' )$xç h3ö?´Ë®­ ôHî.%o,?ã ຠx S× ?Z3Nû
> ÐËAûêº5O,^ ¨qÁৠ^ ÓÜh±ìËOÏÚV¢? >`ÛTíÅß «.¤¨¥Gzè ÌÄ®;J)mA-
> ÐR8 :g. ãXjû> ,TW?Ô "?Xho8é ÷G?yÀâ8ñ ?¤õ5ëQ¥?Y{zCjxo7"LÑÚ­ à ØG#Ãs? 'z¨ t
> ->-LjFzhÃ^ÂXy¥(. \8) ZJð} -ÜKp¬' T-PÔu oî ?"O " ôTc¢ö.§íZ Ò«õùµMì 
> h,µ<öwZ7?É
> 1Î'sÛ2­7 ó ";= & b*Sê e Æ7xz|p è:@Ö[YÓÚq.1 Ñs¸'?b2 BOÓ_!è > ¡
> ¦²Özòbm©}÷fêÂ`ÂFâ ¤ $ õ S.vq±è-bÍÏR?æ\ ^ÃÎifãùê °tÏ A?§4Þ Ú<ÆoÚíkfÐ. õ¤
> %ÁÑE<Â|Oo¯ OÌM4Û-!¦ "6? "$`$ @ ,½t¢f^_Bs}Æ× ä(¥Yç k®vqyM÷DÚf.ï9äéiîþÑ
> j³é#>,+Tö'lU§]^¢) 'Ê"êüÅùéýÊ ñ÷?jÔÛ®¯iÙ®nÇo­øÅG,^ ^û@ j...@ëa#ëy" ú̯vsÈÛGÉ
> ë?|Ö½ò*θÇßö"â3å2º}ZjþÙ¾M/_ ß½E t_ÄTõiþ °ÖZogV÷ m qŽ¾´¤ 
> ¼:°2zðï§~¿?³êÓü)/bC
> 7¶ Ë´ ß.?Ò ÿJ:ÛÕÀ÷J«ZÍá i:9ò.(5 à²"Z' fS½¥?ö¡­x ? Z>©UMT3µ- ×ðSýÐ 5?Ñ5
> «.³6Yf Õ' ºØ, ê¬ ½Ô±"T?Kß'û¯+½Å. ßSVÕö[c´Yn SÔãñ".¡F Âsó-" Þ© vq"ÝÀVÝ
> Óp!?"D«"· aj kJ ¼ xà óñ çÆ vC¨e?Öë<8J '¢£à :~Ùö˦ê?Ó ¹H6æ 8-ä6¤ öñ Ýð 
> :z]ƦM
> Zíñ´%®lxqÛ"ûJ/>?ÀZüõsW3Ê«³ÒF©Öé<.Ñ'ö¢ fKi[6..äÖhik{ £ªóot÷©\Ï£ è
> nv´¡%...@Érz«sfg Ùs^C1ÙI[Z,à$ ¦¢ØÓåm_Pöl¡Ö4m¹à§w I¸:8"Y£Èîô ø'º Í t¢,
> û¢tÂ-~s-*2 ix ?r. i)ÏèÔ Ë®0ò ejmÆÔ .¤à¤Z fß]«r ë E¾sIz4?Ën¶z¤ÿ Mr¶Ñt ý
> r)XSö×T|sVï ôUÜ¡ûù 'lÚÑ:Æû ]x¡7 Ò¤·1± Ù , C>ÐGJzÛ ÎÍoCêÛ<¾µ l?å
> Çë.üS©ûlc;6½z¶ýê( bþ&Ï«Oð¤½?üo[}cþùtç b ? ÓËÐ)7bß'vÿ[#ß.?ÒÃûQÖ¼? Ç
> VªóªømOCäsn~?é ®T9Úz²çýÄ YVkΫùTÐÞ® ¹ ÷¶¿"k¯¥Y|Sm>Y,_#ýÝXéóiOm_&· ù>ù Ëw-
> ?Có$µ Á ÇV Jxq4 û 9Ùµ ýRýâézϪ- V÷®fÞ%%¤ü$zÍ´ñqÓ¹É)ê pêE$Z6·÷¹ íÖK4NÖâÓK
> H|a¶?Z^Â~qÁë éåKÚ;J^v"¨dJ'ú».Ð9:jÀáz? TqÀr ^[¨öÏ}òV·íÚr2ÂoJx"þ'ùî f 
> ý¤Î-[L+
> ²=¶ØÂYSÂwP'ûÉ=IT­OÍ!aÓ»IÑOZ-­0ÓÞZ§BSoß)g)'xzG^©1 sñ>rTMÿ'uCÎo|aXôZ [iù5¼qèÏ·ðȦ¹ ê?¿WWòÕÉðb\¢9 á T1oÆû/ )*Á d ²¯) R jH(# 
> $pÇu
> nÇ3ý ÙsYîÜçëWVt F±× ? ^Ñâ>¬Ó ¾ Kd6áÛã5 3@"4ÒwRo'N ¤"í¢-º I dEOÓOJP[î!8SS
> ¨õáA"E P QE H»QÙë Ò ^O[bï $0ò? Ïq~ â BOy§ª(8®óg¸Øç. Ú#±d ñCfY^<^ñ *FûY,
> YªÝ»¸Ùò{sGu];U Ð?˾ eH»vü ¦¯å5] ~@'õ§?,h$S(¢?¢S( (¢?¢©U (ªUh (¢fÿÙ', '', 
> '',
> '', '', '', '')
>
> MySQL complains about the image in string form. I'm sure the

Inserting an Image

2009-10-15 Thread Victor Subervi 
Hi;
I have successfully inserted images, like yesterday, before into MySQL with
the following code:

  sql = 'update productsX set pic1="%s" where ID=2;' % pic1
  cursor.execute(sql)
where pic1 is simply an image uploaded through a form then sent over without
any alteration to another (python) script that uploads it.  Printing it out
looks like this (other variables included):

update productsX set Name=%s, Title=%s, Description=%s, Price=%s,
Bedrooms=%s, Bathrooms=%s, Conditions=%s, Acreage=%s, Construction=%s,
Location=%s, Estate=%s, Address=%s, Furnished=%s, pic1=%s, pic2=%s, pic3=%s,
pic4=%s, pic5=%s, pic6=%s where ID=%s;', ('name1', 'title1', 'descr1',
'1.1', '2', '1', 'New', '1.5', 'New', 'arbor', 'abor', 'abor', 'Furnished',
'ÿØÿà JFIF ÿÛC "" $(4,$&1' -=-157:::#+?D?8C49:7ÿÛC 7%
%77ÿÀ y| " ÿÄ ÿÄM !1A Qa "qs
³ 27Bbc‚ #46Rrt‘¡±² $'3C’%5DTUƒ“¢£ÑñÿÄ ÿÄ ÿÚ ?œ*‹RP’¥¨% d’pªÔcµkä«”øZ Âá îj
Xêxö, `...@$ý <%6...@$ý> ô¨2mÒžÚ ¦ ÚRÑ¥¬ò guD|!%bO :ðç’ Z…æµËÚvsM¡·¢&T ‘œ¬ ºâ
“ñ â1Ò¶¶KT[%¦-² {‘£6 Ô÷“âNI=äÒfÓ ø/RhËîR”³q1 QüÇ“ƒŸ ƒE Š Š( (¢Š Š( (¢Š Š( ×ê
´{ –mÒYü VTâ†pUŽI $à Qvà ɼÜ/ZÒì{IrÝ,´£È x ß #¸$Š·÷F_Ë ë}……áRTdH ó
Á#ÐU“ö*DÙõ¨Yt]ž îêÑ +p}5ùêÿ¹F † vã Êöy5Ô‚\ˆëO Žc 'ö(Óõku-´^4õÊÚ Ú£8Ðð%$ ì84
Ú*ø G¥­·T Vû#µc æ ·uÏ; Ö"ÓusN\\Ü‹5{ÑʸvoòÝû@ é ¼×CP U
¤¡%KPJR2I8T+´½¨®{ß{:)kzD‡; &2~1' ¤“ ïÙßA¶Õº®íª5 Ñú AiMçá ’O ’8 •tÆpHâNÇ
Uºl¤Ûmë¸é«ÝÙ øéí û’7�...@guc q Ó ŠhÙ¶ cFØ Í\çðäLJÎ^8$} ä í=i² Aj ©ôœ «‰J_u
/¥<ƒ‰%*áÓˆÎ;ˆ¦ TÐö©6)WûjØZ`ü dÂsæ–ÝHQB E@ m5Ð QE EbÜî
íP]›q’Üx̧yn8pÿ߇3IP5–¨¿´©úgL2å©K)aéÒû ¼ 5 ã‚s 8žT æÕæ*ýµ)Q’­ä4óp› ¦0 ?ÌU]B
r + ç\»]_"éŸ pTŒŸXU] Èò ­ “¬gK ®tTxò^i‰ É 4‡ Rè ¤ à8 Y«›` üM ]ߊ󌼀ÑK
,¥Iü29 ƃž6™iU‡]Ý£ È/²G 5~xÇ£8öT۱͡§SÀ ›«¿éˆÈॠÆ[ ;ô‡Qן~4»vÒOܬðu ”ëÐÙ Ë
%®a d“Ÿ g ¨Ãe1. õõœÛ æû2 ëËG$4>9' )$xç h3ö‰´Ë®­ ôHî.%œ,†ã ຠx S× ‡Ž3Nû
ÐËAûêº5Œ‚ˆ ¨qÁৠˆ ÓÜh±ìËOÏÚV¢‰ >`ÛTíÅß «.¤¨¥Gžè<€ãŽg½ãP<ìM£h¸1 [ ÌÄ®;J)mA-
ÐR8 :g• ãXjû> ‚™W‡Ô „†Xho8é ÷G‡yÀâ8ñ ‡¤õ5ëQ¥‰Ÿ{žCjxo7"LÑÚ­ à ØG#Ú‡ ‘ž¨ t
–›-LjFžhÈÂXy¥(… \8) ŽJð} -ÜKp¬’ T–PÔu œî €“Œ ” ôTc¢ö…§íZ Ò«õùµMì h‚µ<öwŽ7€É
1Î’šÛ2­7 ó ";= & b*Sê e Æ7xž|p è:@Ö[YÓÚq.1 Ñs¸'€b2 BOÓ_!è > ¡
¦²Özòbm©}÷ƒêÂ`ÂFâ ¤ $ õ Š•vq±è–bÍÏR†æ\ ˆÃÎiƒãùê °tÏ A‡§4Þ Ú<ÆoÚíkfÐ… õ¤
%ÁÑE<Â|Oœ¯ ŒÌM4Û-!¦ ”6€ ”$`$ @ ‚½t¢ƒˆ_Bš}Æ× ä(¥Yç k®vqyM÷DÚf…ï9äéiîþÑ
j³é#>‚+™ö‘lU§]^¢) 'Ê”êüÅùéýÊ ñ÷?jÔÛ®¯iÙ®nÇœ­øÅG‚^ ˆû@ j...@ëa#럔 ú̯všÈÛGÉ
ë†|Ö½ò*θÇßö„â3å2º}ZjþÙ¾M/_ ß½E t_Ä™õiþ °ÖZogV÷ m qŽ¾´¤ ¼:°2zð律¿‰³êÓü)/bC
7¶ Ë´ ß.€Ò ÿJ:ÛÕÀ÷J«ZÍá i:9ò•(5 ಔŽ' ƒŠ½¥‡ö¡­x ‡ Ž>©UMT3µ- ×ðSýÐ 5†Ñ5
«.³6Yf Õ‘ ºØ‚ ê¬ ½Ô±"T‰Kß’û¯+½Å• ßSVÕö[c´Yn ŠÔãñ”…¡F Âšó–” Þ© vq“ÝÀVÝ
Óp!?"D«„· aj kJ ¼ xà óñ çÆ vC¨e†Öë‹8J ’¢£à :~Ùö˦ê‰Ó ¹H6æ 8–ä6¤ öñ Ýð :ž]ƦM
Zíñ´%®lxqÛ”ûJ/>†ÀZüõsW3Ê«³ÒF©Öé<…Ñ'ö¢ ƒKi[6•…äÖhik{ £ªóœt÷©\Ï£ è
nv´¡%...@ÉrŽ«sfg Ùs^C1ÙI[Ž,à$ ¦¢ØÓåm_Pöl¡Ö4m¹à§w I¸:8„Ÿ£Èîô ø‘º Í t¢‚
û¢t–˜š–*2 ix †r… i)ÏèÔ Ë®0ò ejmÆÔ …¤à¤Ž ƒß]«r ë E¾sIz4†Ën¶z¤ÿ Mr¶Ñt ý
r)XSö×T|šVï ôUÜ¡ûù ‘lÚÑ:Æû ]x¡7 Ò¤·1± Ù , C>ÐGJzÛ ÎÍoCêÛ<¾µ l‡å
Çë•üŠ©ûlc;6½z¶ýê( bþ&Ï«O𤽉üœ[}cþùtç b ‡ ÓËÐ)7bß'vÿ[#ß.€ÒÃûQÖ¼? Ç
VªóªømOCäsn~?é ®™9Úž²çýÄ ŸVkΫùTÐÞ® ¹ ÷¶¿“k¯¥Ÿ|Šm›Ÿ‚_#ýÝXéóiOm_&· ù>ù Ëw—
†Có$µ Á ÇV Jxq4 û 9Ùµ ýRýâézϪ- V÷®fÞ%%¤ü$žÍ´ñqÓ¹É)ê pêE$Z6·÷¹ íÖK4NÖâÓK
H|a¶‰ZˆÂ~qÁë éåKÚ;J^v“¨dJ’ú».Ð9:jÀញ TqÀr ^[¨öÏ}òV·íÚr2ÂœJx„þ‘ùî ƒ ý¤Î–[L+
²=¶ØÂYŠÂwP‘ûÉ=I™­ŒÍ!aÓ»IÑŒZ-­0ÓÞZ§BŠœß)g)'xžGˆ©1‹d(÷ 7 c6‰’’„¾ð rÂF Ud[aI
sñ›rTMÿ'uCÎo|aXôŽ [iù5¼qèÏ·ðȦ¹ ꇿWWòÕÉðb\¢9 á ™1œÆû/ )*Á d ²¯) R jH(# $pÇu
nÇ3ý ÙsŸîÜçëWVt F±× ‰ ^Ñâ>¬Ó ¾ Kd6áÛã5 3...@„4Òwrœ’n ¤“í¢-º I dEŒÓOJP[î!8SŠ
¨õáA“E P QE H»QÙë Ò ^Œ[bï $0ò‡ Ïq~ â BOy§ª(8®óg¸Øç. Ú#±d ñCƒŸˆ<ˆñ *FûŸ,
ŸªÝ»¸Ùò{sGu];U Ð?˾ eH»vü ¦¯å5] ~@'õ§?‚h$Š(¢€¢Š( (¢€¢©U (

insertng csv - solved

2009-10-15 Thread Patrice Olivier-Wilson 

A HUGE thank you to Michael and John.

There were a couple of things going on but I do not know why things 
got the way they were can only assume the client files had some issue.


I pulled the file into text wrangler and removed

,  `20` ,  `21` ,  `22` ,  `23`  etc.

Then counted the number of extra commas for the lines, did a find 
replace and removed them. If there hadn't been so many, that trick would 
have been nearly impossible though.


Then, on a hunch, I removed clients column content for how they had 
entered dates: 1/11/09 type of entry. Just blanked it out.

Tried to import and it stopped at line 17 (again). BUT progress!

So, went back to the converter and entered into SQL on phpmyadmn 
interface... viola! success.



Thank you both so much for your help.

--
Patrice Olivier-Wilson
888-385-7217
http://biz-comm.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: MySQL GUI Tools

2009-10-15 Thread Tompkins Neil 
Thanks for all the feedback.  Going to download all of these and see which
best suits our needs.

Neil

On Thu, Oct 15, 2009 at 2:56 AM, Ye Yuan  wrote:

> Hi Neil,
> You can try toad for mysql. It is free.
>
> --
> Thanks,
> YY
>

RE: Inserting csv

2009-10-15 Thread John Daisley 
Those converters aren't all that great . I think its best to stay away from 
them. If a csv is too complex for a 'LOAD DATA INFILE' command then why not use 
an etl tool like talend to load the data?

Its easy to see where your converter has gone wrong but to 'fix' the query I'd 
need the table info. Run 'SHOW CREATE TABLE membership;' in the mysql client 
and post the result here.

If you could post a copy of the csv (if it does not contain anything 
sensitive), then myself or someone else on here could probably write you a 
'LOAD DATA INFILE' command to put the data into your database fairly quickly.

Regards

John Daisley
Mobile +44(0)7812 451238
Email j...@butterflysystems.co.uk

Certified MySQL 5 Database Administrator (CMDBA)
Certified MySQL 5 Developer
Cognos BI Developer

---
Sent from HP IPAQ mobile device.



-Original Message-
From: Patrice Olivier-Wilson 
Sent: 15 October 2009 16:26
To: [MySQL] 
Subject: Inserting csv

Newbie question, please.

I have a csv file of 950 records, 20 fields.

I used this converter
http://csv2sql.evandavey.com/

and copied/pasted insert code into SQL in phpMyAdmin

and got this error


SQL query:

INSERT INTO membership(  `members_ID` ,  `updated` ,  `notes` ,  
`preferred_mail_street` ,  `preferred_mail_csz` ,  `first_name` ,  
`last_name` ,  `street` ,  `city` ,  `state` ,  `zip` ,  `location_code` 
,  `property` ,  `camp_street` ,  `camp_city` ,  `camp_zip` , 
`member_year` ,  `director` ,  `email` ,  `camp_phone` ,  `20` ,  `21` 
,  `22` ,  `23` )
VALUES (

'',  '',  '',  '',  '',  'xxx',  '',  '102 Summer St',  
'Dover-Foxcroft',  'xx',  '04426',  'B',  'M15_L1_S20',  'Mill Brook',  
'Bowerbank',  '',  '',  '',  '',  '',  '',  '',  '',  ''
);

MySQL said:

#1054 - Unknown column '20' in 'field list'

Actually the first time, it was column 21, so to trouble shoot, I removed that 
column from csv file and field name in phpMyAdmin.


camp_phone should be the last field but 

 `20` ,  `21` ,  `22` ,  `23` ) 

is there too... 

Any assistance most appreciated!

I checked the file and didn't see any odd entries after the camp_phone field.





-- 
Patrice Olivier-Wilson
888-385-7217
http://biz-comm.com


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=john.dais...@butterflysystems.co.uk



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Inserting csv

2009-10-15 Thread Michael Dykman 
If you could show us the table structure (SHOW CREATE TABLE
membership), we could easily correctly the query..   you seems to have
some data among your field names...

If the question is about the CSV converter, you will have to ask them.

 - michael dykman

On Thu, Oct 15, 2009 at 11:26 AM, Patrice Olivier-Wilson
 wrote:
> Newbie question, please.
>
> I have a csv file of 950 records, 20 fields.
>
> I used this converter
> http://csv2sql.evandavey.com/
>
> and copied/pasted insert code into SQL in phpMyAdmin
>
> and got this error
>
>
> SQL query:
>
> INSERT INTO membership(  `members_ID` ,  `updated` ,  `notes` ,
>  `preferred_mail_street` ,  `preferred_mail_csz` ,  `first_name` ,
>  `last_name` ,  `street` ,  `city` ,  `state` ,  `zip` ,  `location_code` ,
>  `property` ,  `camp_street` ,  `camp_city` ,  `camp_zip` , `member_year` ,
>  `director` ,  `email` ,  `camp_phone` ,  `20` ,  `21` ,  `22` ,  `23` )
> VALUES (
>
> '',  '',  '',  '',  '',  'xxx',  '',  '102 Summer St',
>  'Dover-Foxcroft',  'xx',  '04426',  'B',  'M15_L1_S20',  'Mill Brook',
>  'Bowerbank',  '',  '',  '',  '',  '',  '',  '',  '',  ''
> );
>
> MySQL said:
>
> #1054 - Unknown column '20' in 'field list'
>
> Actually the first time, it was column 21, so to trouble shoot, I removed
> that column from csv file and field name in phpMyAdmin.
>
>
> camp_phone should be the last field but
> `20` ,  `21` ,  `22` ,  `23` )
> is there too...
> Any assistance most appreciated!
>
> I checked the file and didn't see any odd entries after the camp_phone
> field.
>
>
>
>
>
> --
> Patrice Olivier-Wilson
> 888-385-7217
> http://biz-comm.com
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=mdyk...@gmail.com
>
>



-- 
 - michael dykman
 - mdyk...@gmail.com

Don’t worry about people stealing your ideas. If they’re any good,
you’ll have to ram them down their throats!

   Howard Aiken

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Inserting csv

2009-10-15 Thread Patrice Olivier-Wilson 

Newbie question, please.

I have a csv file of 950 records, 20 fields.

I used this converter
http://csv2sql.evandavey.com/

and copied/pasted insert code into SQL in phpMyAdmin

and got this error


SQL query:

INSERT INTO membership(  `members_ID` ,  `updated` ,  `notes` ,  
`preferred_mail_street` ,  `preferred_mail_csz` ,  `first_name` ,  
`last_name` ,  `street` ,  `city` ,  `state` ,  `zip` ,  `location_code` 
,  `property` ,  `camp_street` ,  `camp_city` ,  `camp_zip` , 
`member_year` ,  `director` ,  `email` ,  `camp_phone` ,  `20` ,  `21` 
,  `22` ,  `23` )

VALUES (

'',  '',  '',  '',  '',  'xxx',  '',  '102 Summer St',  
'Dover-Foxcroft',  'xx',  '04426',  'B',  'M15_L1_S20',  'Mill Brook',  
'Bowerbank',  '',  '',  '',  '',  '',  '',  '',  '',  ''

);

MySQL said:

#1054 - Unknown column '20' in 'field list'

Actually the first time, it was column 21, so to trouble shoot, I removed that 
column from csv file and field name in phpMyAdmin.


camp_phone should be the last field but 

`20` ,  `21` ,  `22` ,  `23` ) 

is there too... 


Any assistance most appreciated!

I checked the file and didn't see any odd entries after the camp_phone field.





--
Patrice Olivier-Wilson
888-385-7217
http://biz-comm.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: is_string or is_numeric

2009-10-15 Thread walter harms 
Do your realy need to know the differenz ? take everything as "string".
(breaks with pics/geodata but helps a lot).

re,
 wh

sangprabv schrieb:
> Hi,
> I found no built in function in mysql to check whether a record is
> numeric or string. Is there any trick to do so? Many thanks.
> 
> 
> 
> 
> Willy
> 
> 

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: is_string or is_numeric

2009-10-15 Thread Claudio Nanni 
Only in the case you want to know the datatype and not the actual type of
information in a char field!

If you issue:

show fields from MyTable like 'FName';

you get:
+---+--+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
+---+--+--+-+-+---+
| FName | varchar(255) | YES  | | NULL|   |
+---+--+--+-+-+---+

although is not a function if you place the result into an array on the
application side you can pull the value of the Type attribute.


Hope this helps anyway!


Claudio


2009/10/15 Glyn Astill 

> > From: sangprabv 
> > Subject: is_string or is_numeric
> > To: mysql@lists.mysql.com
> > Date: Thursday, 15 October, 2009, 10:34 AM
> > Hi,
> > I found no built in function in mysql to check whether a
> > record is
> > numeric or string. Is there any trick to do so? Many
> > thanks.
>
> You could use some regex to do it...
>
> In fact, a google brings up this (
> http://forums.mysql.com/read.php?60,1907,241284#msg-241284)
>
> CREATE FUNCTION ISNUMERIC(myVal VARCHAR(1024))
> RETURNS TINYINT(1) DETERMINISTIC
> RETURN myVal REGEXP '^(-|\\+)?([0-9]+\\.[0-9]*|[0-9]*\\.[0-9]+|[0-9]+)$';
>
>
> Glyn
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=claudio.na...@gmail.com
>
>


-- 
Claudio

Re: is_string or is_numeric

2009-10-15 Thread Glyn Astill 
> From: sangprabv 
> Subject: is_string or is_numeric
> To: mysql@lists.mysql.com
> Date: Thursday, 15 October, 2009, 10:34 AM
> Hi,
> I found no built in function in mysql to check whether a
> record is
> numeric or string. Is there any trick to do so? Many
> thanks.

You could use some regex to do it...

In fact, a google brings up this 
(http://forums.mysql.com/read.php?60,1907,241284#msg-241284)

CREATE FUNCTION ISNUMERIC(myVal VARCHAR(1024))
RETURNS TINYINT(1) DETERMINISTIC
RETURN myVal REGEXP '^(-|\\+)?([0-9]+\\.[0-9]*|[0-9]*\\.[0-9]+|[0-9]+)$';


Glyn




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

is_string or is_numeric

2009-10-15 Thread sangprabv 
Hi,
I found no built in function in mysql to check whether a record is
numeric or string. Is there any trick to do so? Many thanks.




Willy


-- 
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 GUI Tools

2009-10-15 Thread SQL Maestro Team 
> What are the best MySQL GUI tools available at the moment, for example
> SQLyog.

You could start with our AnySQL Maestro (free version available).
http://www.sqlmaestro.com/products/anysql/maestro/

Sincerely yours,
SQL Maestro Group Team
http://www.sqlmaestro.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: MySQL Cluster / NDB & MyISAM mix

2009-10-15 Thread Christian Meisinger 
Thanks.

Yes it's a delicate construct but tables like 'IP2Location' give me a
headache as NDB tables.
Yet I have to test if 7.0.X can handle it.


-Original Message-
From: Michael Dykman [mailto:mdyk...@gmail.com] 
Sent: Mittwoch, 14. Oktober 2009 17:33
To: Christian Meisinger
Cc: mysql@lists.mysql.com
Subject: Re: MySQL Cluster / NDB & MyISAM mix

I can think of no reason why this shouldn't work,  My administrator
colleagues would probably beat me with 2x4's for handing them such a
delicate construct to maintain in production but it seems perfectly
feasible to me :-)

 - michael dykman

On Wed, Oct 14, 2009 at 11:03 AM, Christian Meisinger
 wrote:
> Hi guys.
>
> Ok lets say i've 2 server running MySQL, NDB node and NDB manager on each.
> Now I don't want to convert all tables to NDB instead I leave a few as
> MyISAM.
> Is it officially supported if I setup a master-master replication between
> the two MySQL instances and add ignore entries for all NDB tables?
>
> So basically I would convert all important tables to NDB and leave other
> tables as MyISAM, but they would still be 'synced' via replication.
>
> I've tested it and it look like it works... but... does it work by
> coincidence? :)
>
>
> Thanks, chris
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=mdyk...@gmail.com
>
>



-- 
 - michael dykman
 - mdyk...@gmail.com

Don’t worry about people stealing your ideas. If they’re any good,
you’ll have to ram them down their throats!

   Howard Aiken


--
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 GUI Tools

2009-10-15 Thread Martijn Tonies 




What are the best MySQL GUI tools available at the moment, for example
SQLyog.


Have you tried Database Workbench (Pro) yet? See www.upscene.com


With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org