Re: How do you backup HUGE tables?

2009-01-23 Thread ceo
Something totally ghetto that might work... If you could convert the files to appear to be text with some kind of reversible fast translation, rsync might be able to handle the diff part. You'd sure want to test this out thoroughly... -- MySQL General Mailing List For list archives: htt

Re: Data Inconsistent

2009-01-21 Thread ceo
Why are A and B letting you cram NULL into a column declared NOT NULL? Are your schemas consistent on A/B/C? Perhaps 5.0.32 does not enforce NOT NULL properly? Some tweak to config may change this? I don't know the answer, but with a bit of research in this direction, you should be ther

Re: question about natural join

2009-01-21 Thread ceo
The natural join will JOIN on *all* the fields whose names match, not just the ones you want it to. In particular, the JOIN is matching up .expires and .expires with "=" You then use WHERE to get only the ones with ">" This is a tautology: There are NO records both "=" and ">" on the fie

Re: Is deleting the .FRM, .MYD and .MYI files the same as dropping table?

2009-01-16 Thread ceo
I think you may be over-panicing. :-) If you do a DROP on the master and that replicates through, just like the create did, then you're all set. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.o

Re: Upgrage MYSQL 5.0 to 5.1 :: "Using unsupported buffer type"

2009-01-14 Thread ceo
Did you re-compile/re-link your C app with the new MySQL header files?... Sounds like you didn't. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Restarting MySQLD when all transactions are complete

2009-01-14 Thread ceo
Read the mysqld man pages about what it does with kill -X signals. One of them may mean "graceful stop" Or not. If there is one, you'd still have to figure out how to tie that into a re-boot or whatever for updates. Sounds like a perfectly reasonable feature request if you find nothin

RE: how to design book db

2009-01-06 Thread ceo
Just theories here: The same book re-issued by another publisher might have a different ISBN. A book with an insert (e.g., CDROM) may have a different ISBN, but be the "same" for some purposes. And mistakes can be made... Ultimately, I suspect that the uniqueness of ISBN to what norma

Re: slow query log

2008-12-31 Thread ceo
I'm just guessing, but if the slow query log time resolution is seconds, perhaps 0.5 and higher rounds up? Or, perhaps it has an index, but it can't be used in that query. What does EXPLAIN [paste query here] tell you? -- MySQL General Mailing List For list archives: http://lists.mysql.

Re: installation nightmare

2008-12-19 Thread ceo
First of all, you are using a ports distribution system from BSD which means that you are not dealing with MySQL directly but with a BSD API layer on top of MySQL for installation. So much of your issues may end up being a BSD problem, not a MySQL problem at all. If the BSD scripts that a

Re: Function call reult in a WHERE-IN clause

2008-12-17 Thread ceo
Perhaps pass in a "separator" string arg, default to '' and do: GROUP_CONCAT(DISTINCT h.hostid, separator) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: stuck on a query

2008-12-17 Thread ceo
Hopefully your CILS table is not too many rows... select * from JOB, CILS as cyan, CILS as magenta where cyan.num_of = JOB.num_of and magenta.num_of = cyan.num_of and cyan.color = 'cyan' and magenta.color = 'magenta' or something not unlike that... You may want UNIQUE JOB.id_enc

Re: Vexing permissions issue with partitioned CREATE TABLE

2008-12-05 Thread ceo
I've never created a partitioned table, but... $ perror 13 OS error code 13: Permission denied So I suspect some kind of file-system permissions issue... Are you sure that the path you are giving isn't "relative" to the mysql data dir? In which case it's trying to use something mor

Re: mysql.org

2001-07-21 Thread Brooklyn Linux Solutions CEO
Too bad it's not your list to make that decision, but Monteys Ruben mysql - the database written and owned by MYSQL AB > On Sat, Jul 21, 2001 at 01:13:15PM +0100, Mark Tiramani wrote: > > > > > Since these issues are between two private companies, please take > > > your discussions off this li

Re: mysql.org

2001-07-19 Thread Brooklyn Linux Solutions CEO
> > MYSQL.NET > XMYSQL.COM > MYSQLPHP.COM > PHPMYSQL.COM > MYSQL-PHP.COM > MYSQLHOST.COM > > -S > > Aside from being incorrect about the process of tradmarking in the US and the ability to defend a trademark while awaiting registry, all these above websites are not claiming to be the off

Re: Re: mysql.org

2001-07-19 Thread Brooklyn Linux Solutions CEO
> > I think you see evil people, conspiracies and other unwanted stuff when > in fact there are only misunderstandings and opposing viewpoints. > > I'm with Bob Hall on this one. Excellent statement Bob! > > -S > > Their is no conpsirisy, there is only one company trying to steel

mysql.org

2001-07-19 Thread Brooklyn Linux Solutions CEO
mplained that they were violating the GPL. This is NOT the actions of an honest person...period... No We need NuSphere to admit their wrongs, make a blanket apology, and everyone can call a no harm no foul, and forget it happened. Ruben - End of forwarded

Re: mysql.org

2001-07-19 Thread Brooklyn Linux Solutions CEO
Fact MYSQL owns their trademark Fact, what NuShpere brought form MYSQL is irrelevant as loing as they are infrringing on the MYSQL Trademark...and they were going to do WORSE until the public heat. Until they apologies fo the GPL violation, and then the Trademark infringment, they are pound sc

Re: mysql.org

2001-07-19 Thread Brooklyn Linux Solutions CEO
> the same time, a NuSphere-controlled mysql.org doesn't strike me > as a disaster, provided they can do it with out shooting > themselves in the foot, as they are doing now. > Nah There using it as a marketing ploy to dup the public. The should have released their GPLed extentions on NuSh

Re: Re: mysql.org

2001-07-13 Thread Brooklyn Linux Solutions CEO
database,sql,query,table > > Now most of us in/using Open Source probably do not _really_ > understand the meaning and ramifications of the GPL. We _think_ > we know, and we certainly have a "feeling" about what the GPL > "means". Oh Bull Making a derived work from a GPL produc

Re: mysql.org

2001-07-13 Thread Brooklyn Linux Solutions CEO
The greatest asset to using the MYSQL product over the years has been this mailing list and Monty's personal efforts to answer almost every question, no matter how stupid or repetitive, patiently and accurately. It's blown my mind to see him working so hard on handling the enormous communication

updating mysql

2001-05-19 Thread simon joas, vorstand/ceo: sjn AG
hallo! how do i update my mysql-database to a new version? -simon- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thre

Re: MySQL License

2001-03-06 Thread Brooklyn Linux Solutions CEO
You can charge for any GPL'ed product you wish too. Ruben On 2001.03.05 22:31:41 -0500 Jeff Platzer wrote: > Maybe someone can help me out with MySQL's commercial license. > > If MySQL server has a GPL license and MySQL client libraries have LGPL > licenses, how can a paid commercial license be

Persistant Connection

2001-02-09 Thread Ruben I Safir - Brooklyn Linux Solutions CEO
Good Morning: We have a system of databases (in the plural) which number in the hundreds on individual servers. I want to open a persistant connection on the server and switch databases without closing the handle in DBI and reopening it. Is this possible without getting a rollback warning using

NuSphere

2001-02-04 Thread Ruben I Safir - Brooklyn Linux Solutions CEO
What exactly is now the relationship between NuShpere and MYSQL/TSX. Who is working on the Gemini COde and the documentation? Ruben -- Brooklyn Linux Solutions http://www.mrbrklyn.com http://www.brooklynonline.com 1-718-382-5752 -