Philip,
Tuesday, October 01, 2002, 5:49:47 PM, you wrote:
PD> I have a table which was accessible for the last couple years but is now
PD> inaccessible after performing a simple alter table command.
PD> There are approx. 10 tables in this database on which the same alter table
PD> command was given ("alter table table_name add glperiod varchar (3) null
PD> first;"). All of these tables are O.K. (and were correctly altered) except 1.
PD> What happens is that whenever I try to perform an SQL command against this
PD> table (called "codeprojects"), either MySQL hangs (at the command prompt)
PD> or my perl script hangs in the "$sth->execute($sql)" statement. Like I
PD> said, all of these methods, etc. worked on this table in the past and still
PD> work on the rest of the tables.
PD> I've tried, restarting MySQL (which seemed to work at first but now does
PD> not), dropping and rebuilding the table (it hangs on the drop command),
PD> copying a "working" copy of the three table files from a backup database,
PD> deleting the three files and starting over again. Nothing has worked so far.
PD> Any ideas??
PD> OS: Redhat 7.1 Linux
PD> MySQL: 3.23.41
Use CHECK table to see if the table is corrupted. If so you should repair it with
REPAIR TABLE or myisamchk:
http://www.mysql.com/doc/en/Repair.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
