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

Fwd: Re: Help Save MySQL

ing 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, B

Re: Help saving MySQL

: Until the last consequences. More info at: http://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

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 Save MySQL

ative... 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 BLAC

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 CONSUL

SssS Generic modeling...

:00:00','0','-00-00 00:00:00','1','-00-00 00:00:00'); What would be followed by (a trigger perheaps or the application it self) the queries: ALTER TABLE `TB1` ADD `CL11` INTEGER(20) NOT NULL DEFAULT NULL AUTO_INCREMENT

Re: Practical hierarchies

e or recursive query? 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 (2

Practical hierarchies

logsCategoriesIndexD` (` CatalogCategoryCreatedOn `,`CatalogCategoryModifiedOn`,`CatalogCategoryRemovedOn`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 Pros: SQL friendly so much less processing and queries required, very export / inport friendly Cons: Fixed deep and a little bit more difficult

Re: Performance

nt_id,bap_sat.transactions.client_unit_id 1 Seems 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 Magalhae

Performance

mn to maintain the index small? Most of the financials reports today takes 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 Mai

How to replicate a timestamp field

. Regards 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)

olumn 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? Rega

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

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

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

hold statistical data. Anything that I´ve just said make any sense? :) Is anybody who is a large scale CRM developer interested 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

phone_areacodes; 11, 55; 1 2005-12-04; phone_areacodes; 21, 55; 62 How can I do this on the fly without using any generic table to store stats? I suspect that storing stats this way is not practical in terms of portability and that's not definitely a good practice. Or this kind of data is

Re: Accountability with MySQL

n is an integer. Does the Brazilian currency not have a fractional component? Here in Canada, monetary > amounts are always decimal numbers, like $123.45, meaning one hundred and twenty three dollars and forty five cents. Or is your 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://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

Accountability with MySQL

that, any other idea that could improve my little 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]

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 Ma

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

.contact_id ORDER BY contacts.contact_name ASC == 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 j

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

figure it out! Best 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.

BIIIIIIIIIIG query

MATCH (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 Maga

Re: DBDesigner4 under Linux

ysqlclient.so.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.

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]

DBDesigner4 under Linux

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

7;some_host' = OLD_PASSWORD('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 so

Re: MySQL sw for reverse engineering

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

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

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 wha

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

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 adva

Nested query issue in MySQL 4.1

rks fine all the time, but when I join them together, everything stops 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 L

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 S

Dumping mysql databases that have BLOB column

aving 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

Re: Re: select a range MySQL

;match-anything" wildcard at the beginning. > > That completely negates any possible meaning of comparative ordering, > > doesn't it? > Dear Paul you are right; well, my problem in MySQL is -selecting a code (var 9) r

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

MySQL BLOB fields and large binary data

s problem. 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.

root is missing after RPM installation

reated by the installation. 'test' works fine, ie mysql -u test. How to obtain / create the user 'root' ? Which user to use to be able to query users table ? Cheers, Bruno - Before posting, please check:

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 <[EM

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, e-mail

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

er 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

MySQL and UPDATE query

well, but when using VB and MyODBC or just 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.p

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

MySQL BLOB field - reliable or NOT?

that BLOB fields are not so attractive to work with. Are they reliable enough for work because whenever I try to work with this data type, I always have difficulties in combination with ADO, and seemingly, ADO has not got problems in work. If You can help me, I'd appreciate it.

BLOB and ADO

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

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

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?

> insert into ttable (Field1) values ('\'); '> '> '> '> 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

AW: current development

that innoDB stuff seems 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 thre

current development

n't really 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,

current development

n't really 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,

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

Stalled MySQL process causing high CPU load

ocess. 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 m

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 ta

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

load 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

Re: Important bug in RAID tables

load 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

Important bug in RAID tables

l configuration file is my-huge.cnf taken from the mysql's source-distribution. P. PS I didn't subscribe the mailing list, can you reply to [EMAIL PROTECTED] please? Thanks - Patrizio Bruno DADA spa / Special Projects Viale

crash

90, I have 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

Odbc on NT

rror = 0, *pcbErrorMsg = 140 MessageText = "[Microsoft][ODBC Driver Manager] The driver doesn't support 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 apreci

What can I do ?

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

Help! MyODBC x Crystal Reports

Hi! My name is Bruno and I'm speaking from Brazil. I'm having ome problems with MyODBC and Crystal Reports. I have a Mysql data base and can access this data base using PHP and Microsoft Access (using myodbc for MS access). But when i wanna access myodbc with crystal reports, the Crys