Naveen Kadian

name

Recovering a corrupt InnoDB table in MySQL

17th May 2010
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. Howev... Read >

MySQL Log Displays Error 126

14th May 2010
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'

11th May 2010
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 >

Resolving Incorrect key file for table - Error in MySQL

04th May 2010
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 >

Fixing InnoDB Database Page Corruption

29th April 2010
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

29th April 2010
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 'NTDS ISAM 467' Error in MySQL

15th April 2010
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 >

Resolving “Incorrect information...” Error

13th April 2010
An error message while opening an InnoDB database table occurs when an InnoDB engine in unable to open the table. The two possible reasons for this could be corruption or missing of that particular database table. In situations where the table is missing,... Read >

Resolving Error 1146 Post InnoDB Table Corruption

08th April 2010
Corruption in InnoDB table results in an error message, which renders all stored records inaccessible. Few main causes for InnoDB table corruption are unexpected MySQL Server shutdown, virus infection, and MySQL bugs. To overcome this error message, a dat... Read >

SQL Database Corruption If You Shrink The Database When It Is Use

22nd March 2010
In MS SQL Server, you can shrink tempdb database to a size smaller than last configuration of the database. There are various methods that you can use to remove the unused pages of the database and reduce its size. You can also shrink the individual files... Read >

Resolving MySQL Error- “Page Directory corruption: supremum not pointed to”

12th March 2010
MySQL is a widely used RDBMS (Relations Database Management System), which uses two different storage engines- InnoDB and MyISAM. InnoDB is included as a standard storage engine in all modern binaries, which are distributed by MySQL AB. It has ACID (Atomi... Read >

Missing or Deleted .frm File May Cause Table Corruption in MySQL

04th March 2010
MySQL Server database stores data dictionary information in the .frm files that it stores in database directories. On the other hand, InnoDB storage engine keeps information in individual data dictionary in tablespace files. When you move the .frm file or... Read >

MySQL Recovery for InnoDB Storage Engine to Fix Tablespace Corruption

26th February 2010
Are you encountering assertion failure errors in MySQL database? Are you unable to access your MySQL database due to corrupt InnoDB Tablespace? Such situations occur due to MySQL database corruption. This behavior renders your MySQL database inaccessible.... Read >

How To Recover Corrupted/Crashed InnoDB Database?

23rd February 2010
Are you a frequent user of the transaction database characteristic in MySQL? If 'Yes', then you must be quite familiar with the InnoDB storage engine of MySQL. InnoDB offers transaction safe database, along with the BDB, within MySQL environment. However,... Read >

How to Fix Master Database Corruption in MS SQL Server

18th February 2010
In Microsoft SQL Server, all the system-level data/information are stored in a Master database. It includes the instance-wide meta data like logon accounts, linked servers, system configuration settings, and endpoints. Furthermore, master database records... Read >
1 2 3 4