13 Feb, 2012
Posted by: you In: Sql
. Delete Operation resulting in MySQL Table corruption Article by Naveen Kadian
As the name suggests, Delete statement is used to delete selected or all rows from the table. The statement also returns a count of all the rows deleted by the user. However, the user always needs a delete privilege to perform delete [...]
Comments Off
27 Jan, 2012
Posted by: you In: Sql
. Repairing Error 8926 to Fix Table Corruption Issues in MS SQL Server 2000 Database Article by Mark Willium
Are you getting a table related error in MS SQL Server 2000? In all probability, it may have happened because of incorrect page definitions on the database. Such database corruption can be caused because of [...]
Comments Off
11 Dec, 2011
Posted by: you In: Sql
. MySQL Table corruption post Migration to MySQL5 Article by Naveen Kadian
With the newer versions of MySQL coming into the market, it becomes obvious for the database users to migrate to the new version. Migration primarily allows you to use the additional functionalities of the new version. Few additional functionalities could be increased [...]
Comments Off
04 Sep, 2011
Posted by: you In: Sql
. Killing INSERT… SELECT Can Corrupt MySQL Table on MyISAM Article by Naveen Kadian
The MySQL INSERT… SELECT command allows you to insert several rows into a table from various tables. But at times, when you kill the command on MyISAM, you observe that the table [...]
Comments Off
03 Aug, 2011
Posted by: you In: Sql
. MySQL table Repairing process Halts Article by Naveen Kadian
A severely corrupted MySQL database table is always difficult to repair. Corruption in table not only stops the database to mount, but also makes the records saved in the table inaccessible. Few major causes for severe [...]
Comments Off