LinuxQuestions.org
Latest LQ Deal: Complete CCNA, CCNP & Red Hat Certification Training Bundle
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 03-24-2009, 11:10 AM   #1
timhilliard
LQ Newbie
 
Registered: Mar 2009
Distribution: CentOS 5.2
Posts: 3

Rep: Reputation: 0
MySQL fails to start after loading dumped InnoDB database


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
 
Old 03-24-2009, 05:38 PM   #2
JaksoDebr
Member
 
Registered: Mar 2009
Distribution: Fedora, Slackware
Posts: 104

Rep: Reputation: 21
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

Last edited by JaksoDebr; 04-02-2009 at 06:11 AM.
 
Old 03-24-2009, 09:04 PM   #3
timhilliard
LQ Newbie
 
Registered: Mar 2009
Distribution: CentOS 5.2
Posts: 3

Original Poster
Rep: Reputation: 0
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

Last edited by timhilliard; 03-24-2009 at 09:12 PM.
 
Old 03-25-2009, 08:41 AM   #4
timhilliard
LQ Newbie
 
Registered: Mar 2009
Distribution: CentOS 5.2
Posts: 3

Original Poster
Rep: Reputation: 0
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
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
My SQL statement to delete an entry in MYSQL database fails in PHP ratchie Linux - Software 1 12-29-2008 03:48 AM
mysql failed to start database tarak420 Linux - Server 3 09-19-2008 07:41 PM
MySQL Innodb troubles Baltasar Linux - Software 1 04-20-2005 10:01 AM
MySQL & InnoDB riluve Linux - Software 0 03-13-2005 10:19 PM
InnoDB problem with MySQL jerry_redhat Linux - Software 2 07-09-2003 01:20 AM


All times are GMT -5. The time now is 05:23 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration