Fwd: Re: Help Save MySQL

to the media like TechCrunch.com, BusinessWeek, ZD.Net, etc. Without society's engagement we won't acomplish anything! Regards, Bruno B. B. Magalhães Sócio-Diretor de Negócios e Tecnologia BLACKBEAN CONSULTORIA Rua Real Grandeza 193/210, Botafogo Rio de Janeiro, RJ, 22281-035, Brasil +55 (21) 9996

Re: Fwd: Re: Help Save MySQL

suggest using Monty (if he aggrees) letter as base and start spreeding the word. Bruno B. B. Magalhães Sócio-Diretor de Negócios e Tecnologia BLACKBEAN CONSULTORIA Rua Real Grandeza 193/210, Botafogo Rio de Janeiro, RJ, 22281-035, Brasil +55 (21) 9996-1093 +55 (21) 2266-0597

Re: Help Save MySQL

... Course, there are many others management problems and legal issues to solve, but if anybody would join me I would be the first one! And also would be a REMARKABLE adventure and maybe the next step for the open source initiatives around the world... Best Regards Bruno B. B. Magalhães BLACKBEAN

Re: Help Save MySQL

Maybe a three-years consul composed from and elected by the community (by community I mean the people that contributed with funds, not the user community) by voting? Regards, Bruno B. B. Magalhães BLACKBEAN CONSULTORIA Rua Real Grandeza 193, Sala 210, Botafogo Rio de Janeiro, RJ, 22281-035

Re: Help saving MySQL

://www.yachtingmagazine.com/article.jsp?ID=170610 Best Regards, Bruno B. B. Magalhães BLACKBEAN CONSULTORIA Rua Real Grandeza 193, Sala 210, Botafogo Rio de Janeiro, RJ, 22281-035, Brasil +55 (21) 9695-2263 +55 (21) 2266-0597 www.blackbean.com.br Esta mensagem pode conter informação confidencial e/ou

Re: Database Import from Oracle

Hi guys, the easiest is to use MySQL Migration Toolkit, I've sucessfuly used it with SQL Server (2000 and 2008) and Oracle 9i, all with simple structures and simple data, but worked VERY well... Regards, Bruno B. B. Magalhães Sócio-Diretor de Negócios e Tecnologia BLACKBEAN CONSULTORIA

SssS Generic modeling...

? Best Regards, Bruno B. B. Magalhães Sócio-Diretor de Negócios e Tecnologia BLACKBEAN CONSULTORIA Rua Real Grandeza 193/210, Botafogo Rio de Janeiro, RJ, 22281-035, Brasil +55 (21) 9996-1093 +55 (21) 2266-0597 www.blackbean.com.br Esta mensagem pode conter informação confidencial e/ou

Practical hierarchies

to you all, Bruno B. B. Magalhães BLACKBEAN CONSULTORIA Rua Real Grandeza 193/210, Botafogo Rio de Janeiro, RJ, 22281-035, Brasil +55 (21) 9996-1093 +55 (21) 2266-0597 www.blackbean.com.br Esta mensagem pode conter informação confidencial e/ou privilegiada. Se você não for o destinatário ou

Re: Practical hierarchies

? For example: SELECT RECURSIVE * FROM ProductsCategories USING ProductCategoryParentID = ProductCategoryID Is this syntax factive? Best regards, Bruno B. B. Magalhães BLACKBEAN CONSULTORIA Rua Real Grandeza 193/210, Botafogo Rio de Janeiro, RJ, 22281-035, Brasil +55 (21) 9996-1093 +55 (21) 2266

Performance

about 8 to 12 seconds to be generated for one month (course that I have to sum previous months totals to give the balance). Thanks in advance... Regards, Bruno B B Magalh'aes -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Performance

that the transactions table is the sort of the problem, as it's using file sort and where... But my myisam sort cache is big, I thing it's about 80MB or so... Thank you everybody for your help!!! Best Regards, Bruno B B Magalhaes On Apr 22, 2008, at 3:21 PM, Perrin Harkins wrote: On Tue, Apr 22, 2008

How to replicate a timestamp field

Bruno Silva __ Fale com seus amigos de graça com o novo Yahoo! Messenger http://br.messenger.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Int(4) or int(8)

affects ONLY the maximum number of digits MySQL uses to DISPLAY column values. I understand that theses values are unrelated to the range of datatype values, however i did not saw any diference when i use int(4) or int(8) Some idea? Regards Bruno

Re: making graphs with MySQL data

