MySQL Forums
Forum List  »  Backup

problem as to restore data from mysql( version: 3.23.56) to mysql(version: 4.1.18-standard)
Posted by: david yang
Date: May 09, 2006 09:29PM

hello,every one
I dump a db backup scrip on a mysql server which version is 3.23.56,and then i need to import the data to the other mysql server(which version is 4.1.18) .

But during the process of importing data,it suddenly stops and appears some error message as belows:
"ERROR 1064 (42000): 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 ''\0\0\0RT::CurrentUser\0\0\0\0\0\瀄0\0\0\rcache_for_se乗0\0\0ca' at line 1 "

Moreover,the db backup script is quite larege(4G),so i can't edit the db scrit file manually.

I think the crucial problem maybe exist the different version of mysql.
please help teach me how to resolve it.I will appreciate you greatly !

Options: ReplyQuote


Subject
Views
Written By
Posted
problem as to restore data from mysql( version: 3.23.56) to mysql(version: 4.1.18-standard)
2853
May 09, 2006 09:29PM


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.