PDA

View Full Version : how to create mysql table


gsmlover4u
12-11-2013, 12:16 PM
how to create database table
activitystream
activitystreamtype
contentread
iplog
navigation

badly i drop those table

Disco_Dave
12-11-2013, 12:25 PM
Do you have back-ups of the database?

ForceHSS
12-11-2013, 02:11 PM
For what version. If you have a backup you can restore but why did you delete them for

gsmlover4u
12-11-2013, 02:40 PM
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
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 1386782045 at 1386782045 ---------------

problem solved by convert storage engine Aria to innodb