. And before anyone start pointing the fingers, I don´t have any affiliation with InfoSoft Global in any shape or form, besides been a happy client. :o) Best Regards, Bruno B B Magalhães On Jan 16, 2007, at 11:43 AM, C.R.Vegelin wrote: Thanks El Cuy, Joshua, Ryan, Let me be more specific

Re: making graphs with MySQL data

plugin installed, nothing more nothing less. And just to remember, flash is now present on 99.6% of the world´s computers. Take a look at their site, and specially on demo section. Best Regards, Bruno B B Magalhães On Jan 16, 2007, at 2:08 PM, C.R.Vegelin wrote: Hi Bruno, Thanks a lot !! I feel

Decimal versus Float Point Type

Dear all. The MySQL Manual inform that Decimal Data Type is used for represent exact-number, but like Float Point Data Type, Decimal use rounding case the fractional part is not sufficient. Therefore, what the difference? Regards Bruno R. Silva

CRM: Labels instead of specific atributes

in exchanging thoughts? Best Regards to you all, Bruno B B Magalhães -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Best practices

stats this way is not practical in terms of portability and that's not definitely a good practice. Or this kind of data is necessarily stored separated? Thanks in advance for any kind of advice in this matter. Regards, Bruno B B Magalhaes -- MySQL General Mailing List For list archives: http

Accountability with MySQL

system? Best regards, Bruno B B Magalhães -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Accountability with MySQL

days, months and year, or beetween dates.. And everything will be shown in a simple list, with some graphics like bills to pay in the next week, income to recieve in next week, and simple stats of that kind.. To split in two tables (income and outcome) seams a good idea... Best Regards, Bruno B B

Re: Accountability with MySQL

currency like Japanese yen, which have no fractional part? Yes we have decimal, but, we use the dot for thousand, and the comma for decimal values... Is it possible to make MySQL accept this? :) Thanks for everything, Bruno B B Magalhães -- MySQL General Mailing List For list archives: http

Country codes

Hi guys, I know it's a little bit off-topic, but does some one have a list with all countries of the world and their respective ISO codes (Like BRA, US, UK, etc.) and also their international calling codes (Like +55, +1, +32)? Thanks a lot, Bruno B B Magalhaes -- MySQL General Mailing

BIIIIIIIIIIG query

(emails.email_address) AGAINST ('KEYWORD' IN BOOLEAN MODE) GROUP BY contacts.contact_id ORDER BY contacts.contact_name ASC Many thanks in advance! Best Regards, Bruno B B Magalhaes -- MySQL

Re: BIIIIIIIIIIG query

regards to you all, Bruno B B Magalhaes On Nov 19, 2005, at 2:12 PM, Rhino wrote: I don't have time today to answer your question in detail but the basic technique you need to use is an _OUTER_ join. Those should be completely compatible for version 4 and above of MySQL. A regular join, which

Re: BIIIIIIIIIIG query

Another test. I tried just to join the contacts table with the contacts_to_addresses table, well worked just perfect. But I am not able to figure it out how to join the addresses table on same join! Regards, Bruno B B Magalhaes On Nov 19, 2005, at 5:30 PM, Rhino wrote: Paul, Do you

Re: BIIIIIIIIIIG query (I GOT IT, well I think so!)

== Course this is the final version outputted from PHP module before it's send to the database. Best Regards, Bruno B B Magalhaes On Nov 19, 2005, at 6:17 PM, bruno b b magalhães wrote: Another test. I tried just to join the contacts table with the contacts_to_addresses

Re: DBDesigner4 under Linux

I have a symbolic link to libmysqlclient.so.10.0.0 When I run startdbd for the first time symbolic links are created. Thanks, Bruno -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: DBDesigner4 under Linux

.10.0.0 for example at /usr/lib/ try to add new symbolic link ln -s /usr/lib/libmysqlclient.so.10.0.0 /usr/lib/libmysqlclient.so and run /sbin/ldconfig good luck Bruno Cochofel wrote: I have a symbolic link to libmysqlclient.so.10.0.0 When I run startdbd for the first time symbolic

DBDesigner4 under Linux

on this? Or perhaps if someone point me out in the direction off ODBC connect to MySQL? I've never did this so don't know where to start... Thanks, Bruno -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL sw for reverse engineering

... Thanks, Bruno -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL sw for reverse engineering

('newpwd'); Edward Vermillion wrote: Bruno Cochofel wrote: Thank you all for the posts. Can anyone explain to me how can I connect DBDesigner4 to MySQL 4.x? I've never used MySQL 3.x and I believe there's some kind off trick to connect DBDesigner4 to MySQL 4.x because the program doesn't support

