mysql - #1286 - Unknown storage engine 'InnoDB' -
please me error
#1286 - unknown storage engine 'innodb'
running query:
create table if not exists `tbl_prize` ( `prize_id` int(11) not null, `prize` int(11) not null, `chance` int(11) not null default '1' ) engine=innodb auto_increment=3 default charset=utf8 collate=utf8_bin; alter table `tbl_prize` add primary key (`prize_id`); alter table `tbl_prize` modify `prize_id` int(11) not null auto_increment,auto_increment=3; insert `tbl_prize` (`prize_id`, `prize`, `chance`) values(1, 100, 1),(2, 200, 1); create table if not exists `tbl_user` ( `user_id` int(11) not null, `reffer_id` int(11) default null, `wallet` varchar(500) not null, `ref_pending` int(11) unsigned not null default '0', `earn` int(11) unsigned not null default '0', `playnum` int(11) unsigned not null, `ip` int(10) unsigned default null, `reset` int(4) unsigned not null ) engine=innodb default charset=latin1; alter table `tbl_user` add primary key (`user_id`), add key `reffer_id` (`reffer_id`), add key `username` (`wallet`), add key `ref_pending` (`ref_pending`), add key `ip` (`ip`), add key `reset` (`reset`); alter table `tbl_user` modify `user_id` int(11) not null auto_increment; alter table `tbl_user` add constraint `tbl_user_ibfk_1` foreign key (`reffer_id`) references `tbl_user` (`user_id`) on delete set null;
the mysql server configured using 1 of these storage engines:
- innodb (usually default)
- myisam
other engines exists though.
you problem lays in engine=innodb part of query. can try erase this, if don't care storage engine.
another solution (the hard 1 if don't know database servers) change storage engine in configuration. if able/authorized it, configure database engine using innodb. find my.cnf file , set default-storage-engine innodb. other parameters should changed in order make work (see references).
note: if mysql server contains data, need backup before.
references:
Comments
Post a Comment