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

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

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

Togzi,

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

Александр, 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;