Unix Technical Forum

PROBLEM WITH REPAIR TABLE..HELP!!!

This is a discussion on PROBLEM WITH REPAIR TABLE..HELP!!! within the MySQL forums, part of the Database Server Software category; --> Hi to everyone, I've got a very big problem with a table.... when I try to open it,it gives ...


Go Back   Unix Technical Forum > Database Server Software > MySQL

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-28-2008, 10:11 AM
sonia.cotroneo@gmail.com
 
Posts: n/a
Default PROBLEM WITH REPAIR TABLE..HELP!!!

Hi to everyone, I've got a very big problem with a table.... when I
try to open it,it gives me error!!
I've tried to repair it with the mysql command "REPAIR TABLE" but it
didn't work..so I tried with MYISAMCHK, with the command "REPAIR TABLE
tablename USE_FRM" and they didn't work.. Now I'm trying to copy the
backup but there are many problems... Are there any other ways to
repair a table!?!??!is there anyone who could help me? Last thing,
this table is full of images and it's about 10G...Thank you so much!

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-28-2008, 10:11 AM
lark
 
Posts: n/a
Default Re: PROBLEM WITH REPAIR TABLE..HELP!!!

sonia.cotroneo@gmail.com wrote:
> Hi to everyone, I've got a very big problem with a table.... when I
> try to open it,it gives me error!!
> I've tried to repair it with the mysql command "REPAIR TABLE" but it
> didn't work..so I tried with MYISAMCHK, with the command "REPAIR TABLE
> tablename USE_FRM" and they didn't work.. Now I'm trying to copy the
> backup but there are many problems... Are there any other ways to
> repair a table!?!??!is there anyone who could help me? Last thing,
> this table is full of images and it's about 10G...Thank you so much!
>

can you post the different error messages you get when your run
1-repair table
2-myisamchk

on the table.

if you have backups, don't worry, you'd be able to restore from backups.

when running myisamck, be sure to bring the server down (stop it) and
then run the cmd. also, be sure to check many options that come with
myisamchk (there are many).

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 05:37 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com