"The mind of a Mad Tech!"

The InnoDB requires access to specific files, that if are corrupted, will cause the InnoDB engine to fail to load. You will know if the InnoDB fails to load if you acess MySQL and run the following command;

show engine innodb status;

The output will be the following;
ERROR 1235 (42000): Cannot call SHOW INNODB STATUS because skip-innodb is defined

However the fix is to locate the following files in /var/lib/mysql/. Be sure to stop MySQL first before changing the files;

ib_logfile0

ib_logfile1

You can remove both the files by running the following commands. Again, be sure to stop MySQL first;

mv /var/lib/mysql/ib_logfile0 /var/lib/mysql/ib_logfile0.bak

mv /var/lib/mysql/ib_logfile1 /var/lib/mysql/ib_logfile1.bak

(Your MySQL pathing may vary, we are using the default MySQL install paths in this article).

After removing these files, start up MySQL;

Service mysql start or Service mysqld start.

Once the MySQL instance is started, the InnoDB will also be started as well.

Tags: innodb, MySql

There are two ways to add a mime type to a Linux server. You can either add the mime type to the server mime type listing or you can specify a mime type via an .htaccess file in a individual hosting account. This article will explain how to do both.

Method 1.

1. Log into the Linux server via SSH.
2. Open the “/etc/mime.types” file using a text editor.
3. Add the new mime type into the end of the “/etc/mime.types” file and save it.
4. Restart Apache by typing either of the following commands;

“service httpd restart”

“/etc/init.d/httpd restart”

Method 2.

1. Loging the Linux server via SSH.
2. Navigate to the account that you wish to add the mime type. You will need to be in the web accessible portion of the account.
3. Either create or modify the existing “.htaccess” file and add the mime type entry and save the file.
4. Restart Apache by typing either of the following commands;

“service httpd restart”

“/etc/init.d/httpd restart”