Garayed.com  

Go Back   Garayed.com > mySQL
FAQ Members List Calendar Search Today's Posts Mark Forums Read


Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 07-06-2007, 08: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 07-06-2007, 04:40 PM
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 Search this Thread
Search this Thread:

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



All times are GMT. The time now is 01:47 AM.




LinkBacks Enabled by vBSEO 3.0.0 © 2007, Crawlability, Inc.