MySQL sw for reverse engineering

Does anyone know a sw that can reverse engineering a mysql table? I want to be able to draw a entity-relationship model from an already made MySQL table. Thanks, Bruno

invalid zip file...

I tried to download mysqlgui-win32-static-1.7.5-2.zip, but it doesn't appear to be a valid archive... What should I do?? Thanks, Bruno

#1205 - Lock wait timeout exceeded; Try restarting transaction

I am using tables INNODB. After one query, the MySQL does not liberate the LOCK, and when I try to execute same query it appears the message. #1205 - Lock wait timeout exceeded; Try restarting transaction whait urgently one helps. thanks, Bruno -- MySQL General Mailing List For list

Why mysql LOCK any lines and does not allow that I delete?

I am with a problem in one query of simple DELETE. #1205 - Lock wait timeout exceeded; Try restarting transaction Why mysql LOCK this line and does not allow that I delete, if I did not emit none stantment of LOCK? Please, help me! Bruno Rodrigues Silva Brazil. -- MySQL General Mailing List

User Variables

Hi Guys, Do you know what version user variables were introduced? I can't seem to get them working in 3.22 and yet they work in 3.23. Best regards, Bruno Mustone

RE: User Variables

Hmmm they seem to work in version 3.23.57. -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: 17 November 2003 18:38 To: Bruno Mustone; [EMAIL PROTECTED] Subject: Re: User Variables At 12:05 PM + 11/17/03, Bruno Mustone wrote: Hi Guys, Do you know what version

access denied

NEWBIE I have make a mistake using mysqlcc; now, user (mysql,root,bruno) can't acces to databases. I use both mysqlcc phpMyAdmin but the answer is access denied [EMAIL PROTECTED] (Using password:Yes) access denied [EMAIL PROTECTED] (Using password:Yes) Please an help Thanks in advance bruno

Nested query issue in MySQL 4.1

functioning. I indexed almost every column but it did not help. These kind of queries allways worked, I don't know what could have happened. Every sugestion is highly appreciated. Thank you Bruno -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Inserting strings containing only spaces fails?

Hi All, I had the same problem on MySql server 3.23.43 on Solaris platform but, so far, I don't know how to solve it. Can you help me? Thanks in advance. Regards. Stefano Bruno Grenci -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Stefano Bruno Grenci ([EMAIL PROTECTED]) Ion Trading System

Dumping mysql databases that have BLOB column

problems with escape characters and so on. Thank you all in advance Bruno - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

select a range

Hi I'm newbie I have to find from xvalue to yvalue; I have written: $query=SELECT * FROM inner-multipli WHERE cod_int LIKE ='%$cod_int1%' AND cod_int LIKE ='%$cod_int2'=; This not work; how can I do? Thanks in advance bruper

Re: Re: select a range MySQL

meaning of comparative ordering, doesn't it? Dear Paul you are right; well, my problem in MySQL is -selecting a code (var 9) range from 10? to 20? with variables in html form- Thanks bruno

MySQL BLOB fields and large binary data

. It is, I'd say stupid, that these kind of things can not be done with such robust database system. I like MySQL very much, but my whole project depends on this situation and I'll seriously think about using some other RDBMS if I can't solve this problem. Thank you all in advance Bruno Croatia

unixOBDC

can you give me an answer? Thank in advance bruno - 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

table

Hi Please, how can I do to make a table from a file.txt or to copy postgresql's dumpfile? Thank in advance bruper - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

mysql.sock

Hi how can I do to restore mysql.sock? Thank in advance - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread,

Memory allocation error in MySQL

object for inserting binary data. Server is 1100 mhz celeron with 256 mb of RAM. That should be enough for database of 60-70 mbytes. Please help me. Thank you in advance Bruno - Before posting, please check: http://www.mysql.com

UNICODE in MySQL

? Thank you all in advance Bruno - 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

MySQL subquery that works

to perform subqueries on MySQL via MyODBC driver since it is obvious that they work? What can I do, but I do not want to use access database as a layer between my application and mysql server? I use Visual Basic for accessing mysql server. Thank You very much Bruno

MySQL and UPDATE query

mysql client, every Field_name's value bocomes 0 (zero). What did I do wrong? Thank you all Bruno Batarelo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

MySQL BLOB Visual Basic

