2TR

Posts Tagged ‘table

. 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

. 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

MySQL Table corruption post Migration to MySQL5

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

. 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

MySQL table Repairing process Halts  

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