problem as to restore data from mysql( version: 3.23.56) to mysql(version: 4.1.18-standard)
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 !
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.