#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2017
    Posts
    99
    Rep Power
    2

    Recover ibdata file


    I just made a mistake and delete the ibdata file from var/lib/mysql
    Are there any good options of recovering the file/undelete from linux terminal ? Or any options of recovering the database ? I have all the tables but i dont have the data and the indexes
    edit: i've used this tutorial Restoring table(s) in MySQL database when frm or ibd files are available only - Vox Teneo to recover the tables from the frm files and tried linking to the .idb files and every time i get Got error -1 from storage engine after doing this
    there it says to not worry about the warnings but i dont see any data in the table
    edit: after doing some more reading i saw in the error log that
    InnoDB: Error: tablespace id is 201 in the data dictionary
    InnoDB: but in file ./dummydatabase/comments.ibd it is 125! and using a hex editor to change the tablespace id but i can't find it anywhere in the file...
    edit2:: This is such a pain in the arse..
    Last edited by pwpx2; February 20th, 2018 at 01:02 PM.
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2017
    Posts
    99
    Rep Power
    2
    Resolved

IMN logo majestic logo threadwatch logo seochat tools logo