MySQL Forums
Forum List  »  German

Advanced Search
New Topic

Re: kaputte tabelle erstellen die reparierbar ist mit REPAIR TABLE
Posted by: r b
Date: August 12, 2011 07:54AM

thank you.
that worked ;)

i created a script:

dd if=$1.MYD bs=1024 count=100 of=$1_corrupt.MYD
dd if=/dev/zero bs=1024 count=1 of=/tmp/p2
dd if=$1.MYD bs=1024 skip=101 of=/tmp/p3
cat /tmp/p2 /tmp/p3 >> $1_corrupt.MYD
chown mysql:mysql $1_corrupt.MYD

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
kaputte tabelle erstellen die reparierbar ist mit REPAIR TABLE
2302
r b
July 28, 2011 01:50AM
Re: kaputte tabelle erstellen die reparierbar ist mit REPAIR TABLE
1135
Oli Sennhauser
August 10, 2011 08:40AM
Re: kaputte tabelle erstellen die reparierbar ist mit REPAIR TABLE
1197
r b
August 12, 2011 07:54AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.