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

    Join Date
    May 2013
    Posts
    1
    Rep Power
    0

    Mysql Recovery Question


    My Hardrive with Mysql Crashed and was able to recover everything in the mysql directory apart from the mysql/mysql folder which mysql server is dependent upon. I have no offsite backup so I am not able to restore from dumps.

    All individual databases, ibdata1, ib_logfile0 and ib_logfile1 are still intact. When those individual databases where used to overwrite newly created database folders on a new Server, they work perfectly for databases created in the MyIsam format but all InoDB databases are not working. I have noticed that there are no .idb files in the respective database folders.

    Is it still possible to get back my DBs done in InnoDB format?

    Thanks for the anticipated replies.
  2. #2
  3. No Profile Picture
    Lost in code
    Devshed Supreme Being (6500+ posts)

    Join Date
    Dec 2004
    Posts
    8,317
    Rep Power
    7170
    Unless the old server had innodb_file_per_table enabled, which is not the default, the data for your innodb tables would all be in the ibdata1 file.

    Are you sure the old server and the new server are running the same version of MySQL?
    PHP FAQ

    Originally Posted by Spad
    Ah USB, the only rectangular connector where you have to make 3 attempts before you get it the right way around

IMN logo majestic logo threadwatch logo seochat tools logo