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 system may ask you to connect your device or resta
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 that restart your Liferay server and your gloroot will start on default
Read more

How to Change Mac Address in XP

Image
For Windows XP Users Step -1 Windows XP  Users Navigate to  Control Panel (Classic View) > Network Connections Step -2 Select and right click on your network connection, and then click Properties. Step – 3 Click and select local area connection properties  Configure  button as illustrated below. Step – 4 Select the  advanced  tab (highlighted in red) as shown below. Step – 5 Under advanced tab, Select Network address Properties and enter the custom 12-digit hexadecimal number (Custom MAC ID) ranging between 0000 0000 0001 – FEFF FFFF FFFF (without spaces) as shown below and click  OK . (In this tutorial, we used FEFEFEFEFE as Custom MAC ID) All done. The New MAC ID assigned as  FEFEFEFEFE  in your Windows XP computer. If you wish to revert back default MAC ID in feature, do the same steps illustrated above and select Not Present radio button and click  OK  button. So, the default MAC ID will be restored.
Read more