Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Register

Quick Links


Categories

In this Discussion

› › Paying for a MySQL WORK!!1
New on LowEndTalk? Please Register and read our Community Rules.

All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.

Paying for a MySQL WORK!!1

CasterCaster Member
edited February 2016 in Requests

Got a friend who's been trying to restore a mysql db from .frm and ibdata1 , logfile0 and logfile1 files but he couldn't and i dont have much exp. with mysql stuff.

Will pay anyone who can do it :)

Comments

  • netomxnetomx Moderator, Veteran

    Dont get me wrong, but I think you are not clear on your request.

  • CasterCaster Member
    edited February 2016

    @netomx said:
    Dont get me wrong, but I think you are not clear on your request.

    i dont know what he's upto too.
    well he just me
    3 files and a folder containing .frm files.
    As much it seems he just copied his whole server up and now he deleted his instance...

  • bruzlibruzli Member, LIR

    tables are innodb probably and he needs a sql dump from those files
    send me a pm if this was not solved yet

  • DamianDamian Member

    .frm is myisam, you should be able to associate these with a new MySQL installation and read from them.

    ibdata1, logfile0 and logfile1 are structure files; it's not really possible to restore data from them without the associated tables.

    Thanked by 1netomx
  • MikePTMikePT Moderator, Patron Provider, Veteran

    I can try... But that'll take quite a few time.

  • MikePTMikePT Moderator, Patron Provider, Veteran

    @Damian said:
    .frm is myisam, you should be able to associate these with a new MySQL installation and read from them.

    ibdata1, logfile0 and logfile1 are structure files; it's not really possible to restore data from them without the associated tables.

    Correct.

  • exception0x876exception0x876 Member, Host Rep, LIR

    @Damian said:
    .frm is myisam, you should be able to associate these with a new MySQL installation and read from them.

    ibdata1, logfile0 and logfile1 are structure files; it's not really possible to restore data from them without the associated tables.

    both statements are wrong. frm is table definition file, it is used for both MyISAM and InnoDB

    ibdata is used to store actual data in case file_per_table is set to 0

    Thanked by 1raindog308
  • bruzlibruzli Member, LIR

    was using ibdata, 2 db recovered

    Thanked by 3Caster badpatrick kkrajk
  • LevelSideLevelSide Member

    Was this solved?

  • CasterCaster Member

    Bruzli fixed it . The real MySQL MVP :)

Sign In or Register to comment.