Ok back again. lol I just purchased a new hosting provider and was trying to transfer my database over to my new site. I exported the tables using Navicat and "tab" as the delimiter. I have three tables and they all saved as text files and look fine when I open them. I went into my DB admin in my sites control panel and that of course opened phpMyAdmin page where I can import these text files into my new db. When I try this however, I get an error for all three text files that really isnt very descriptive of how or why its occurring. Here is the error:
SQL query: 1Philips2Eiko3Donar4Sylvania5Hikari6GE7Osram8Kandolite9Ushio10Westinghouse11Unknown12Demo13Generic14Thorn15Halco16Perko17Narva18CEC19Import20Orbitech21Prism22Plus23EYE24Plusrite25Hosobuchi26Wagner27Carley28Welch Allyn29Nikon30Topcon31Radiac32LTI33Major MySQL said: #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 '1 Philips 2 Eiko 3 Donar 4 Sylvania 5 Hikari 6 GE 7 Osram 8 Kandolite 9 ' at line 1
I tried importing all three tables separately, but no luck. I see it has that apostrophe "at line 1" Not sure if thats part of the error message, but I dont see any strange characters in my text files. Any help would be greatly appreciated.