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 ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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! |
| ||||
| 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). |