mel list_php wrote:
Hi Sam,
To shutdown mysql I just use mysqladmin shutdown. http://dev.mysql.com/doc/mysql/en/server-shutdown.html
Thanks for this help. I will surely use this command next time.
About you restart problem, have a look in mysql/data/host.err file, it should give you a reason there.Yeah, I have looked at it, but not sure whether I need to repopulate the mysql.host db file. If I do that, I may be also need to recreate all db passwords as well.
Last time I had that problem it's because I hadn't kill all the process.
The error is:
InnoDB: log sequence number 0 43634.
InnoDB: Doing recovery: scanned up to log sequence number 0 43634
050302 16:36:43 InnoDB: Flushing modified pages from the buffer pool...
050302 16:36:43 InnoDB: Started; log sequence number 0 43634
050302 16:36:43 [ERROR] Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
050302 16:36:43 mysqld ended
Since all DB data in this server are restored from the FreeBSD system in MySQL 5.0. I don't know how to recreate all indexes for db.
Is there simple way for recreating all indexes? or check whether indexes are in-placed?
Thanks Sam
Good luck!
From: sam wun <[EMAIL PROTECTED]> To: mysql@lists.mysql.com Subject: Silly mistake Date: Wed, 02 Mar 2005 15:58:28 +0800
Hi,
I admit I m silly to shutdown mysqld with the killall command in the Redhat server, I can't restart mysql service now. Most of the reason is because the script mysql.server come with the mysql 4.1.10 does not like mysql.server start or mysql.server stop, so I need to start it up use & and shut it down with killall.
Anyway, after killall mysql, I got the following error when I tried to restart it.
Here is the error:
./mysqld
Starting mysqld daemon with databases from /usr/local/mysql/data
STOPPING server from pid file /usr/local/mysql/data/vivaserver.pid
050302 15:52:05 mysqld ended
How can I start mysqld now?
Thanks Sam
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
