List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:July 11 2001 1:07pm
Subject:Re: data corruption
View as plain text  
mysqladmin shutdown
to stop the server.

You should have run myisamchk to fix the tables.

When you copied the tables from backup you probably changed the user
and permissions.

Ransom wrote:

> I was updating a database and my database got corrupted ( I'm not sure
> what coused this) but ever since then I have been having lots of mysql
> problems. The onl way I can stop mysql is by doing a kill, mysqld stop
> fails. I was able to restore to a backed up database but now I can not
> add new items. The way I restored the database was by coping over the
> MYD, frm and MYI files, not sure if that was the right way to do that.
> Does anyone know how I can fix this?
> I am not sure which version of mysql I'm running its the version that
> cam with redhat 7.1.
> Ransom
> #!/usr/bin/perl -w
> # 531-byte qrpff-fast, Keith Winstein and Marc Horowitz <sipb-iap-dvd@stripped>
> # MPEG 2 PS VOB file on stdin -> descrambled output on stdout
> # arguments: title key bytes in least to most-significant order
> $_='while(read+STDIN,$_,2048){$a=29;$b=73;$c=142;$t=255;@t=map{$_%16or$t^=$c^=(
> $m=(11,10,116,100,11,122,20,100)[$_/16%8])&110;$t^=(72,@z=(64,72,$a^=12*($_%16
> -2?0:$m&17)),$b^=$_%64?12:0,@z)[$_%8]}(16..271);if((@a=unx"C*",$_)[20]&48){$h
> =5;$_=unxb24,join"",@b=map{xB8,unxb8,chr($_^$a[--$h+84])}@ARGV;s/...$/1$&/;$
> d=unxV,xb25,$_;$e=256|(ord$b[4])<<9|ord$b[3];$d=$d>>8^($f=$t&($d>>12^$d>>4^
> $d^$d/8))<<17,$e=$e>>8^($t&($g=($q=$e>>14&7^$e)^$q*8^$q<<6))<<9,$_=$t[$_]^
> (($h>>=8)+=$f+(~$g&$t))for@a[128..$#a]}print+x"C*",@a}';s/x/pack+/g;eval
> ---------------------------------------------------------------------
> Before posting, please check:
>   (the manual)
>           (the list archive)
> To request this thread, e-mail <mysql-thread79049@stripped>
> To unsubscribe, e-mail
> <>
> Trouble unsubscribing? Try:

Gerald L. Clark

data corruptionRansom10 Jul
  • Re: data corruptionGerald Clark11 Jul