CodingForums.com - View Single Post - What do I do with this structure file in PHPMyAdmin?

Old Pedant · 03-04-2013, 04:12 PM

It looks like you simply have a problem in your input text file.

Notice this part of the error message:
# Tabellenstruktur f�r Tabelle `contacts` # C

That is actually parts of *FOUR* lines of your text all jammed together.

It looks like you file is missing end-of-line characters on some lines.

When I copied your text into MySQL directly, it worked fine *EXCEPT* that

Code:

TYPE=MyIsam

is bogus. That should be

Code:

ENGINE=MyIsam

03-04-2013, 04:12 PM	PM User \| #2
Old Pedant Supreme Master coder! Join Date: Feb 2009 Posts: 23,168 Thanks: 59 Thanked 3,992 Times in 3,961 Posts	It looks like you simply have a problem in your input text file. Notice this part of the error message: # Tabellenstruktur f�r Tabelle `contacts` # C That is actually parts of FOUR lines of your text all jammed together. It looks like you file is missing end-of-line characters on some lines. When I copied your text into MySQL directly, it worked fine EXCEPT that Code: TYPE=MyIsam is bogus. That should be Code: ENGINE=MyIsam __________________ An optimist sees the glass as half full. A pessimist sees the glass as half empty. A realist drinks it no matter how much there is.