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


Shells Virtual Desktop
BMail.ag - Secure Email Service
Server.net
CPLicense.net
VPS Server
Buy VPN
Vultr
VMs for AI
HostDare
ReliableSite White-Label Dedicated Hosting for Resellers
InterServer VPS
BMail.ag - Secure Email Service
Best VPN
High-Performance Bare Metal Server Solutions
Karvl.com
Server Mania Cloud Hosting
DataWagon Hosting
AlphaVPS Hosting
Evoxt.com
Clouvider
VPS Hosting with NVMe
Residential IPs in the US & 4G Mobile Proxies in EU & US with Unlimited Bandwidth
ReliableSite White-Label Dedicated Hosting for Resellers
Rabisu - Hosting Solutions
Shells Virtual Desktop

Categories

In this Discussion

Home › Requests
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 Veteran

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

  • MikePTMikePT 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.