MySQL Forums
Forum List  »  Backup

Error 4.1.13 to 3.23 ..
Posted by: baday_88_2003
Date: December 19, 2005 06:47PM

the ERROR problem i allready have my [OLD] database and i wanna upload it to the new server , but the problem is there is some diffrent from the old version and the new one of the SQL - from 4.1.13 to 3.23 .. so this is the main issue i guess so far As an ERROR , so please if you can help me with it .. my datebase link
[ http://67.55.41.102/murdrsu_kartowm[1].sql.zip ] ..


Starting at the line: 1

Error at the line 26: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Query: CREATE TABLE `access` ( `userid` int(10) unsigned NOT NULL default '0', `forumid` smallint(5) unsigned NOT NULL default '0', `accessmask` smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (`userid`,`forumid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

MySQL: You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 6

Stopped on error

Start from the beginning (DROP the old tables before restarting)

?



Edited 1 time(s). Last edit at 12/19/2005 06:48PM by baday_88_2003.

Options: ReplyQuote


Subject
Views
Written By
Posted
Error 4.1.13 to 3.23 ..
3426
December 19, 2005 06:47PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.