by Visakh S | Jun 30, 2015 | MySQL, Server Management
Server crashes could leave databases in inconsistent states. While there are many tools available to repair MYISAM tables in MySQL, InnoDB repair is not always so straightforward. MySQL could refuse to start up, leaving you with in-determinate downtime. If your MySQL...
by Visakh S | Jun 16, 2015 | MySQL, Server Administration
In VPS and dedicated servers, especially in those running high traffic websites, MySQL server sometimes fails to respond with the error [ERROR] /usr/sbin/mysqld: Incorrect key file for table ‘/tmp/#XXXXX.MYI’; try to repair it. This often leads to a...
by Visakh S | Jan 8, 2015 | cPanel, FTP, MySQL, Technical Support
cPanel logs provide a goldmine of information to quickly resolve various customer issues and server errors. Here’s a list of the cPanel logs most commonly used by our expert server administrators, and the commonly sought information in them. cPanel mail logs...
by Hamish Oscar Lawrence | Oct 6, 2011 | cPanel, MySQL, Server Administration
Managing a database and its user is a simple task, when done from within cpanel. Creating a Database, assigning the DB user, and associated privileges.. all are covered in this quick...
by Hamish Oscar Lawrence | Dec 8, 2010 | MySQL, Server Administration
Most of us are familiar with LAMP, the most popular free/open source solution stack in use today. There is an, not as popular, alternative that database intensive site owners might be interested in: LAIP. While LAMP stands for Linux, Apache, MySQL and PHP; LAIP swaps...
by Hamish Oscar Lawrence | Nov 22, 2010 | MySQL, Server Administration
The MySQL replication team have been hard at work improving the features of MySQL replication. In this part, I’ll be talking about a few more features included in MySQL 5.5 Automatic Relay Log Recovery If this features is enabled, when a Slave recovers from a...
