Hi there,

I'm new to Plesk and recently performed an install of Plesk 8.1.0 on a FedoraCore 2 server previously running Plesk 7.5.4

After the install and some tweaking of the psa httpsd.conf file, I now have Plesk responding to a browser request on https://localhost:8443.

However, with every attempted access, I receive a error of the type - " PleskMainDBException occured with the following message

MySQL query failed: Can't open file: 'module exp_event.ibd' (errno: 1) "

This was the initial error instance.

Listing the /var/lib/mysql/psa directory showed a file named exp_event.frm.

An online forum post suggested that I fix this by creating the table using MySQL.

The MySQL 'SHOW CREATE TABLE ... ' command reproduces the same error message provided by the PleskMainDBException.


After some problems (conflicting "table already exists"/table does not exist" status messages from MySQL,

I eventually succeeded by renaming the .frm file, which then allowed MySQL to re-create the corresponding table.

Plesk then no longer displayed that particular error.

My issue is that I now have a cascade of these messages relating to other tables - there are .frm files for each one in the /var/lib/mysql/psa directory - but there are NO MyISAM (.MYD or .MYI) files however.

It appears that I may have a MySQL/InnoDB databse format problem - how can I fix this?.

Can I convert .frm files to .ibd files? Or configure Plesk to use .frm files only? or must I continue to create these tables manually?

The /etc/my.cnf file DOES contain the line;

innodb_data_file_path=ibdata1:10M:autoextend

adding the line;

innodb_file_per_table

appeared to have no effect when restarting the mysqld service.

Thank-you


Simon G