= innodb_buffer_pool_size=30M set-variable = innodb_additional_mem_pool_size=15M Everything should work just fine but I do not know what's wrong. Does anyone have an idea? If this is not solvable, how can I expect mysql to receive large amounts of data? Thank You for your patience Bruno

BLOB and ADO

operation generated errors. Check each status value. I do not know what to do. I use MySQL 4.01 and MyODBC 3.51.03. It occures only with this field data type. I would appreciate any help since I'm in big trouble if I do not solve this. Thank You all. Bruno

Delete

Greetings In the comments section (delete speed) somebody wrote that that it is much faster to delete results of previously executed select query. How can I do that when delete from..where in(select query); is not possible? Regards Bruno

BLOB field and ADO

or 3.51) it results with a new record, but the value in the BLOB field is always Null. Notice that it only happens with BLOB fields in combination with ODBC. Thank You Bruno - Before posting, please check: http://www.mysql.com

Backslash BUG?

('\'); ' ' ' ' That means that query ok message is skipped. The same problem occur if I try the same operation with blob data type. Please report me about this. Bruno - Before posting, please check: http://www.mysql.com/manual.php (the manual

current development

want to use MS SQL Server or Oracle... Regards Bruno - 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

current development

want to use MS SQL Server or Oracle... Regards Bruno - 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

AW: current development

to be interesting though. Regards Bruno - 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

Fw: Stalled MySQL process causing high CPU load

of 3 or to version 4? Or should I scrap MySQL and try PostgreSQL? - Original Message - From: Bruno Prior [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, November 21, 2001 10:05 PM Subject: Stalled MySQL process causing high CPU load I am a MySQL novice, so there may be a simple

Stalled MySQL process causing high CPU load

. I hope I have provided sufficient information. Does anyone have any idea what might be causing this? Cheers, Bruno Prior [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual

Query Error

Hi ! I´m trying to query some news with multiple rows in my database. I´m receiving an error when i use: SELECT table1.*, table2.table2_row FROM table1,table2 ORDER BY table1_row but, if I try: SELECT table1.table1_row, table2.table2_row FROM table1,table2 ORDER BY table1_row or SELECT

Date interval problem

Hello, i have a table with two dates, that define an interval. In the query i have two more dates, and i want to select all the records that overlap that period. Any hint to solve this problem? Thanks, Bruno - Before posting

Mailing labels

Hi! Does anyone know the correct tag sequence to produce Mailing labels with the 1.7.5.1 version of mysql, I try every wich way to produced them, but I had to resort to export the data to excell or word in order to produce them. Bruno

[MySQL] Database size

--- Reçu de CMB.TIGNABR 0298426574 03-08-01 17.21 Hello, I plan to use MySQL/InnoDB to store about 13 GB of data, into 40 tables. One of the tables is over 5 GB, and a second over 1,5 GB. Do you think I can use MySQL/InnoDB ? Thank you. Bruno Tignac 03-08-01

Re: Important bug in RAID tables

it at www.aspseek.org, and the problem occurred indexing http://lanazione.monrif.net (almost 3 millions documents, so there were almost 3 millions records in the table 'urlword') - Patrizio Bruno DADA spa / Special Projects Viale Giovine Italia

Re: Important bug in RAID tables

it at www.aspseek.org, and the problem occurred indexing http://lanazione.monrif.net (almost 3 millions documents, so there were almost 3 millions records in the table 'urlword') - Patrizio Bruno DADA spa / Special Projects Viale Giovine Italia

crash

not a RedHat to try on that, the problem doesn't exist on Sun Solaris. If you can reproduce the problem on Slackware gdb is enough to find the crash point. Thanks in advance (you did a great work). Greetings P. - Patrizio Bruno DADA spa

Odbc on NT

the version of ODBC behavior that the application requested (see SQLSetEnvAttr). im using the myodbc 2.50.37 with mysql 3.23.38. If somebody can help me i would apreciate. Thanx Bruno Santos - Before posting, please check: http

What can I do ?

with 2 databases, put 10.000 in the one that I have 90% of acces, and put the rest of rows in the orther. Is this a good idea with MySql ? Or there is a better way to do this ? Thank You ! Bruno Fae. _ Do You Yahoo!? Get your free @yahoo.com

BEGIN, COMMIT, ROLLBACK

Hi. How to use Begin, Commit and Rollback in my tables type MyISAM ? mysql BEGIN; Query OK, 0 rows affected (0.00 sec) mysql UPDATE tabgral set codigo=2 where codigo=1 and nrotab=99; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql ROLLBACK; ERROR 1196: