From: Rick James
Date: August 8 2012 5:44pm
Subject: RE: changing mySQL table name screws phpMyAdmin?? reverting change
 fixes??
List-Archive: http://lists.mysql.com/mysql/227976
Message-Id: <2E7DD7ADE53B044C8C8BCD9C5829E1EB1489DBA296@SP2-EX07VS01.ds.corp.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

(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.
=20
> -----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??
>=20
> 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:
>=20
> =A0 =A0 mysql>DESCRIBE mychangedtbl;
> =A0 =A0 +-----------+-------------+------+-----+---------+-------+
> =A0 =A0 |Field =A0 =A0 |Type =A0 =A0 =A0 =A0|Null|Key|Default|Extra |
> =A0 =A0 +-----------+-------------+------+-----+---------+-------+
> =A0 =A0 |userid =A0 =A0|char(6)=A0 =A0 |NO =A0 |PRI |NULL=A0 =A0|=A0 =A0 =
=A0 |
> =A0 =A0 |userpass =A0|varchar(40)|NO =A0 |=A0 =A0 |NULL=A0 =A0|=A0 =A0 =
=A0 |
> =A0 =A0 |userlevel |char(3)=A0 =A0 |NO =A0 |=A0 =A0 |o =A0 =A0 =A0 |=A0 =
=A0 =A0 |
> =A0 =A0 |userpcip =A0|varchar(45)|NO =A0 |=A0 =A0 |NULL=A0 =A0|=A0 =A0 =
=A0 |
> =A0 =A0 +-----------+-------------+------+-----+---------+-------+
> =A0 =A0 4rows inset(0.00sec)
> mysql>
>=20
> column userpass has Collation =3D asci_bin which it does not show in
> above output, other columns are ascii_general_ci pl advice.
> ty. Rajeev
>=20
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql