MySQL Forums
Forum List  »  Newbie

error: 1033: Incorrect information in file:
Posted by: OSS Shehab
Date: February 09, 2014 10:06AM

Hi,
I need help with this error please.
I restarted mysql on the server and after I did that my joomla sites on it started giving this error
Error displaying the error page: Application Instantiation Error
So I looked around and found that this could be a corrupted database so I did a restore from backups but all giving same error. And repairing the databases is giving also corrupt error in .frm files even if I try to repair a working database it gives this error on few of the tables so I searched around and found that this error might be cause by my.cnf config error and since I am not an expert I need to know if this could be the case if so this is my file and I hope anyone can point me to fixing this error.

[mysqld]
local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
# Forced OLD_PASSWORD format is turned OFF by Plesk
#old_passwords=1
# Disabling symbolic-links is recommended to prevent assorted security risks;
# to do so, uncomment this line:
# symbolic-links=0
set-variable=max_connections=400
#innodb_force_recovery = 4
innodb_data_home=/var/lib/mysql
innodb_data_file_path=ibdata1:235M;ibdata1:100M:autoextend

innodb_buffer_pool_size=2M
innodb_additional_mem_pool_size=500K
innodb_log_buffer_size=500K
innodb_thread_concurrency=2

[mysqld_safe]
innodb_data_home=/var/lib/mysql
innodb_data_file_path=ibdata1:235M;ibdata1:100M:autoextend
innodb_buffer_pool_size=2M
innodb_additional_mem_pool_size=500K
innodb_log_buffer_size=500K
innodb_thread_concurrency=2
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid


Thank You

Options: ReplyQuote


Subject
Written By
Posted
error: 1033: Incorrect information in file:
February 09, 2014 10:06AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.