Importing from a text file into MySQL

[canstocker]

Hello everyone,

I get this error:

#1148 - The used command is not allowed with this MySQL version

when I try to import a text file using phpMyAdmin. I'm logged in using the domain's main user name and password.

Any ideas? Dan.

[Jonathan]

Sounds like a error in the SQL syntax, rather than the server.

[canstocker]

Currently I'm just trying to test using 2 text columns, and using phpMyAdmin (which does the SQL).

No matter what, I get the error.

Dan.

[Jonathan]

Currently I'm just trying to test using 2 text columns, and using phpMyAdmin (which does the SQL).

No matter what, I get the error.

Dan.

No matter what? Hmm... even if you use phpMyAdmin to create the columns?
If so, I'd say submit a trouble ticket and see whats happening.

[sdjl]

Have you assigned a user to your database in cPanel?
Are you trying to use a MySQL function thats only available in a higher version of MySQL?

David