table name filtered while uploading database

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
eshban
Forum Contributor
Posts: 184
Joined: Mon Sep 05, 2005 1:38 am

table name filtered while uploading database

Post 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
jammr
Forum Newbie
Posts: 16
Joined: Mon Jan 22, 2007 12:10 am

Post by jammr »

Why not just make the field manually?
eshban
Forum Contributor
Posts: 184
Joined: Mon Sep 05, 2005 1:38 am

Post by eshban »

I try it, it wont work.
My table and one field has name 'INTERCOURSE'

Kindly help
User avatar
volka
DevNet Evangelist
Posts: 8391
Joined: Tue May 07, 2002 9:48 am
Location: Berlin, ger

Post by volka »

INTERCOURSE or I.N.T.E.R.C.O.U.R.S.E ?
User avatar
m3mn0n
PHP Evangelist
Posts: 3548
Joined: Tue Aug 13, 2002 3:35 pm
Location: Calgary, Canada

Post 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.
Post Reply