Restore Database from .idb & .frm files in MySQL

 

Prerequisites:

               Backup of .ibd and .frm files: Ensure you have all the relevant .ibd (InnoDB data files) and .frm (table definition files) for the tables you want to restore.

MySQL Server: Ensure you have a running instance of MySQL server where you want to restore the database.


Step 1: Stop Current Running MySQL Service

Step 2: Copy ibdata1, ib_logfile0 and ib_logfile1 files from Old Mysql forlder Which is exist (C:\ProgramData\MySQL\MySQL Server x.x\Data).
 
Step 3: Copy your Database Folder which you want to restore and paste into your current mysql instance data folder.
 

Step 4: Change the configuration of my.ini file Add –innodb_force_recovery=6 after the [mysqld] (please search inside my.ini file [mysqld]).


Step 5: Start the mysql service.

Step 6: After recovering the database please remove the line innodb_force_recovery=6 from my.ini configuration and restart again mysql service.

 


Comments

Post a Comment

Popular posts from this blog

How to Get Back Asus Zenphone 5 from Soft Brick

Image
Dear Folks, Very Warm Welcome, Now I'm Writing this post for those who have facing hard bricked problem in #AsusZenphone5. Before some days same problem i have faced and i was fully fade up with my phone and i go too many shops for  repairing the phone but they charged too much for this. then i decided too solve it. So when your phone is in USB Logo mode or Asus Logo Mode Then it's confirmed your phone has been bricked. So, let’s start! There are some files, please prepare to download :   IntelAndroidDrvSetup1.5.0.exe Asus USB Driver. Download  here  Asus Zenfone 5 RAW firmware. Download   here   xfstk-downloader-setup-1.5.1.exe   iSocUSB-Driver-Setup-1.0.4.exe Recovery Image. Download  here ADB + Fastboot. Download  here Instruction :  install above driver as per ranking. follow these instruction while installing: Right click on setup Select run as administrator  Note  : while installing isoc drive...
Read more

How to configure Glowroot with Liferay

Image
 Dear Folks, First of all we need to know what is Glowroot and what can we get from it. Features Trace capture for slow requests and errors Continuous profiling (with very handy filtering) Response time breakdown charts Response time percentile charts SQL capture and aggregation Service call capture and aggregation MBean attribute capture and charts Configurable alerting Historical rollup of all data (1m, 5m, 30m, 4h) with configurable retention Full support for async requests that span multiple threads Responsive UI with mobile support Optional central collector Step 1: Download Glowroot from Official website and extract that zip into your drive (                     Like: C:\glowroot). Now open your Liferay workspace and in the Servers tab double click on your server and click on the Browse External properties button and write your glowroot file path with javaagent. (Ex:-  -javaagent:path/to/glowroot.jar) After tha...
Read more