Author "Manya757" Page

Author Nick: Manya757
Site:


Author Articles List:

Sort by:

How to recover corrupted MyISAM file in MySQL 5.0

MySQL is one of the most popular open-source database in the world. The reasons its popularity is its availability, performance, robust transactional support, etc. It offers three types of database engines, MyISAM, InnoDB, and MySQL Archive wherein the MyISAM table is the default table type that is fast, simple to use, and allows full-text searching. [...]

How to Prevent Block Corruption in Oracle?

When corruption occurs in Oracle database or DBF file, it typically hits Oracle database block on hard drive or in memory. The memory damages are handled with operating system and Oracle kernel detection mechanism. It isn’t a perfect solution in all cases; sometimes, even the good memory blocks are set as corrupt. Disk corruptions are [...]

Repairing MySQL database when the table gets crashed – Error 145

The MyISAM database engine is the default database engine for MySQL database. It provides a variety of indexing and field management functions. Its ability to swiftly perform the read operations on the databases is one of the biggest reasons of MySQL being so popular as a backend for Web applications. However, sometimes the MyISAM database [...]

Repairing corrupt MySQL database when you encounter “MySQL server has gone away” error

MySQL is an open source database that has got a fair amount of users all over the world. It is fast, secure, reliable, and easy to use. Apart from being the most used open source database, it is an excellent option for the applications built on the LAMP (Linux, Apache, MySQL, PHP/Perl/Python) platform. It efficiently [...]

Resolution Tips for MS Access Error 3011

A Microsoft Access database comprises of various objects such as tables, queries, macros, modules, and more. When opening a Microsoft Access database, you may observe several errors indicating that one or more database objects have gone corrupted. Here we discuss one such common error along with its reasons, and some simple access database recovery tips [...]