MySql Data not importing!!

[Ty Wwe Rice]

Please Help :S
when i try to import on navicat i get this error:
---------------------------------------------
[Msg] [Imp] Import start
[Msg] [Imp] Import type - Text file
[Msg] [Imp] Import from - C:\WorkingSource\Source\bin\Debug\MySql.Data.dll
[Err] [Imp] Cannot create table [MySql.Data]: 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 '' at line 1
[Err] [Imp] CREATE TABLE `MySql.Data` (`MZ�
[Msg] [Imp] Processed:0, Added:0, Updated:0, Deleted:0, Errors:0
[Msg] [Imp] Finished - Unsuccessfully
-----------------------------------------------

[MentaL]

[JackHoll]

Look's like you have a unknown symbol in one of your tables

Where the table MZ is, delete the "�" after it

[Ty Wwe Rice]

I have no idea where that is. i have checked the whole code for MZ� and cant find it anywhere... where can it be found?

I have no idea where that is. i have checked the whole code for MZ� and cant find it anywhere... where can it be found?

Look's like you have a unknown symbol in one of your tables

Where the table MZ is, delete the "�" after it

could you tell me where that is?

[JackHoll]

I have no idea where that is. i have checked the whole code for MZ� and cant find it anywhere... where can it be found?

I have no idea where that is. i have checked the whole code for MZ� and cant find it anywhere... where can it be found?




could you tell me where that is?

Add me on skype: Jackh0ll or post the database here and I'll take a look at it

[Ty Wwe Rice]

Add me on skype: Jackh0ll or post the database here and I'll take a look at it

Added :D

[seanrom]

Read the error message, you have a unexpected ' which means there's a ' in the value.
Use a replace function and replace ' with \'

Edit:
You're trying to create a table called MySql.Data but your query is wrong. The table structure is missing.

CREATE TABLE `MySql.Data` (`MZ� <- There's supose to be something more there.

Here's an example how it's really done:

CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20), species VARCHAR(20), sex CHAR(1), birth DATE, death DATE);