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
table name filtered while uploading database
Moderator: General Moderators
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
http://www.mysql.org/doc/refman/5.1/en/identifiers.html
And in the future, it would be best to post version numbers to better allow helpers to identify problems.#Before MySQL 5.1.6, table names cannot contain ‘/’, ‘\’, ‘.’, or characters that are not allowed in a filename.