(I don't know about phpMyAdmin)
SHOW CREATE TABLE is more descriptive than DESCRIBE.
You are more likely to get the collation information that way.
> -----Original Message-----
> From: Rajeev Prasad [mailto:rp.neuli@stripped]
> Sent: Wednesday, August 08, 2012 10:20 AM
> To: mysql list
> Subject: changing mySQL table name screws phpMyAdmin?? reverting change
> fixes??
>
> I changed a name of the table from within phpMyAdmin, and immediately
> it crapped. after that when I try to connect using phpMyAdmin
> (/phpMyAdmin/index.php) I get error in log:
> [Wed Aug 0814:18:582012][error]Query call
> failed:Table'mydb.mychangedtbls'doesn't exist (1146) (I changed the
> name from mychangedtbls to mychangedtbl) mychangedtbl is the table
> whose name was changed. this issue is only in phpMyAdmin, I am able to
> access the database and tables find from CLI. I restarted mySQL, but
> that did not fix. Seems like something is stuck for phpMyAdmin. I
> restarted browser also but that didnt help either.
> when i rename this particular table back to what it was using command
> line, myphphAmin works fine again. here is the structure of this table:
>
> mysql>DESCRIBE mychangedtbl;
> +-----------+-------------+------+-----+---------+-------+
> |Field |Type
> |Null|Key|Default|Extra |
> +-----------+-------------+------+-----+---------+-------+
> |userid |char(6) |NO |PRI |NULL
> | |
> |userpass |varchar(40)|NO | |NULL
> | |
> |userlevel |char(3) |NO | |o
> | |
> |userpcip |varchar(45)|NO | |NULL
> | |
> +-----------+-------------+------+-----+---------+-------+
> 4rows inset(0.00sec)
> mysql>
>
> column userpass has Collation = asci_bin which it does not show in
> above output, other columns are ascii_general_ci pl advice.
> ty. Rajeev
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql
