views:

47

answers:

1

Hi, I am trying to upload a members database with login and create user facilities. Whenever I upload the .sql file to the host i am getting an error at the bottom of the page saying:

MySQL said: 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 'ÿþ/' at line 1

Any ideas what I need to change would be greatly appreciated.I have attached the first bit of source code.

ERROR: C1 C2 LEN: 0 1 68006
STR: ÿ

MySQL: 5.0.77-log
USR OS, AGENT, VER: Win MOZILLA 5.0
PMA: 2.4.0
PHP VER,OS: 4.4.7 FreeBSD
LANG: en-iso-8859-1
SQL: ÿþ/****** Object:  ForeignKey [FK__aspnet_Me__Appli__145C0A3F]    Script Date: 07/29/2010 14:50:34 ******/

IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK__aspnet_Me__Appli__145C0A3F]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_Membership]'))

ALTER TABLE [dbo].[aspnet_Membership] DROP CONSTRAINT [FK__aspnet_Me__Appli__145C0A3F]

GO

/****** Object:  ForeignKey [FK__aspnet_Me__UserI__15502E78]    Script Date: 07/29/2010 14:50:34 ******/

IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK__aspnet_Me__UserI__15502E78]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_Membership]'))

ALTER TABLE [dbo].[aspnet_Membership] DROP CONSTRAINT [FK__aspnet_Me__UserI__15502E78]

GO
+5  A: 

You are running an MS SQL script on a MySQL database. This just won't work the syntax is different and the script refers to system tables and views that simply don't exist in a MySQL database.

Ben Robinson
+1: Yep - all TSQL syntax [dbo], sys.foreign_keys, OBJECT_ID... Good catch.
OMG Ponies