Re: mysqldump and the dreaded lost root password dilemma

2004-09-18 Thread Mitch Pirtle
Thanks Brent, your solution is the one that worked for me. In 4.0.20 there was no 'Super_priv' column however. ? On Fri, 17 Sep 2004 15:20:43 -0400, Brent Baisley <[EMAIL PROTECTED]> wrote: > There probably is a "root" user, but it's not called root. You can name > the "root" user whatever you

mysqldump and the dreaded lost root password dilemma

2004-09-17 Thread Mitch Pirtle
andard MyISAM tables. Is there a trick to getting exports from a 4.x database to work on 3.23.x systems? -- Mitch -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Secure Database Systems

2004-07-09 Thread Mitch Pirtle
e article, if you are interested please contact me off-list ;) -- Mitch -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

More semaphore mystery

2004-07-06 Thread Mitch Pirtle
ed in file btr0cur.c line 401 ...So what's a guy to do? Is there a way I can determine just what exactly is causing this? -- Mitch -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: InnoDB and long semaphore waits

2004-07-05 Thread Mitch Pirtle
hink those ugly warnings will again be removed in the next 4.0 release. They were instroduced to 4.0.xx accidentally. Thanks Heikki, as long as I know it is a known error I am happy to wait (and truncate my error logs)... :^) -- Mitch -- MySQL General Mailing List For list arch

Re: InnoDB and long semaphore waits

2004-07-05 Thread Mitch Pirtle
Heikki Tuuri wrote: Mitch, please send the FULL .err log to me. Hey Heikki, Not sure you want that, the file is 44MB uncompressed, and only talks about the errors reading communication packets. Makes for some really boring reading ;) The InnoDB error I managed to figure out - I once upped

InnoDB and long semaphore waits

2004-07-03 Thread Mitch Pirtle
ough data to know how to react... Can somebody please whack me upside the head with a cluestick? -- Mitch -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Won't compile on Mac OS X 10.2

2002-08-25 Thread Mitch Leung
Dear Sir, MySQL 3.23.52 won't compile on Mac OS X 10.2 based on Darwin 6.0 which comes pre-installed with gcc 3.1 I don't want to uninstall it as it would probably bring down other major functions of the new system. Regards, Mitch Leung -- __ __ __ __ _ _ M

Re: Does Yahoo Use MySQL?

2002-06-27 Thread mitch
/* [EMAIL PROTECTED] [[EMAIL PROTECTED]] writes: */ >I just wanted to know what Database does Yahoo Uses.. > Perhaps this will provide you more of what you'd like to know... http://www.mysql.com/articles/us/yahoo_finance.html -- do svidaniya

Re: how to get support help?

2002-04-25 Thread mitch
h has a larger user base; thus increasing your chances of getting an answer. 2. Find another product/project which meets your needs. So there you have it... Four ideas that aren't "buy a contract". -- do svidaniya, ~mitch --

Stability of 4.0.1

2002-04-10 Thread mitch
Can anyone comment on the stability of the current 4.x MySQL release. I'd be using MyISAM tables and only features which are currently available in the 3.23.x series. -- do svidaniya, ~mitch - Before posting, p

Re: Re: Do any of your applications work?

2002-04-06 Thread mitch
ED]> >Sent: Saturday, April 06, 2002 2:36 PM >Subject: Re: Do any of your applications work? > >> Hello Mr CEO, >> >> Hmmm... go away? >> >> Ric -- do svidaniya, ~mitch MYSQL? MySQL? mySQL? So many choices, so little time.

My.S.Q.L

2002-04-06 Thread mitch
Ok... it's Saturday and I've been meaning to share this with a wider audience for years Antti, you'll probably remember this from when I sent this to you shortly after I wrote it (1999)... If anyone would like to record this, let me know! :-) My.S.Q.L (sung to Y.M.C.A by the Village Peopl

Re: Do any of your applications work?

2002-04-06 Thread mitch
LIENT may cancel a licensing agreement... Sir, other words come to mind, but for the sake of this forum I'll simply say that you are acting unprofessional. -- do svidaniya, ~mitch - Before posting, please check: http

query time varies greatly - problem with indexes?

2002-04-04 Thread mitch
x27;,'1321770882121014766473',1); query: SELECT sum(first) FROM formLog WHERE client='19' To Reproduce: Download: http://www.tradepub.com/mysql/test.db (615K bytes) http://www.tradepub.com/mysql/test_bug.cs

Optimal value for 'max_connections'

2002-01-17 Thread Mitch Fournier
(cache problem?) i obviously need to do some optimization in my java code and jsp pages (who doesn't ;), but i also suspect the default 100 connections is too low. can i set this to 500 or 1000? also, i've been looking for a good site with mysql optimization tips, any sugg

myODBC error list?

2001-10-29 Thread Mitch Mooney
Any way of getting a native error,sqlstate,error number list ? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-