MySql Data not importing!!
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
-----------------------------------------------
Re: MySql Data not importing!!
Look's like you have a unknown symbol in one of your tables
Where the table MZ is, delete the "�" after it
Re: MySql Data not importing!!
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?
Quote:
Originally Posted by
JackHoll
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?
Re: MySql Data not importing!!
Quote:
Originally Posted by
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?
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
Re: MySql Data not importing!!
Quote:
Originally Posted by
JackHoll
Add me on skype: Jackh0ll or post the database here and I'll take a look at it
Added :D
Re: MySql Data not importing!!
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.
Code:
CREATE TABLE `MySql.Data` (`MZ� <- There's supose to be something more there.
Here's an example how it's really done:
Code:
CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20), species VARCHAR(20), sex CHAR(1), birth DATE, death DATE);