Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Trying to execute this sql file

Author  Topic 

zzremix
Starting Member

2 Posts

Posted - 2013-03-03 : 16:48:42
i had it working yesterday.

keep getting this error.

[Err] 1064 - 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 '?SET FOREIGN_KEY_CHECKS=0' at line 1
[Err] ?SET FOREIGN_KEY_CHECKS=0;
[Msg] Finished - Unsuccessfully

sql file; http://ge.tt/4VEpIzZ/v/0?c

changed the link



James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-03-03 : 17:07:35
Hopefully someone else who is braver than I will click on your link and examine the SQL script and give you the answers. I am weary about clicking on a link that points to a SQL file, especially from a computer at work. If you don't get any responses in a timely manner, can you post the SQL script in the text of your message rather than as a link?
Go to Top of Page

zzremix
Starting Member

2 Posts

Posted - 2013-03-03 : 17:11:10
eh i'm sorry, i would but the sql file is 86781 lines. is there any other way to post so people can see?
Go to Top of Page

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-03-03 : 17:15:25
I can't think of an easy way to post that. Even if you did, with 86,781 lines, I doubt very many people on the forum would have the time to analyze it and give you a solution. Is it possible for you narrow down the problem to a small sample set?

Also, I just noticed that you are using MySQL. This forum is for Microsoft SQL Server, so not many people with expertise on MySQL here. You might want to try a forum dedicated to MySQL.
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2013-03-04 : 01:45:47
What has changed? I'd recommend you run it through a MySQL parser and troubleshoot

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
   

- Advertisement -