User:Siebrand/test: Difference between revisions

Latest revision as of 16:37, 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_table=1'

[ERROR] Aborting

Try adding:

#sql_mode=strict_trans_tables <- Add underneath this line

#plugins
plugin_dir=usr/lib/mysql/plugin < - This may be a different path

plugin-load=ha_innodb.so

@@ Line 1: / Line 1: @@
-{{input|Testing input
+=== mysqld: unknown variable 'innodb_file_per_table=1' ===
-More input}}
+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|1=[ERROR] /usr/libexec/mysqld: unknown variable 'innodb_file_per_table=1'
+[ERROR] Aborting}}
+Try adding:
+:::{{Input|1= #sql_mode=strict_trans_tables <- Add underneath this line
+ #plugins
+ plugin_dir=usr/lib/mysql/plugin < - This may be a different path
+ plugin-load=ha_innodb.so}}