INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Updated mysql to 5.5.35 and cannot start it now???

Updated mysql to 5.5.35 and cannot start it now???

Updated mysql to 5.5.35 and cannot start it now???

(OP)
The other day I used apt-get to apply some updates to my ubuntu 13.10 server. Among them to the above stated level of MySQL. However, after I rebooted I can no longer start the mysqld program. The error complains of an innoDB checksum error. The interesting thing is that I don't have any DB's with the innoDB engine. Mine are all mysqlisam.

I've been searching for a way to get this program started to no avail. Hopefully some of you guru's can point me to the correct direction. Fortunately I do have a mysqldump of all databases/tables from shortly before.

Do I completely clear out the /var/lib/mysql directories, and attempt to recreate and load the databases? I don't want to jump to conclusions so that's why I'm asking for some suggestions from those who might have experienced this error.

Thanks anyong . . . ponder

RE: Updated mysql to 5.5.35 and cannot start it now???

Feel like upgrading again <grin>.

On website: http://dev.mysql.com/doc/relnotes/mysql/5.5/en/new... (upgrading to 5.5.5)
I found the following as a bug fix:
InnoDB: Fixed a checksum error reported for compressed tables when the --innodb_checksums option is enabled. Although the message stated that the table was corrupted, the table is actually fine. (Bug #53248)

RE: Updated mysql to 5.5.35 and cannot start it now???

(OP)
Well I thought I would update my request.
Ultimately I had to completly remove and reinstall mysql which deleted the tables. The I had to recreate the databases and reload from my backup. Took a while but its done. A PIA but at least its working.

RE: Updated mysql to 5.5.35 and cannot start it now???

Glad you got it fixed -- sadly I am also painfully aware of the PIA aspect of something that should be so simple.
Also, than you for updating the status! Too often I find forum entries describing the exact problem I am having, see a few suggestions, then never any word on if it was fixed :(

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close