SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Trying to execute this sql file
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

zzremix
Starting Member

2 Posts

Posted - 03/03/2013 :  16:48:42  Show Profile  Reply with Quote
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




Edited by - zzremix on 03/03/2013 17:18:05

James K
Flowing Fount of Yak Knowledge

3760 Posts

Posted - 03/03/2013 :  17:07:35  Show Profile  Reply with Quote
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 - 03/03/2013 :  17:11:10  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

3760 Posts

Posted - 03/03/2013 :  17:15:25  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

United Kingdom
2079 Posts

Posted - 03/04/2013 :  01:45:47  Show Profile  Visit jackv's Homepage  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000