Hello.


Do you have a shell account? What engines do you use for your tables?

In your previous post you said you had tried to repair database (did you 

want to say table?) while it was in use. What way had you chosen for

repairing? If myisamchk - that wasn't good idea on running server.

If all your tables MyISAM and you have a shell on that server, 

stop the server and use copy all your databases to safe location.

Than use myisamchk to check and repair. Then replace the old database

with repaired one.







Fajar Priyanto <[EMAIL PROTECTED]> wrote:

> 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

> 

> 

> 



-- 
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




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to