database repair not working

Discussion in 'Databases' started by hmk20009, Sep 30, 2018.

  1. #1
    i transferred databases from my old vps to new vps.

    All mysql databases work fine except one. PHPmyadmin doesn't show all tables of that database, although /var/lib/myql/dbname contains all files of database.

    i tried to repair db:
    myisamchk -r /var/lib/mysql/dbname/*.MYI but shows error for lot of tables

    myisamchk: error: 140 when opening MyISAM-table '/var/lib/mysql/dbname/tablename.MYI'
     
    hmk20009, Sep 30, 2018 IP
  2. SaleSmith

    SaleSmith Peon

    Messages:
    24
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    1
    #2
    Hi. Try running the database in recovery mode and copy all the data into new tables.
    It will be helpful for you to know that there are 6 different levels of recovery mode. May be you need try different levels to run the database successfully.
     
    SaleSmith, Oct 4, 2018 IP