ERROR 1030: Got error 127 from table handler

2002-05-20 Thread Carter, Robert L (MN65)
Can anyone shed some light on this? Have found that others have run into this (via Google) but no resolution and no hits at www.mysql.com. A count(*) query returns fine but trying to select the rows fails (see log snippet below). Regards, Bob mysql select count(*) from event where

Can MySQL be run from a CD-ROM?

2001-10-29 Thread Carter, Robert L (MN65)
I'd like to package MySQL, some databases, and PHP-enabled Apache on a CD-ROM, with all components runnable with, essentially, no installation in a Windows environment. This would be a read-only database accessed through a web browser by way of PHP scripts. Is such a thing possible?

Locking with multiple databases

2001-03-15 Thread Carter, Robert L (MN65)
I am running Ver 8.8 Distrib 3.23.22-Beta on RedHat Linux. I have two databases, foo and bar. Below I show the output of mysqladmin processlist. Pid 5 is executing a long-running select from the event table of db foo. Pid 1 (started after pid 5) is attempting an insert in the same event table.