Topic: Помогите с БД
Вопщем скопировал Бд с navicat в формате sql и попробовал залить на phpmyadmin выдаёт ошибку вот эту:
SQL-запрос:
-- ----------------------------
-- Table structure for pubs
-- ----------------------------
CREATE TABLE `pubs` (
`ID` INT( 11 ) NOT NULL AUTO_INCREMENT ,
`name` VARCHAR( 16 ) CHARACTER SET ASCII DEFAULT NULL ,
`pass` VARCHAR( 16 ) CHARACTER SET ASCII DEFAULT NULL ,
`owner` VARCHAR( 16 ) CHARACTER SET ASCII DEFAULT NULL ,
`ownerip` VARCHAR( 16 ) CHARACTER SET ASCII DEFAULT '0',
`mod` VARCHAR( 12 ) CHARACTER SET ASCII DEFAULT 'AP',
`radiant1` VARCHAR( 12 ) CHARACTER SET ASCII DEFAULT 'Empty',
`radiant2` VARCHAR( 12 ) CHARACTER SET ASCII DEFAULT 'Empty',
`radiant3` VARCHAR( 12 ) CHARACTER SET ASCII DEFAULT 'Empty',
`radiant4` VARCHAR( 12 ) CHARACTER SET ASCII DEFAULT 'Empty',
`radiant5` VARCHAR( 12 ) CHARACTER SET ASCII DEFAULT 'Empty',
`dire1` VARCHAR( 12 ) CHARACTER SET ASCII DEFAULT 'Empty',
`dire2` VARCHAR( 12 ) CHARACTER SET ASCII DEFAULT 'Empty',
`dire3` VARCHAR( 12 ) CHARACTER SET ASCII DEFAULT 'Empty',
`dire4` VARCHAR( 12 ) CHARACTER SET ASCII DEFAULT 'Empty',
`dire5` VARCHAR( 12 ) CHARACTER SET ASCII DEFAULT 'Empty',
PRIMARY KEY ( `ID` )
) ENGINE = INNODB AUTO_INCREMENT =16 DEFAULT CHARSET = latin1;
Ответ MySQL: Документация
#1289 - The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working
А вот сами данные Sql:
/*
MySQL Data Transfer
Source Host: localhost
Source Database: d2user
Target Host: localhost
Target Database: d2user
Date: 04.10.2014 23:27:13
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for pubs
-- ----------------------------
CREATE TABLE `pubs` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(16) CHARACTER SET ascii DEFAULT NULL,
`pass` varchar(16) CHARACTER SET ascii DEFAULT NULL,
`owner` varchar(16) CHARACTER SET ascii DEFAULT NULL,
`ownerip` varchar(16) CHARACTER SET ascii DEFAULT '0',
`mod` varchar(12) CHARACTER SET ascii DEFAULT 'AP',
`radiant1` varchar(12) CHARACTER SET ascii DEFAULT 'Empty',
`radiant2` varchar(12) CHARACTER SET ascii DEFAULT 'Empty',
`radiant3` varchar(12) CHARACTER SET ascii DEFAULT 'Empty',
`radiant4` varchar(12) CHARACTER SET ascii DEFAULT 'Empty',
`radiant5` varchar(12) CHARACTER SET ascii DEFAULT 'Empty',
`dire1` varchar(12) CHARACTER SET ascii DEFAULT 'Empty',
`dire2` varchar(12) CHARACTER SET ascii DEFAULT 'Empty',
`dire3` varchar(12) CHARACTER SET ascii DEFAULT 'Empty',
`dire4` varchar(12) CHARACTER SET ascii DEFAULT 'Empty',
`dire5` varchar(12) CHARACTER SET ascii DEFAULT 'Empty',
PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for users
-- ----------------------------
CREATE TABLE `users` (
`ID` int(255) NOT NULL AUTO_INCREMENT,
`login` varchar(255) CHARACTER SET ascii DEFAULT '',
`pass` varchar(255) CHARACTER SET ascii DEFAULT '',
`icon` varchar(3) CHARACTER SET ascii DEFAULT '1',
`online` varchar(5) CHARACTER SET ascii DEFAULT 'False',
`channel` varchar(12) CHARACTER SET ascii DEFAULT 'main',
PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records
-- ----------------------------
INSERT INTO `pubs` VALUES ('15', 'main', null, null, '9999', 'AP', 'Empty', 'Empty', 'Empty', 'Empty', 'Empty', 'Empty', 'Empty', 'Empty', 'Empty', 'Empty');
INSERT INTO `users` VALUES ('1', 'GOD', '123', '0', 'false', 'main');
Кто разбирается можете поправит мой запрос чтоб ошибок не возникало.