Jump to content
EwinRacing Flash Series Gaming Chairs
Sign in to follow this  
jaimebentez

MySQL recovery from restored files

Recommended Posts

After a server issue, my client has restored the MySQL files before their issue, but MySQL is having problems bringing their database back up. (i'm waiting for more information as the exact nature of the issue)

I have the ibdata1 ib_logfile0, and ib_logfile1files, and all the .frm and .ibd files for all the tables.  I can open the database using Navicat, but when trying to open individual tables the first attempt shuts down the MySQL service and after restarting it, table access attempts returns a message that the table doesn't exist.

I've uploaded the section of the error log from my last attempt to access the database.

I've contacted percona and am aware of their tools, and services, but was hoping someone could give me a little more insight to my issue, and if there is a way to restore this database that isn't a major time consuming pain in the butt. :)

Thanks,

Server issue specifics:

The server crash was the result of a power surge, which took out the SATA and RAID controllers. It also completely damaged one drive (there were 2 drives mirrored in RAID1 as dynamic disks). The other drive was only partially damaged, and it is from this drive that we extracted the files that we have from the mysql data directory (that is the "afriplexqms" directory you're seeing).

However, we also have a manual backup set, which is in the root of the D:\IRENE\TLM folder (in the form of 342 .sql files).

 

MySQL-Error-LogQ4.rar

Edited by jaimebentez

Share this post


Link to post
Share on other sites

When the DB was "restored," Did the user restore from the filesystem backups?

If you have the SQL files dumps, you should try restoring that data on a separate system where you can install MYSQL if not installed and restore them from the sql dumps,

Hopefully, you have the DB/table create as part of the SQLs and the sql backups are recent enough.

The only time a filesystem mysql backup will be valid is when mysql is not running when the backup is taken/made/created. If you have no opportunity to do recovering files that way, then I can advise to try to take MySql Recovery Toolbox and restore  file using this tool and think you will be able to save your base. http://www.oemailrecovery.com/mysql_recovery.html

You can still read this resource for more information on your issue.

https://community.office365.com/en-us/f/172/t/266451

  • Thumbs Up 2

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Similar Content

    • By Mr. Fox
      Woman Wins $10,000 From Microsoft After Unwanted Windows 10 Upgrade
      Good for her! She deserves it based on their bad behavior. Too bad the award doesn't have 5 or 6 more zeroes to the left of the decimal point. The Redmond Mafia needs to learn a lesson for their bad behavior, and that tiny little slap on the wrist will only represent a minor inconvenience to them. They deserve to draw back a bloody stump.
       
      Unfortunately, the wickedness of Micro$loth knows no boundaries. They think they own us and our computers. This is what I use to kill all of the spyware and telemetry trash in Windows 10, block all updates and permanently expunge all of the bloatware apps and Windows Store garbage. It also kills and deletes OneDrive and disables (rather than only muting) UAC. Works great... very nice tool IMHO. 
       
      Destroy Windows Spying
       
      I have also found third-party tweaks to replace the hideous giant calculator with the older version, completely kill the obnoxious Security Center nag-o-rama and exterminate Cortana. 
       
      Notwithstanding the tacky-looking aesthetics that remain (nasty abuse of white and pastel colors akin to the Windows 8.X abortion) it's fairly decent if you go to enough trouble to correct all of their mistakes. Performance in some things is still inferior to Windows 7, unfortunately. I pointed that out as an 'Insider' quite some time ago, but they apparently do not plan to fix it. They started hindering CPU performance in Windows 8.X and they must think it's OK since they are leaving it messed up from then until now.
    • By StamatisX
      Microsoft is planning to acquire the London-based AI powered predictive keyboard manufacturer for around $250M. The UK start-up company founded in 2008 by Jon Reynolds and Ben Medlock, is installed on hundreds of millions of smartphones across the globe and has more than 150 employees in London, San Francisco and Seoul.

      Swiftkey, which is considered by its founders as a language technology company, is offering the app free for download in both Android and iOS devices since 2014.  It supports more than 100 languages and uses artificial intelligence in order to learn the writing style of its user and be able to predict the next word to be typed.

      This is not the only company Microsoft is trying to acquire in an effort to regain a foothold in mobile but neither it is for Google with DeepMind or for Apple with VocalIQ whose AI software helps computer and people converse more naturally.  

      Despite being installed on more than 300M devices and being on top of app chart as one of the most popular app, SwiftKey's selling price was lower than what investors might have hoped for a couple of years ago. 
       
       
       
       
      Source: Financial Times

      View full article
    • By StamatisX
      Microsoft is planning to acquire the London-based AI powered predictive keyboard manufacturer for around $250M. The UK start-up company founded in 2008 by Jon Reynolds and Ben Medlock, is installed on hundreds of millions of smartphones across the globe and has more than 150 employees in London, San Francisco and Seoul.

      Swiftkey, which is considered by its founders as a language technology company, is offering the app free for download in both Android and iOS devices since 2014.  It supports more than 100 languages and uses artificial intelligence in order to learn the writing style of its user and be able to predict the next word to be typed.

      This is not the only company Microsoft is trying to acquire in an effort to regain a foothold in mobile but neither it is for Google with DeepMind or for Apple with VocalIQ whose AI software helps computer and people converse more naturally.  

      Despite being installed on more than 300M devices and being on top of app chart as one of the most popular app, SwiftKey's selling price was lower than what investors might have hoped for a couple of years ago. 
       
       
       
       
      Source: Financial Times
    • By Brian
      Even as Microsoft's newest CEO Satya Nadella tries to steer the company back into relevance by attempting to unify Microsoft notebook, desktop, tablet and smartphone platforms under the "One Microsoft" structure devised by his predecessor Steve Ballmer, most consumers and developers don't seem to care and the company appears destined to fall into obscurity.
       
      While it currently dominates the desktop market, it's newest and greatest hope in achieving the "One Microsoft" vision is Windows 10 and at the end of 2015, it barely had climbed to 10% share despite Microsoft's strong marketing push by giving it away for free. In fact, Windows 7 still retains 55% of the desktop OS market with consumers and developers alike perfectly content to stay where they are. 
       
      According to Forbes, Microsoft is now changing tactics by attempting to scare consumers into upgrading to Windows 10 by telling them Windows 7 has potentially serious security risks and hardware compatibility issues. In speaking to Windows Weekly, Microsoft Marketing chief Chris Capossela said that users who continue on with Windows 7 do so "at your own risk, at your own peril". Forbes Gordon Kelly notes that Microsoft's statements about Windows 7 amount to "complete rubbish" as Windows 7 will be supported until 2020 and with its greater market share vs Windows 10, it is guaranteed to receive more developer attention--which includes security patches and driver updates. Microsoft's motives are fairly transparent as it has a stated goal of one billion devices running Windows 10 within 2-3 years of it's release and with Windows 10 adoption seemingly faltering, they are getting desperate. 
       
      To make things worse, Vox has an article with a very interesting graph created by Joshua Kunst which illustrates Microsoft losing significant ground among developers since 2008. He made the graph by tracking popular tags on Stack Overflow, a popular forum where many developers hang out and answer programming questions. 
       

       
      Looking at this chart, going back to 2008 when Stack Overflow was founded, it becomes clear that Microsoft backed programming languages and applications have declined: C#, .NET, ASP.NET, SQL all lost ground, yet competing alternatives such as PHP, MYSQL, JavaScript gained significantly. JavaScript owes part of its rise thanks to Android which uses it as the main language for Android apps. 
       
      In the gaming market, Xbox One started off with a faulty strategy of attempting to force users into purchasing their Kinect device while their competitor Sony produced a more powerful system that did not have similar bundling restrictions. Microsoft eventually backed off but it seems to be too late as Sony's PS4 now holds a dominant lead over Xbox One despite Microsoft's best efforts. 
       

      (image credit: Ars Technica)
       
      So will Microsoft be able to turn around its misfortunes? Maybe if Windows 10 has a drastic turn around in 2016 with more developers getting on board, it is possible but as of right now, the future doesn't seem too bright. 
       

      View full article
    • By Brian
      Even as Microsoft's newest CEO Satya Nadella tries to steer the company back into relevance by attempting to unify Microsoft notebook, desktop, tablet and smartphone platforms under the "One Microsoft" structure devised by his predecessor Steve Ballmer, most consumers and developers don't seem to care and the company appears destined to fall into obscurity.
       
      While it currently dominates the desktop market, it's newest and greatest hope in achieving the "One Microsoft" vision is Windows 10 and at the end of 2015, it barely had climbed to 10% share despite Microsoft's strong marketing push by giving it away for free. In fact, Windows 7 still retains 55% of the desktop OS market with consumers and developers alike perfectly content to stay where they are. 
       
      According to Forbes, Microsoft is now changing tactics by attempting to scare consumers into upgrading to Windows 10 by telling them Windows 7 has potentially serious security risks and hardware compatibility issues. In speaking to Windows Weekly, Microsoft Marketing chief Chris Capossela said that users who continue on with Windows 7 do so "at your own risk, at your own peril". Forbes Gordon Kelly notes that Microsoft's statements about Windows 7 amount to "complete rubbish" as Windows 7 will be supported until 2020 and with its greater market share vs Windows 10, it is guaranteed to receive more developer attention--which includes security patches and driver updates. Microsoft's motives are fairly transparent as it has a stated goal of one billion devices running Windows 10 within 2-3 years of it's release and with Windows 10 adoption seemingly faltering, they are getting desperate. 
       
      To make things worse, Vox has an article with a very interesting graph created by Joshua Kunst which illustrates Microsoft losing significant ground among developers since 2008. He made the graph by tracking popular tags on Stack Overflow, a popular forum where many developers hang out and answer programming questions. 
       

       
      Looking at this chart, going back to 2008 when Stack Overflow was founded, it becomes clear that Microsoft backed programming languages and applications have declined: C#, .NET, ASP.NET, SQL all lost ground, yet competing alternatives such as PHP, MYSQL, JavaScript gained significantly. JavaScript owes part of its rise thanks to Android which uses it as the main language for Android apps. 
       
      In the gaming market, Xbox One started off with a faulty strategy of attempting to force users into purchasing their Kinect device while their competitor Sony produced a more powerful system that did not have similar bundling restrictions. Microsoft eventually backed off but it seems to be too late as Sony's PS4 now holds a dominant lead over Xbox One despite Microsoft's best efforts. 
       

      (image credit: Ars Technica)
       
      So will Microsoft be able to turn around its misfortunes? Maybe if Windows 10 has a drastic turn around in 2016 with more developers getting on board, it is possible but as of right now, the future doesn't seem too bright. 
       
×

Important Information

By using this site, you agree to our Terms of Use. We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.