Archive for the 'MySQL' Category

Quick Tip: Installing MySQL on Fedora Linux

Installing MySQL on Fedora has never been easier than before. If you are a first timer who wants to know how to install MySQL on a Fedora server or desktop, follow this guide to successfully install both MySQL client and server only in three steps.

Before you proceed to the installation, the environment settings for the snapshot pictures of the installation are provided below:
OS: Fedora 13 64-bit
Prerequisites: yum is installed, commands invoked on root shell
Continue reading

MySQL 5.0: Recovering Crashed/Corrupted InnoDB Database

restore crashed InnoDBIf you are a frequent user of transactional database feature in MySQL, you must be familiar with InnoDB storage engine. Along with BDB, InnoDB provides transaction safe database within MySQL environment.

Nobody wants bad thing happens although it often does. Sometimes, power outage or internal system malfunction or even human error makes the database crashed or corrupted. This article will provide steps taken to recover corrupted InnoDB database based on real crash course experience within *NIX environment.

Continue reading