Как исправить ошибку mysql #1118 — Row size too large?

Question

[Togzi]

Пытаюсь установить бд с бэкапа для запуска сайта на локалхосте. При импорте получаю ошибку. Подскажите, как её можно исправить

Comments

[Александр]

Весь запрос покажите

[Togzi]

Александр, CREATE TABLE `b_user` ( `ID` int(18) NOT NULL AUTO_INCREMENT, `TIMESTAMP_X` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `LOGIN` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `PASSWORD` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `CHECKWORD` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `ACTIVE` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Y', `NAME` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `LAST_NAME` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `EMAIL` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `LAST_LOGIN` datetime DEFAULT NULL, `DATE_REGISTER` datetime NOT NULL, `LID` char(2) COLLATE utf8_unicode_ci DEFAULT NULL, `PERSONAL_PROFESSION` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `PERSONAL_WWW` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `PERSONAL_ICQ` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `PERSONAL_GENDER` char(1) COLLATE utf8_unicode_ci DEFAULT NULL, `PERSONAL_BIRTHDATE` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `PERSONAL_PHOTO` int(18) DEFAULT NULL, `PERSONAL_PHONE` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `PERSONAL_FAX` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `PERSONAL_MOBILE` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `PERSONAL_PAGER` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `PERSONAL_STREET` text COLLATE utf8_unicode_ci DEFAULT NULL, `PERSONAL_MAILBOX` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `PERSONAL_CITY` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `PERSONAL_STATE` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `PERSONAL_ZIP` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `PERSONAL_COUNTRY` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `PERSONAL_NOTES` text COLLATE utf8_unicode_ci DEFAULT NULL, `WORK_COMPANY` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `WORK_DEPARTMENT` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `WORK_POSITION` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `WORK_WWW` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `WORK_PHONE` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `WORK_FAX` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `WORK_PAGER` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `WORK_STREET` text COLLATE utf8_unicode_ci DEFAULT NULL, `WORK_MAILBOX` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `WORK_CITY` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `WORK_STATE` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `WORK_ZIP` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `WORK_COUNTRY` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `WORK_PROFILE` text COLLATE utf8_unicode_ci DEFAULT NULL, `WORK_LOGO` int(18) DEFAULT NULL, `WORK_NOTES` text COLLATE utf8_unicode_ci DEFAULT NULL, `ADMIN_NOTES` text COLLATE utf8_unicode_ci DEFAULT NULL, `STORED_HASH` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL, `XML_ID` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `PERSONAL_BIRTHDAY` date DEFAULT NULL, `EXTERNAL_AUTH_ID` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `CHECKWORD_TIME` datetime DEFAULT NULL, `SECOND_NAME` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `CONFIRM_CODE` varchar(8) COLLATE utf8_unicode_ci DEFAULT NULL, `LOGIN_ATTEMPTS` int(18) DEFAULT NULL, `LAST_ACTIVITY_DATE` datetime DEFAULT NULL, `AUTO_TIME_ZONE` char(1) COLLATE utf8_unicode_ci DEFAULT NULL, `TIME_ZONE` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `TIME_ZONE_OFFSET` int(18) DEFAULT NULL, `TITLE` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `BX_USER_ID` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL, `LANGUAGE_ID` char(2) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`ID`), UNIQUE KEY `ix_login` (`LOGIN`,`EXTERNAL_AUTH_ID`), KEY `ix_b_user_email` (`EMAIL`), KEY `ix_b_user_activity_date` (`LAST_ACTIVITY_DATE`), KEY `IX_B_USER_XML_ID` (`XML_ID`), KEY `ix_user_last_login` (`LAST_LOGIN`), KEY `ix_user_date_register` (`DATE_REGISTER`)) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT;

[Togzi]

Togzi,

Answer 1

[Rsa97]

RTFM

The maximum row size for an InnoDB table, which applies to data stored locally within a database page, is slightly less than half a page for 4KB, 8KB, 16KB, and 32KB innodb_page_size settings.

Comments

[Togzi]

а что тогда нужно сделать, чтобы всю бд загрузить?

[Rsa97]

Togzi, Увеличить innodb_page_size до 32КB

Answer 2

[Togzi]

Поменял движок на MyISAM, проблема решилась

Comments

[Rsa97]

Только потеряли внешние ключи, транзакции, блокировки строк