User:Siebrand/test: Difference between revisions

From KDE UserBase Wiki
(Created page with '{{input|Testing input}}')
 
No edit summary
 
(9 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{input|Testing input}}
=== 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:
:::{{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}}

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