Hi Gleb, This is what I have using SHOW PROCESSLIST: Waiting for table SHOW TABLE STATUS FROM `db_mambo` LIKE 'mos_TFS_visits'
Help me pls, is there any way I can save this database? Looks like the troubled table is mos_TFS_visits. Thanks, Fakar On Monday 08 August 2005 03:59 pm, Gleb Paharenko wrote: > Hello. > > > > > > Use SHOW PROCESSLIST to see what's going on in your database. > > Fajar Priyanto <[EMAIL PROTECTED]> wrote: > > Hi all, > > > > I'm hosting my web on a provider with MySQL 4.0.25-standard. > > > > > > > > I've got this situation when I open my database using phpMyadmin, one of > > my > > > > table has status is "in use". > > > > > > > > And then when I try to repair the database, MySQL just hung there while > > > > consumed around 50% of CPU. And then when I tried to export the database, > > > > phpMyadmin got stuck at that tables, with a status of SHOW TABLE STATUS > > FROM > > > > 'thetroubledtable'. > > > > > > > > I tried to contact the hosting provider, but it seems they're having > > weekend > > > > break. > > > > > > > > Is there any way that I or my hosting provider can do about it? Maybe > > > > restarting the mysql server is enough? Or can the table just being > > deleted? > > > > Thanks, > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.NET http://www.ensita.net/ > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Gleb Paharenko > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET > <___/ www.mysql.com -- Fajar Priyanto | Reg'd Linux User #327841 | http://linux2.arinet.org 23:51:20 up 25 min, Mandrakelinux release 10.2 (Limited Edition 2005) for i586 public key: https://www.arinet.org/fajar-pub.key -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
