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.
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
I don't know how you made your backup, apparently you missed the mysql.host table.
Usually when making a new install a mysql database containing all the privileges is created, maybe you erased this when copying your files?
In an other mail you say you used the --all-databases option so I suppose the error is somewhere else.
To identify the problem you may try to recreate the mysql db, see if it works, and if yes check your dump.
About your indexes I usually use mysqldump and the indexes are exported as well, you can check with show index but I'm not sure that is what you are looking for.
http://dev.mysql.com/doc/mysql/en/mysqldump.html
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]
_________________________________________________________________
It's fast, it's easy and it's free. Get MSN Messenger today! http://www.msn.co.uk/messenger
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
