Using InnoDB on 2 OSes

2005-04-23 Thread Marcin Lewandowski
Hi, I've got Win2k on one FAT32 partition, and I use MySQL 4.0.23 there. I've got gentoo linux on second partition, and I want to use the same databases on linux's MySQL. I've configured linux's mysql to use databases from FAT32 partition, but InnoDB tables don't work. phpmyadmin show them as "

Re: I need help with a Select Query

2005-04-23 Thread Ed Reed
Try this SELECT * FROM applications LEFT JOIN rejected ON application.appid = rejected.appid WHERE rejected.appid Is Null ORDER BY application.appid DESC; >>> Wade <[EMAIL PROTECTED]> 4/23/05 3:12:37 PM >>> 04232005 1707 GMT-6 I need to do something like this: $sql = "SELECT * FROM applicatio

Re: User Variables

2005-04-23 Thread Ed Reed
Thanks for the reply, I realize that user variables disappear when the connection closes but I don't understand why what I'm trying to accomplish can't be done. Doesn't it make since that if you can load a single file with multiple SQL commands and have that work succesfully then you should be

privileges table: interpretation of _ changed

2005-04-23 Thread Michael Hoennig
Dear mySQl community, In the following I do not only list a problem, others might also run in, but I also want to point out a stangeness of one of your fixes. Recently there was a change in 3.23.49 (on Debian/Woody): * Applied patch for a bug that wrongly interpreted '_' in conjunction with

Re: User Variables

2005-04-23 Thread Paul DuBois
At 22:04 -0700 4/22/05, Ed Reed wrote: Thanks for the reply, So is there anyway to use User Variables with a single connection. All my apps are in VB6 and VBA. They all take a query, open a connection, run query, fill array from query results, close connection and pass back the array. Because of

Need help adding database to multi server mysql?

2005-04-23 Thread Don Vaillancourt
We have MySQL setup as a MYSQL_MULTI configuration so that each database has their own instance of MySQL. We need another database configured and so added an entry in the my.cnf.  We've tried to start the new database, but keep getting this error.  We know that for each database there needs

Re: server params

2005-04-23 Thread Gary Richardson
A quick thing to check is that DNS lookups are timing out on connect. If you don't have DNS on your local subnet, the server may be doing reverse lookups.. Otherwise, you should definitely profile your code. On 4/21/05, Brent Baisley <[EMAIL PROTECTED]> wrote: > For starters, compare timings betw