Re: LOAD DATA INFILE failing on OS X Server

2003-09-22 Thread Bill Leonard
not yet tested LOAD DATA LOCAL in either case (it wouldn't help solve the task if it did, but if it helps troubleshoot this problem we will try! Thanks, Bill -- Bill Leonard [EMAIL PROTECTED] www.machinemen.com

LOAD DATA INFILE failing on OS X Server

2003-09-21 Thread Bill Leonard
it works there (and works even without the file priv enabled) So there is something fundamental I am not seeing... Any pointers would be appreciated! Bill -- Bill Leonard [EMAIL PROTECTED] www.machinemen.com

Re: Tracking a delete

2003-08-14 Thread Bill Leonard
attempt to SELECT it, and if you get no result, it's not there. But that doesn't necesarily mean that it was once there and has now been deleted. If you want to determine that, you'll need to create a log of record deletions. -- Bill Leonard [EMAIL

Re: Databases go away... But why?

2003-03-29 Thread Bill Leonard
news for me :-) Thanks -- Bill Leonard [EMAIL PROTECTED] www.machinemen.com407.464.0147 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Databases go away... But why?

2003-03-28 Thread Bill Leonard
in there. Any ideas as to what could be causing this, or how to troubleshoot it to narrow it down further? MySQL is not quitting apparently, the databases just disappear. Shutting down the service and restarting it fixes it. Thanks for any pointers anyone! -- Bill Leonard

MySQL quitting, restarts only after hard reboot

2003-02-19 Thread Bill Leonard
This one is still biting us.. any suggestions on where to troubleshoot would be appreciated. Mac OS X Server, 10.2.1 - MySQL 3.23.51 Heavy usage, but no more than 50 open connections at a time Occasionally, MySQL just quits serving databases. The first indication is a forum or something comes

MySQL quitting, restarts only after hard reboot

2003-02-16 Thread Bill Leonard
could be going on that it shows this behavior? Any ideas? Thanks for any ideas. Bill -- Bill Leonard [EMAIL PROTECTED] www.machinemen.com 407.464.0147 XrackHosting.com - Mac OS X hosting on Apple's Xserve! http

MySQL stops working on OS X Server 10.2.1

2002-11-18 Thread Bill Leonard
to cause this? Thanks for any advice! Bill -- Bill Leonard [EMAIL PROTECTED] www.machinemen.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

MySQL quits serving on Mac OS X Server 10.2

2002-11-18 Thread Bill Leonard
this? Thanks for any advice! Bill -- Bill Leonard [EMAIL PROTECTED] www.machinemen.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Export, then Import HUGE number of rows/data?

2002-10-15 Thread Bill Leonard
? Thanks for any advice! Bill -- Bill Leonard [EMAIL PROTECTED] www.machinemen.com407.464.0147 - Before posting, please check: http

Re: MySQL a quotas?

2002-09-30 Thread Bill Leonard
? Thanks for the info! -- Bill Leonard [EMAIL PROTECTED] www.machinemen.com407.464.0147 XrackHosting.com - Mac OS X hosting on Apple's Xserve! http://www.xrackhosting.com

MySQL Starts, but quits immediately

2002-08-02 Thread Bill Leonard
args CFArray 0x1ac200 [0xa01403fc]{type = immutable, count = 1, values = ( 0 : CFString 0x54280 [0xa01403fc]{contents = --user=mysql} )} Env (null) -- Bill Leonard [EMAIL PROTECTED] www.machinemen.com

Re: permissions questions...

2002-08-01 Thread Bill Leonard
this be specified (so when MySQL starts as a service on its own, this option is included). Thanks for any pointers! -- Bill Leonard [EMAIL PROTECTED] www.machinemen.com407.464.0147

Setting the safe_show_database variable in my.cnf

2002-08-01 Thread Bill Leonard
. This is on RedHat 7.3, MySQL 3.23.51. I am using the /etc/my.cnf if that matters. Any help would be GREATLY appreciated... ! -- Bill Leonard [EMAIL PROTECTED] www.machinemen.com407.464.0147

Set different sizes on a per-database level?

2002-07-27 Thread Bill Leonard
I have been searching and searching, and maybe this is a 4.0 thing, but is there a way, on a case by case basis, to pre-define a size limit for a MySQL database? In other words, make one 50MB and the next one make 100MB on the same server? I've seen indications you can set the default size for

Set different sizes on a per-database level?

2002-07-27 Thread Bill Leonard
I have been searching and searching, and maybe this is a 4.0 thing, but is there a way, on a case by case basis, to pre-define a size limit for a MySQL database? In other words, make one 50MB and the next one make 100MB on the same server? I've seen indications you can set the default size for