How To Resolve Error “incorrect information in .frm file”

Published by admin on December 7, 2015

Zarafa is a client server application that is mainly designed to work in integration with Microsoft outlook. This application provides AJAX based email client web access and works on machines based on Linux operating system. Zarafa stores emails and other information like, personal address, contacts, appointments, and notes on server side. It uses MySQL database to save user’s mailbox and information. This database contains multiple tables in hierarchical structure to store and manage the data.

The storage engines used by Zarafa server for data storage and management purpose is InnoDB, it saves all the data in .frm and .ibadata file format. Any kind of corruption issue in these files makes the Zarafa server database completely inaccessible. Whenever you access such corrupted database, you might get some error message like,

 “Incorrect information in .frm file”

This error generally indicates problems with your storage engine. You may get confronted with this issue when you have altered or increased the size of your InnoDB logs.

Solutions To Fix This Error:

Manually:

For perfect fixing of this issue and repair MySQL database, you have to follow the given procedure:

Firstly, make backup of all the database files present in the directory ‘/var/lib/mysql/’.

You need to add ‘innodb force recovery’ option under ‘[MYSQLD]’

in the configuration file of MySQL, as this will allow you to make dump database.

To create dump of all of all the database follow these steps:

‘~# mysqldump -uadmin -p`cat /etc/psa/.psa.shadow` -A > dump.sql’

Stop mysqld and delete everything from ‘/var/lib/mysql/’ using:

‘~# rm -rf /var/lib/mysql/*’

Now, delete option ‘innodb_force_recovery’ from the MySQL configuration file.

Restart ‘mysqld’. This would help you recreate the ‘mysql’ database and the InnoDB engine database.

Use the dump for restoring the entire database.

 Automatically:

These errors will put you in an acute and distressing situation, which results you in data loss situation. If still you are unable to fix this issue then it means your Zarafa Server database is in big trouble and it’s only because its .frm file has gone corrupted and it’s not working properly. So the best way to fix this issue is to repair the corrupt or damaged Zarafa database file ( .frm) and that can be done easily using Zarafa Database Repair Tool.

With this amazing tool you can easily fix your damage (.frm) file and effectively restores its valuable mailbox items like emails, appointments contacts, calendars, notes, distributions lists.

STEPS TO RECOVER AND RESTORE DATA FROM CORRUPT .frm FILE

Step 1: Firstly, download, install and then open Zarafa repair tool.

Step 2: Select the file you want to repair and the tool will automatically connect MySQL server and an interface shown below will appear.

Step 3: Wait for some time and you will see a dialogue box with “User login information”, fill it up and press OK.

Step 4: The repair process will start soon and you will get messages in succession that shows progress in recovery.

Step 5: After completion of the process, follow the message displayed on screen.

1083 Total Views 1 Views Today