Re: SQL syntax

- Original Message - From: "Scott Yamahata" <[EMAIL PROTECTED]> To: Sent: Friday, December 29, 2006 1:29 AM Subject: SQL syntax Hi, I'm getting the following error message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the

Re: trouble starting mysqld daemon

Thanks! I think I'm in business. I changed some privileges, examined the logs (which helped a lot), and initialized the database again using "mysql_install_db --user=mysql --datadir=/opt/mysql/mysql/data" now onto PHP take care Jeff From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] T

Re: trouble starting mysqld daemon

Check for .err text log files .. they are probably in /opt/mysql/mysql/data/ called servername.err servername is the hostname of your box. On Thu, 28 Dec 2006, Jeff Jones wrote: > Hi! > > I'm a rookie, so bear with me... > > Keep getting: > > Starting mysqld daemon with database

trouble starting mysqld daemon

Hi! I'm a rookie, so bear with me... Keep getting: Starting mysqld daemon with databases from /opt/mysql/mysql/data Stopping server from pid file /opt/mysql/mysql/data/unknown.pid 061228 17:16:04 mysqld ended After this command > bin/safe_mysqld --user=mysql & Very open to suggestions Th

Re: Bizarre InnoDB Error Message ( trx->active_trans == 0, but trx->conc_state != TRX_NOT_STARTED)

Jason, I am Cc:ing the MySQL General mailing list, so that others who bump into this bug can find this discussion. Jason J. W. Williams wrote: Mr. Tuuri, We have a high degree of UPDATE/INSERT concurrency along with high SELECTs. It causes a deadlock about once every 24 hours. In this case a