He exportat les taules moodle i he obtingut un fitxer de text com el que us adjunto (en gzip). He importat aquest fitxer al mysql al servidor phobos iem dona un error . El missatge és:
---------------------------------------------------------------------------
Base de dades jsales funcionant a localhost
Erradacrida SQL :
CREATE TABLE `mdl_assignment` (
`id` int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
`course` int( 10 ) unsigned NOT NULL default '0',
`name` varchar( 255 ) NOT NULL default '',
`description` text NOT NULL ,
`format` tinyint( 2 ) unsigned NOT NULL default '0',
`resubmit` tinyint( 2 ) unsigned NOT NULL default '0',
`type` int( 10 ) unsigned NOT NULL default '1',
`maxbytes` int( 10 ) unsigned NOT NULL default '100000',
`timedue` int( 10 ) unsigned NOT NULL default '0',
`grade` int( 10 ) NOT NULL default '0',
`timemodified` int( 10 ) unsigned NOT NULL default '0',
PRIMARY KEY ( `id` ) ,
KEY `course` ( `course` )
)ENGINE = MYISAM DEFAULT CHARSET = latin1 COMMENT = 'Defines assignments' AUTO_INCREMENT =6
MySQL diu:
#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 'DEFAULT CHARSET=latin1 COMMENT='Defines assignments' AUTO_INCRE
------------------------------------------------------------------------------------------
Algú em pot ajudar?
Gràcies per endavant.
Pep Sales