Ghost Tables

2008-01-12 Thread OldManRiver
All, I have a MySQL containing 12 databases, one which has 3 tables. I've looked in the docs to determine how to re-index and run maintenance on my databases and it leaves me cold. Anyway I login at the console and: show databases; ==>> DB shows use <>;==>> DB s

Re: Unable to restart after crash

2008-01-12 Thread Grant Peel
Have you looked at the results of netstat -an ? -Grant - Original Message - From: Ross Crawford To: mysql@lists.mysql.com Sent: Saturday, January 12, 2008 5:12 PM Subject: Unable to restart after crash Hi, My mysql server crashed last night, and when it rebooted, was

Unable to restart after crash

2008-01-12 Thread Ross Crawford
Hi, My mysql server crashed last night, and when it rebooted, was unable to restart. Here is the error log: Jan 13 00:12:54 localhost mysqld_safe[1324]: started Jan 13 00:12:55 localhost mysqld[1327]: 080113 0:12:55 InnoDB: Database was not shut down normally! Jan 13 00:12:55 localhost mys