HELP : SQL command parser broken

2003-01-24 Thread Brad Phinney
I compiled and installed mysql-max-3.23.51. Installation process seems to go fine. When I go to run mysql_install_db however, I get the following error : ERROR : 1064 use mysql; syntax error I try starting mysqld without grant tables - and I can. However, when I connect via a client, none of t

MySQL, FreeBSD problem

2002-03-19 Thread Brad Phinney
Hello all. I have an application that does a lot of table creation and writing for a FreeBSD 4.4 SMP machine. Over time, I begin to see the following errors. DBD::mysql::db tables failed: Can't read dir of './p0_samt_trans/' (Errcode: 2) at /var/SAMT/code/SAMTlib/SAMTdb.pm line 2552, chun

RE: BSD and MySQL : Major Problems

2002-02-13 Thread Brad Phinney
The problem with this error is (1). It seems OS dependent (cannot recreate it on Linux, Solaris). (2). It happens randomly, no rhyme nor reason. I am simply making a DBI call to do ALTER TABLE or tables-> command. One second it could fail to open the DB directory (hence the error). Three se