Michael, ----- Original Message ----- From: ""Michael T. Babcock"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Thursday, September 05, 2002 5:15 PM Subject: Bad table conversion
> I was using phpMyAdmin to do some user management and since it was > fairly slow, decided to try upgrading my mysql.users and mysql.db tables > to InnoDB format. It seems however that this is a "bad thing" as mysql > told me when it refused to restart. I've recovered the users table from > a backup but had to use the default (empty) db table for now. Is there > any way to have the InnoDB handler read the db table under a different name? what version you are using? This is what I got in the error log: ... heikki@Rescue:~/mysql-4.0/sql> mysqld 020905 20:46:01 Warning: setrlimit couldn't increase number of open files to mo re than 1024 (request: 1510) 020905 20:46:01 Warning: Changed limits: max_connections: 300 table_cache: 357 020905 20:46:02 InnoDB: Started mysqld: ready for connections InnoDB: Error: trying to create a MySQL system table mysql/user of type InnoDB. InnoDB: MySQL system tables must be of the MyISAM type! 020905 20:47:17 InnoDB: Error: table mysql/user does not exist in the InnoDB in ternal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look further help from section 15.1 of InnoDB: http://www.innodb.com/ibman.html InnoDB: Error: trying to create a MySQL system table mysql/db of type InnoDB. InnoDB: MySQL system tables must be of the MyISAM type! 020905 20:51:04 InnoDB: Error: table mysql/db does not exist in the InnoDB inte rnal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look further help from section 15.1 of InnoDB: http://www.innodb.com/ibman.html 020905 20:51:20 mysqld: Normal shutdown 020905 20:51:20 InnoDB: Starting shutdown... 020905 20:51:22 InnoDB: Shutdown completed 020905 20:51:22 mysqld: Shutdown Complete heikki@Rescue:~/mysql-4.0/sql> mysqld 020905 20:51:25 Warning: setrlimit couldn't increase number of open files to mo re than 1024 (request: 1510) 020905 20:51:25 Warning: Changed limits: max_connections: 300 table_cache: 357 020905 20:51:25 InnoDB: Started mysqld: ready for connections ... It left the MyISAM user and db tables as they were. You have lost the db table? I guess that if you create the same databases in another server and copy the db table from there, it should work again. > -- > Michael Regards, Heikki sql query --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php