not able to start mysqld on debian multiserver master because of corrupt db

Discussion in 'Installation/Configuration' started by degoya, Aug 5, 2016.

  1. degoya

    degoya New Member

    after server crash when i try to start the mysqld
    i get
    [FAIL] Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!

    is there a way to recoverer the Database or correct it?
     
  2. RootEtsy

    RootEtsy New Member

    Hope you already have this issue fixed. :)
    If not then try this if it's it's a Myisam corrupt DB.
    $ mysqlcheck -r -A

    If it's it's an Innodb issue then it's a little more complicated. You can read more about those by searching for "mysql innodb force recovery".

    Don't worry about the version, it's been the same procedure for years. Be sure to take a full backup of the data directory before proceeding! That's really important in Innodb recovery.
    I've literally recovered from hundreds of these issues so let me know if you have any questions.
     

Share This Page