il
now! ;)) The mysql manual just says 'if you have a crashed table you can
repair it.' Well...
1. What IS a table crash? What file/relation/... gets corrupted? And how
does table recovery basically work?
2. If you had a crashed table: Where would you start looking for the
reason? And
anual just says 'if you have a crashed table you can
repair it.' Well...
1. What IS a table crash? What file/relation/... gets corrupted? And how
does table recovery basically work?
2. If you had a crashed table: Where would you start looking for the
reason? And where would you look ne
Good call... I should have figured that out my self. The old version
was 2.6:
/usr/bin/myisamchk (v2.6)
/usr/local/mysql-standard-4.1.8-apple-darwin7.6.0-powerpc/bin/myisamchk
(v2.7)
This is likely why I lost my data in the first place.
Dan T
On Feb 16, 2005, at 10:57 AM, Michael Stassen wrote
Dan Tappin wrote:
I have MySQL 4.1.8 installed on OS X 10.3.8 Server and I was in the
process of building a PHP / MySQL website. After numerous connection
issues with the MySQL server I decided to take a look at the status of
my tables to check for corruption.
After running myisamchk I managed
I have MySQL 4.1.8 installed on OS X 10.3.8 Server and I was in the
process of building a PHP / MySQL website. After numerous connection
issues with the MySQL server I decided to take a look at the status of
my tables to check for corruption.
After running myisamchk I managed to loose all my d
#x27;" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, November 18, 2003 2:51 PM
Subject: RE: table crash (error127) using v4.0.15 & JDBC
> Are the crashes occurring on the same machines? Or random machines? Can
you
> track the disk activity at the time the ta
5:52 AM
To: [EMAIL PROTECTED]
Subject: table crash (error127) using v4.0.15 & JDBC
Hi
I'm working with mysql 4.0.15 for some software of ours and we are
experiencing a random table crash.
we have 30 MyISAM tables in our database and we're using JDBC to connect to
them.
Sometime
Hi
I'm working with mysql 4.0.15 for some software of ours and we are experiencing a
random table crash.
we have 30 MyISAM tables in our database and we're using JDBC to connect to them.
Sometimes, very rarely, one of the tables crashes. It has nothing special compared to
the ot
bject: cause of table crash
Hello
I get the following errors/warnings on a table:
Table is marked as crashed
Not used space is supposed to be: 3688 but is: 3624
record delete-link-chain corrupted
corrupt
What can be the cause of this crash?
--
MySQL General Mailing List
For list
Hello
I get the following errors/warnings on a table:
Table is marked as crashed
Not used space is supposed to be: 3688 but is: 3624
record delete-link-chain corrupted
corrupt
What can be the cause of this crash?
Med vänlig hälsning/Best Regards
Datatal Utveckling AB
Jonas Gauffin
Tel direct
hi listers
i've upgraded my mysql env from 3.23.53 to 4.0.13. also, i changed os from m$ to rh
7.3. what did not change was h/ware.
since the upgrade, i often get the error message "table is marked as crashed and
should be repaired". (errno 145). i then run myisamcheck --auto-repair to fix the
- Original Message -
From: "Martin Mokrejs" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, April 05, 2002 10:41 PM
Subject: Table crash!
> Don't do this when the table is in the cache!
>
> The correct way (ope
> The table has
> mysql> select count(*) from repository;
>+--+
>| count(*) |
>+--+
>| 5673838 |
>+--+
>records inside.
>
> 1. I get table a "table crashed" whenever I try to fix it or check it with MYISAMCHK
> using -r, -o or -f parameters. And t
ORE TABLE repository FROM ...", the restore
fails and tryes to restore the table without "quicksort". MySQL server on Windows NT
4.0, Service Pach 6a crashes with drwatson.
>Fix:
None available!
>Submitter-Id:
>Originator:Ales Perme
>Organization: Noviforum Ltd.
&g
>Description:
When doing the following update I get a table crash.
>How-To-Repeat:
CREATE TABLE tester (
id int(11) auto_increment,
title varchar(100) default '',
PRIMARY KEY (id),
#If you comment out the following index, then the table is briefly marked
Greetings list,
I have a semi large table (~10gig) that when I run a select query
from the table it gives me an errno 145. So I run myisamchk on the table,
as it is a myisam table. However, my problem is, when I run myisamchk it
tells me that the table has about 20 million data records, th
16 matches
Mail list logo
