Database Discussion - sql database transfer error

Print Page | Close Window

sql database transfer error - help

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=8980
Printed Date: 30 March 2026 at 12:17pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: sql database transfer error - help

Posted By: sk187
Subject: sql database transfer error - help
Date Posted: 16 January 2004 at 1:08pm

When trying to transfer my sql database from one server to another via ssh I recieve this error

"ERROR 1064 at line 1354: 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 'replace varchar(255) NOT NULL default '',
PRIMARY KEY (id)
)"

Could this simply be a charater that was changed from one version of sql to another? Thus, the original is not compatiable with the new versions of mysql?

Is there a command I can do via ssh that will let me know what sql version im running?

Thanks in advance.

Replies:

Posted By: zaboss
Date Posted: 16 January 2004 at 2:10pm

I run into the same problem once. I was using an older version of MySQL Front. When I changed it to the latest version, it worked. Try with another tool. MySQL Front, phpMyAdmin, whatever.

-------------
Cristian Banu
http://www.soft4web.ro - Soft 4 web