Система: Virtual CPU 1600Mhz, 3072Mb memory, 32000Mb disk centos-6-i386-minimal Установил «1С-Битрикс: Веб-окружение» - Linux Установка прошла без ошибок.
А дальше началось: Пытаюсь установить модуль интернет магазина - получаю ошибку Can't cre ate table ......
Конфиг mysql:
# # The MySQL database server configuration file. # [client] port = 3306 socket = /var/lib/mysqld/mysqld.sock default-character-set = utf8 [mysqld_safe] socket = /var/lib/mysqld/mysqld.sock nice = 0
А вот что показывает в лог ошибок(это самый конец):
130123 12:28:23 InnoDB: Error creating file './sitemanager0/b_sale_person_type_site.ibd'. 130123 12:28:23 InnoDB: Operating system error number 17 in a file operation. InnoDB: Error number 17 means 'File exists'. InnoDB: Some operating system error numbers are described at InnoDB: http://dev.mysql.com/doc/refman/5.1/en/operating-system-error-codes.html InnoDB: The file already exists though the corresponding table did not InnoDB: exist in the InnoDB data dictionary. Have you moved InnoDB InnoDB: .ibd files around without using the SQL commands InnoDB: DISCARD TABLESPACE and IMPORT TABLESPACE, or did InnoDB: mysqld crash in the middle of CRE ATE TABLE? You can InnoDB: resolve the problem by removing the file './sitemanager0/b_sale_person_type_site.ibd' InnoDB: under the 'datadir' of MySQL. 130123 12:28:23 InnoDB: Error creating file './sitemanager0/b_sale_discount_group.ibd'. 130123 12:28:23 InnoDB: Operating system error number 17 in a file operation. InnoDB: Error number 17 means 'File exists'. InnoDB: Some operating system error numbers are described at InnoDB: http://dev.mysql.com/doc/refman/5.1/en/operating-system-error-codes.html InnoDB: The file already exists though the corresponding table did not InnoDB: exist in the InnoDB data dictionary. Have you moved InnoDB InnoDB: .ibd files around without using the SQL commands InnoDB: DISCARD TABLESPACE and IMPORT TABLESPACE, or did InnoDB: mysqld crash in the middle of CRE ATE TABLE? You can InnoDB: resolve the problem by removing the file './sitemanager0/b_sale_discount_group.ibd' InnoDB: under the 'datadir' of MySQL. 130123 12:28:23 InnoDB: Error creating file './sitemanager0/b_sale_viewed_product.ibd'. 130123 12:28:23 InnoDB: Operating system error number 17 in a file operation. InnoDB: Error number 17 means 'File exists'. InnoDB: Some operating system error numbers are described at InnoDB: http://dev.mysql.com/doc/refman/5.1/en/operating-system-error-codes.html InnoDB: The file already exists though the corresponding table did not InnoDB: exist in the InnoDB data dictionary. Have you moved InnoDB InnoDB: .ibd files around without using the SQL commands InnoDB: DISCARD TABLESPACE and IMPORT TABLESPACE, or did InnoDB: mysqld crash in the middle of CRE ATE TABLE? You can InnoDB: resolve the problem by removing the file './sitemanager0/b_sale_viewed_product.ibd' InnoDB: under the 'datadir' of MySQL.
Подскажите в чем проблема? Где, что надо исправлять? Заранее спасибо!
Если быть более точным при попытке установить любой модуль получаю вот такую ошибку : Error:Can't cre ate table 'sitemanager0.b_sec_iprule' (errno: -1)!
Точно такая же проблема. Поставил в my.cnf #innodb_file_per_table Но, проблема осталась. mysqld.log пустой Хотя нет, помогло, забыл перезагрузить mysql