
12-11-2013, 01:40 PM
|
 |
|
|
Join Date: Jan 2007
Posts: 348
Благодарил(а): 0 раз(а)
Поблагодарили:
0 раз(а) в 0 сообщениях
|
|
i have backup
my problem is i am changing server when i import backup
its giving me error
and with out those table database restoring fine
here is errer
Quote:
Error
SQL query:
CREATE TABLE `activitystream` (
`activitystreamid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
`userid` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',
`dateline` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',
`data` MEDIUMTEXT NOT NULL ,
`contentid` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',
`typeid` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',
`action` ENUM( 'create', 'edit', 'delete' ) NOT NULL DEFAULT 'create',
`score` DECIMAL( 13, 3 ) NOT NULL DEFAULT '0.000',
PRIMARY KEY ( `activitystreamid` ) ,
KEY `score` ( `score` , `dateline` ) ,
KEY `dateline` ( `dateline` ) ,
KEY `typeid` ( `typeid` , `dateline` ) ,
KEY `typeid_2` ( `typeid` , `score` , `dateline` ) ,
KEY `contentid` ( `contentid` , `typeid` ) ,
KEY `userid` ( `userid` , `dateline` )
) ENGINE = MYISAM AUTO_INCREMENT =140 DEFAULT CHARSET = latin1 PAGE_CHECKSUM =1;
MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PAGE_CHECKSUM=1' at line 17
|
--------------- Added [DATE]1386782045[/DATE] at [TIME]1386782045[/TIME] ---------------
problem solved by convert storage engine Aria to innodb
|