See Thread at: http://www.techienuggets.com/Detail?tx=24273 Posted on behalf of
a User
Help! I'm still facing this problem. I can run a check error successfully but
when I try to dump the database using MySQL Administrator halfway through one
table the server crashes. See message at the end. I
Karel W. Dingeldey wrote:
Ok, I will do it more clearly. The server has two harddisks, one for the
system, one for the data. The system harddisk breaked, hardware failure. It
seems that this happed while mysqld was writing some data, so that some
tables are corrupted. Most tables are reconstruc
On filesystem level I made all rescue trials. My problem is, that only the
MYD
file is still available. I tried reconstructing it with "myisamchk -r -o
table_name.MYD", but as I said without the wanted result.
MYD is your data, MYI is your indexes (Indexes are easy to rebuild, you
should not w
> At first - do not write anything on the corrupted disk until You have
> finished rescuing data. As I understad the crash is connected to HW or
> filesystem (FS) failure (HDD).
Ok, I will do it more clearly. The server has two harddisks, one for the
system, one for the data. The system harddisk
PS: I already tried with "myisamchk -r -o *.MY*", but then all datasets
are gone and the table is empty. :-(
man myisamchk
I tried myisamchk already. But after running the above rescue attempt, the
tables are empty.
Then I hope you made backups You, do keep backups right?
--
Chris
-
At first - do not write anything on the corrupted disk until You have
finished rescuing data. As I understad the crash is connected to HW or
filesystem (FS) failure (HDD). In that case try to use fsck to repair FS
(if it is regular linux FS, like ext2 or ext3, for xfs there were some
other util
>> PS: I already tried with "myisamchk -r -o *.MY*", but then all datasets
>> are gone and the table is empty. :-(
>
> man myisamchk
I tried myisamchk already. But after running the above rescue attempt, the
tables are empty.
--
MySQL General Mailing List
For list archives: http://lists.mysql.
Hi,
We try to upgrade to 4.0.20, but we still have a crash on startup. Is
there any binaries compatibilities regarding the binairies provided by
MySQL ?
Philippe Poelvoorde wrote:
Hi,
After downgrading to the 4.0.15 provided by Mandrake, we found a more
explicit message : cannot found xxx funct
Hi,
After downgrading to the 4.0.15 provided by Mandrake, we found a more
explicit message : cannot found xxx function, which was one of our UDF.
we recompile the UDF with the extern "C" (not needed on our dev. server,
which is strange...), and everything is fine now.
When one query :
INSERT INTO
:[EMAIL PROTECTED]]
Sent: 16. oktober 2002 11:56
To: [EMAIL PROTECTED]
Subject: re: Server crash upon remote access
x-gylee+mysql,
Wednesday, October 16, 2002, 11:11:44 AM, you wrote:
>Description:
xgmaidc> MySQL server crashes when a remote client connects.
xgmaidc> A local client c
x-gylee+mysql,
Wednesday, October 16, 2002, 11:11:44 AM, you wrote:
>Description:
xgmaidc> MySQL server crashes when a remote client connects.
xgmaidc> A local client connecting thru unix socket file does not have the problem.
>How-To-Repeat:
xgmaidc> Connect via a remote host.
>Fix:
xgmaidc> No
11 matches
Mail list logo
