User:Siebrand/test: Difference between revisions

From KDE UserBase Wiki
No edit summary
No edit summary
Line 1: Line 1:
=== mysqld: unknown variable 'innodb_file_per_table=1' ===
=== mysqld: unknown variable 'innodb_file_per_table=1' ===
If the MySQL server log contains the following error, then your MySQL server was built without the InnoDB support which is required by '''Akonadi''' or '''InnoDB''' needs to be loaded in your ''mysql.conf'' file:
If the MySQL server log contains the following error, then your MySQL server was built without the InnoDB support which is required by '''Akonadi''' or '''InnoDB''' needs to be loaded in your ''mysql.conf'' file:
:::{{Output|[ERROR] /usr/libexec/mysqld: unknown variable 'innodb_file_per_table=1'
:::{{Output|[ERROR] /usr/libexec/mysqld: unknown variable 'innodb_file_per_table1'
[ERROR] Aborting}}
[ERROR] Aborting}}


Try adding:
Try adding:
:::{{Input|plugins
:::{{Input| #sql_modestrict_trans_tables <- Add underneath this line
plugin-load=ha_innodb.so}}
#plugins
plugin_dirusr/lib/mysql/plugin < - This may be a different path
plugin-loadha_innodb.so}}

Revision as of 16:33, 27 June 2010

mysqld: unknown variable 'innodb_file_per_table=1'

If the MySQL server log contains the following error, then your MySQL server was built without the InnoDB support which is required by Akonadi or InnoDB needs to be loaded in your mysql.conf file:

[ERROR] /usr/libexec/mysqld: unknown variable 'innodb_file_per_table1'

[ERROR] Aborting

Try adding:

 #sql_modestrict_trans_tables <- Add underneath this line
#plugins
plugin_dirusr/lib/mysql/plugin < - This may be a different path

plugin-loadha_innodb.so