(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.ne...@yahoo.com] > 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
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
