Page 1 of 1

table name filtered while uploading database

Posted: Sun Jan 21, 2007 10:29 pm
by eshban
Hello
i am facing a severe problem while deploying a database on my server. Actually my database has a Table and a field with the name 'I.N.T.E.R.C.O.U.R.S.E', so when i upload the sql script through phpmyadmin, it wont accept that name. It is not possible for me to change the database and field name.So kindly guide that how can i deploy my database and fix this problem.

please help in this regard

Eshban

Posted: Mon Jan 22, 2007 2:13 am
by jammr
Why not just make the field manually?

Posted: Mon Jan 22, 2007 3:29 am
by eshban
I try it, it wont work.
My table and one field has name 'INTERCOURSE'

Kindly help

Posted: Mon Jan 22, 2007 3:36 am
by volka
INTERCOURSE or I.N.T.E.R.C.O.U.R.S.E ?

Posted: Mon Jan 22, 2007 6:21 am
by m3mn0n
Use an alphanumeric name. That one is not valid/supported. Your other option is to upgrade to MySQL 5.1.6. I believe that might do the trick.

http://www.mysql.org/doc/refman/5.1/en/identifiers.html
#Before MySQL 5.1.6, table names cannot contain ‘/’, ‘\’, ‘.’, or characters that are not allowed in a filename.
And in the future, it would be best to post version numbers to better allow helpers to identify problems.