Social Buttons
  1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

database repair not working

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

0
  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'
    SEMrush
     
    hmk20009, Sep 30, 2018 IP
    SEMrush
  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