mel list_php wrote:
It worked nearly perfectly before, I can login to db, use perl dbi connect to it, etc. So I think it is the problem when I executed command killall mysql. I don't supposed it remove the mysql.host file, may be mysql.host db is corrupted when I m doing so, so it removes it for me.
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.
This becomes a very big problem, I m not sure if one day the system crashes, mysql will remove any DB without warning me first.
Now, it is most likely I need to erase all dbs and repopulate (restore) all data.
I have checked all indexes with the show index TABLE commands, and compared the result with the one in FreeBSD, and looks quite identical.
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
The only difference is the one in FreeBSD is running MySQL 5.01 and the one in this Redhat is running MySQL 4.1.10.
The indexing problem gave me a big headache because I m not sure whether it is the versioning problem or missing indexes or something else...
With MySQL5.01 in FreeBSD 5.3, it takes 2 seconds finish the query, but with MySQL 4.1.10 in Redhat, takes forever...
Thanks Sam
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]
