Thursday, December 29, 2011

How to Restore MySQL database from Program files?


In this article, we will discuss about a scenario wherein a database administrator has tape backup of C drive only and production server had compromised by virus attack which was hosted in a third party hosting company. It is very frustrating for every database administrator if they have not schedule MySQL database export to a SQL backup file.

Tuesday, December 27, 2011

Perform Backup & Restore On MySQL Database Table



Database administrator can use Backup Table syntax for backup and Restore Table syntax for restore MySQL database table. First we will know about how to take a backup of MySQL database table then after how to restore MySQL table from backup created using Backup Table syntax.

Tuesday, December 13, 2011

Repercussions of InnoDB table corruption and MySQL database recovery

MySQL incorporates a blend of advanced features to offer users a performance-driven and a fully-integrated transaction-safe database. It has excellent capabilities to enable you manage any large database environment. You can use the Query Analyzer to keep a check on query performance and identify the faulty SQL code that is causing a slowdown. Some of its most distinguished features include, crash recovery, roll back, full commit, and row-level locking capabilities. Despite being so much reliable and consistent, this database is prone to corruption. MySQL corruption generally occurs due to improper server shutdown, operating system malfunction, metadata structure damage, etc. As a consequence, all vital database objects become inaccessible. To overcome this problem, you need to go for MySQL database recovery through a proficient third-party utility.