Hi there, I'm getting the following error in the /var/log/mysql.log file

090324 10:30:37 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
090324 10:30:37 [ERROR] Error message file '/usr/share/mysql/english/errmsg.sys' had only 472 error messages,
but it should contain at least 622 error messages.
Check that the above file is the right version for this program!
/usr/libexec/mysqld: Unknown error 1146
090324 10:30:37 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
090324 10:30:38 InnoDB: Started; log sequence number 0 46409
090324 10:30:38 [ERROR] Aborting

090324 10:30:38 InnoDB: Starting shutdown...
090324 10:30:39 InnoDB: Shutdown completed; log sequence number 0 46409
090324 10:30:39 [Warning] Forcing shutdown of 2 plugins
090324 10:30:39 [Note]
090324 10:30:39 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

The problem came about after I did a dump of InnoDB tables from one server and have tried to reload them to my new server. About 2/3 the way through processing the table it started to hang. After about 30mins more I killed my instance of MySQL Administrator. After this the MySQL Server stopped working properly and when I tried to restart MySQL it failed.

I have set the root password and have checked permissions of the files in /var/lib/mysql. I have also tried adding the line skip-innodb to the my.cnf file.

I am running MySQL 5.1 on CentOS 5.2.

I have no idea what the problem is and how I can fix it. Any help would be greatly appreciated.

Regards,

Tim

You cannot backing up or restoring with Innodb with the tools supplied with MySQL. You can get around this limitation by running two MySQL database instances. Setup another MySQL database on another machine as a replication server. This replication server can be taken offline for as long as you want. Once online again, it will resync itself up with any operations that were done while it was offline.

Linux Archive

Hi JaksoDebr

Thanks for your reply, is there any way to get my new MySQL DB back online without reinstalling mysql and losing my other data. I'm not too worried if I lose the InnoDB instance, its just going to be a pain in the ass if i have to put all the other data back on as I havent got backups going yet (server is not live yet so dont worry).

Thanks,

Tim

Ok so I decided to do a clean install of mysql. Unfortunately that didn't work either. Now when I try to start up mysql the following errors are showing in my mysql.log file

090325 08:37:54 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
090325 8:37:54 [ERROR] Error message file '/usr/share/mysql/english/errmsg.sys' had only 472 error messages,
but it should contain at least 622 error messages.
Check that the above file is the right version for this program!
/usr/libexec/mysqld: Unknown error 1146
090325 8:37:54 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
090325 8:37:54 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
090325 8:37:54 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
090325 8:37:54 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
090325 8:37:54 InnoDB: Started; log sequence number 0 0
090325 8:37:54 [ERROR] Aborting

090325 8:37:54 InnoDB: Starting shutdown...
090325 8:37:55 InnoDB: Shutdown completed; log sequence number 0 46409
090325 8:37:55 [Warning] Forcing shutdown of 2 plugins
090325 8:37:55 [Note]
090325 08:37:55 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended


I have absolutely no idea what any of this means so if anyone could help me it would be greatly appriciated.

Regards,

Tim