I decided just to creat a new database and import my old data using a
csv but I found another problem, I can now no longer create new
datadases and I can not add any data to any of the databases stored on
this machine. I was searching the logs and found this:
010708 0:37:02 Aborted connection 1921 to db: 'database' user: 'user' host: `host'
(Got an error reading communication packets)
010708 4:02:01 /usr/libexec/mysqld: Binlog closed, cannot RESET MASTER
(I am not sure if that means anything)
I've run myisamchk on the database that I was working on with the
corruption happened and it said it found errors and fixed them, I them
checked all the other databases and repaired a few errors but still I
can not add new data, add new databases, or stop mysql withiout doing a
kill on the pid
Anyone know a solution?
Thanks
Ransom
> 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.
>
#!/usr/bin/perl -w
# 531-byte qrpff-fast, Keith Winstein and Marc Horowitz <[EMAIL PROTECTED]>
# 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:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
