Naveen Kadian

Recovering a corrupt InnoDB table in MySQL

The MySQL database is one of the most used database engines in the world. The reasons behind this are - apart from being an open sourced database - its scalability, flexibility, high availability, ability to carry out robust transactions, and so on. Howe... Read >

MySQL Log Displays Error 126

MySQL log is the best way to identify the problems encountered by MySQL user while starting, closing, or running MySQLD (MySQL Server). These log files are saved in MySQLD data directory and can be erased using FLUSH LOGS command. The information saved in... Read >

Resolving InnoDB Error 'The tablespace free space info is corrupt'

InnoDB is a MySQL storage engine and is considered more reliable over its counterparts for the main reason that it supports ACID transactions. InnoDB can recover from problems like unexpected shutdown by replaying the log files. But irrespective of these ... Read >

Recovering MySQL database after abrupt system shutdown

MySQL database, because of its fast performance, high reliability, and ease of use, is the world's most used open source database. If you combine all these features with the open source database feature, you have got all the ingredients of a complete rela... Read >

Recovering corrupted MyISAM file in MySQL 5.0

MySQL is one of the most popular open-source database in the world. The reasons for this is its availability, performance, sound transactional support, etc. It offers three types of database engines, MyISAM, InnoDB, and MySQL Archive. The MyISAM table is ... Read >

Resolving “Incorrect key file for table..” Error in MySQL

In MySQL relational database management system, you can use different storage engines for effective storage and management of your data. MyISAM is a default storage engine in MySQL, which is based on older ISAM code. However, it has several useful extensi... Read >

Wrong Query Results Post MyISAM Table Corruption

MySQL server is mainly known for its stability and security. However, like any other application, MySQL can crash due to various reasons like, power failure, operating system malfunction, and virus hits. In most cases of MySQL server crash, the database t... Read >

Fixing InnoDB Database Page Corruption

MySQLD (MySQL Sever) crash can occur when it accesses or encounters a corrupt InnoDB database page. In most cases of MySQLD crash, the database becomes unmountable, rendering to inaccessibility of all its saved records. In addition, the server exhibits an... Read >

Recovering MySQL database from the ERROR 1146 (42S02) error

MySQL is a relational database management system (MySQL) that acts as a server providing multi-user access to many databases. It is used by some very high-traffic websites like Flickr, Facebook, Wikipedia, Google, Nokia, YouTube, etc. MySQL is preferred b... Read >

Rectifying “Error No. 1033” in MySQL

Are you unable to access a MySQL database table? Is your MySQL database table inaccessible after upgrading to later version of the application? This behavior may occur due to corruption of MySQL table. After corruption, MySQL can not read the table and th... Read >

Error Logs Displaying “Got an error from...” Message

Whenever you start MySQL Server (MySQLD), it automatically checks all the tables stored in your MySQL database. The server also repairs the table if it is marked as 'crashed' or 'not closed properly'. However, before repairing the table, MySQLD creates a ... Read >

Crash Recovery Failed to Repair Corrupt InnoDB Database

MySQL is considered to be the most stable application that is used to create and maintain databases. However, there are still certain problems that are encountered, like the application might crash and result in corruption of database. Such situations occ... Read >

MySQL Database Corrupted Post Upgrading to 5.0.27

Upgrading to a newer MySQL version is primarily done to take benefit of all the improved features of its newer versions. This helps you to increase the database performance, add to safety, and allows accessing quick results. But it is always recommended t... Read >

InnoDB Tables Locked Post MySQL Database Damage

MySQL database corruption can result in fatal consequences, leading to inaccessibility of records saved in database components, like tables. Few most common reasons for corruption could be improper shutdown of the system/MySQLD, concurrent modification of... Read >

Rectifying 'NTDS ISAM 467' Error in MySQL

Are you getting error 'NTDS ISAM 467 database corruption' error while accessing MySQL database tables? This problem generally occurs with Windows 2003 Server domain controllers. It indicates MySQL database corruption and renders all your valuable data ina... Read >