User:Siebrand/test: Difference between revisions
No edit summary |
No edit summary |
||
| (One intermediate revision by the same user not shown) | |||
| 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|1=[ERROR] /usr/libexec/mysqld: unknown variable 'innodb_file_per_table=1' | ||
[ERROR] Aborting}} | [ERROR] Aborting}} | ||
Try adding: | Try adding: | ||
:::{{Input|plugins | :::{{Input|1= #sql_mode=strict_trans_tables <- Add underneath this line | ||
plugin-load=ha_innodb.so}} | #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