MySQL Forums
Forum List  »  Newbie

How can i convert mysql 4.1 to 4.0
Posted by: taha yıldırım
Date: October 31, 2005 12:58PM

Hi,

i have a phpmyadmin bacup of my databse from a server which is mysql 4.1

my ex-account terminated i couldnt convert it on phpmyadmin

now new server is mysl 4.0

when i try to dump it it says

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. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1' at line 6


i know this is becaue the version bcs i try on anther server i convert it via phpmyadmin but now i havent i phpmyadmin bcs ex-server terminate my account

pls help me =(

Options: ReplyQuote


Subject
Written By
Posted
How can i convert mysql 4.1 to 4.0
October 31, 2005 12:58PM


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.