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.
Thursday, December 29, 2011
Tuesday, December 27, 2011
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
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.