Re: Fwd: Re: Help Save MySQL

2009-12-18 Thread Bruno B. B. Magalhães
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

2009-12-18 Thread Bruno B. B. Magalhães
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

2009-12-17 Thread Bruno B. B. Magalhaes
: 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

2009-12-17 Thread Bruno B. B. Magalhaes
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

2009-12-17 Thread Bruno B. B. Magalhaes
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

2009-03-24 Thread Bruno B . B . Magalhaes
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...

2008-10-25 Thread Bruno B. B. Magalhães
: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

2008-04-29 Thread Bruno B B Magalhães
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

2008-04-29 Thread Bruno B B Magalhães
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

2008-04-22 Thread Bruno B. B. Magalhães
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

2008-04-22 Thread Bruno B . B . Magalhães
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

Re: making graphs with MySQL data

2007-01-16 Thread Bruno B B Magalhães
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

2007-01-16 Thread Bruno B B Magalhães
. 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

CRM: Labels instead of specific atributes

2006-06-10 Thread Bruno B B Magalhães
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

2006-04-11 Thread Bruno B B Magalhães
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

2006-03-14 Thread Bruno B B Magalháes
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

2006-03-14 Thread Bruno B B Magalháes
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

2006-03-14 Thread Bruno B B Magalháes
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

2005-11-20 Thread bruno b b magalhães
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!)

2005-11-19 Thread bruno b b magalhães
.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

2005-11-19 Thread bruno b b magalhães
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

2005-11-19 Thread bruno b b magalhães
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

2005-11-19 Thread bruno b b magalhães
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

Foreign Keys

2003-08-11 Thread b b
I am using MYSQL 4. I understand that it allows for foreign keys. Could someone show me an example of how to declare a foriegn key. I tried a combination of statements but I always got a syntax error. Here is what I am trying for example ... Create table x ( ID INT NOT NULL AUTO_INCREMENT

Foreign Keys

2003-08-11 Thread b b
I am using MYSQL 4. I understand that it allows for foreign keys. Could someone show me an example of how to declare a foriegn key. I tried a combination of statements but I always got a syntax error. Here is what I am trying for example ... Create table x ( ID INT NOT NULL AUTO_INCREMENT

stored procedures

2003-07-30 Thread b b
Is there an equivalent to transact-sql or pl-sql with mysql. I realize that one could right functions in C and compile it in with the server. However, no hosting company will allow its clients to do this. So is there a way to create function the way one creates a table without having to have acce

Re: Transactions

2003-07-30 Thread b b
; A robust file handler or dbdbmss a wonderful tool > but it is only a tool and > does not relieve a programmer of their > responsibility. That's my point. > > Pat... > > BTW MyMySQLs one of the best SQSQLervers out there, > and our SQSQLerver of > choice. > >

Grant and Revoke

2003-07-29 Thread b b
Just installed the mysql binary. It runs fine. However the only way i can administrate it is if I use the root account which is fine. But when I try to Grant other users any privilages the following happens: My Query: Grant ALL on dbName.* to userName Response: Query Ok, 0 rows affected.

Re: Transactions

2003-07-29 Thread b b
es. I will give that a shot. Thanks for the comment. --- Dan Nelson <[EMAIL PROTECTED]> wrote: > In the last episode (Jul 29), b b said: > > Most web hosting companies run the mysql standard. > Which means one > > can't run transactions. If that is the case, th

Transactions

2003-07-29 Thread b b
Most web hosting companies run the mysql standard. Which means one can't run transactions. If that is the case, then how do you handle many to many relationships with truely normalized manner without risking data corruption For example: You have an org, ctry tables and a middle table orgCtry. T

mysql vs mysqlMax

2003-07-29 Thread b b
Hi, When installing the mysql4 binary it works fine. When installing the mysql max4 binary I get the following message when I try to run mysqld_safe. I am running linux redhat 9.1. Would anyone know why this is happening? 030728 23:54:57 mysqld started 030728 23:54:58 bdb: /usr/local/mysql/d

mysql vs mysqlMax

2003-07-29 Thread b b
Hi, When installing the mysql4 binary it works fine. When installing the mysql max4 binary I get the following message when I try to run mysqld_safe. I am running linux redhat 9.1. Would anyone know why this is happening? 030728 23:54:57 mysqld started 030728 23:54:58 bdb: /usr/local/mysql/d

mysqlMax vs mysql

2003-07-28 Thread b b
When installing the mysql4 binary it works fine. When installing the mysql max4 binary I get the following message when I try to run mysqld_safe. I am running linux redhat 9.1. Would anyone know why this is happening? 030728 23:54:57 mysqld started 030728 23:54:58 bdb: /usr/local/mysql/data

MySQL and Redhat 7.3

2003-03-11 Thread b b
Greetings, I am new to this list so I don't know if this topic has been pounced around or not. DOES MYSQL WORK ON REDHAT? I got Redhat 7.3 and MySQL 3.23.55 I tried binary installations. I tried installing from source too. When I finally run the /usr/local/mysql/bin/safe_mysqld --user=mysql &