Shit no. Thanks, I did backup :) Tarjei
"Fournier Jocelyn [Presence-PC]" wrote: > > Hi, > > Did you run isamchk with mysql shut down ? (it's needed otherwise you'll > corrupt your table) > > Regards, > Jocelyn > ----- Original Message ----- > From: "Tarjei Huse" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Sunday, January 13, 2002 4:54 PM > Subject: Re: big problem with mysqldb > > > > - At what size of the DB does it fail? > > ?? do you mean the size of the database? > > > > > - Do you have enough disk space for all those records? > > Yes. > > > And then: > > > > > > Have you run CHECK TABLE on your tables? > > midgardstaging.topic check error The handler for the table doesn't support > > check/repair > > > Which statements fail? > > > > > What is the structure of the tables involved? > > Table Action Records Type Size > > article nr recods: 1,094 ISAM size: 3.7 MB > > page nr recods: 286 ISAM size: 703.3 KB > > > > > And most important of all: What is the error message > > > you get? > > > > > > > 2. Mysqldump does not dump the compleat tables. > > > > > > Which command do you use when running mysqldump? > > > What is missing? > > whole records. > > isamchk -e -o page.ISM > > I get: > > Found block with too small length at 2249; Skipped > > Found block with too small length at 49885; Skipped > > Found block with too small length at 62010; Skipped > > Found link that points at 1868710169 (outside data file) at 63660 > > Found block with too small length at 64030; Skipped > > Found block with too small length at 64050; Skipped > > Found block with too small length at 71453; Skipped > > Found link that points at 1952535311 (outside data file) at 76081 > > Found link that points at 1869889801 (outside data file) at 85331 > > Found link that points at 1785483012 (outside data file) at 85568 > > Found link that points at 1060896819 (outside data file) at 85573 > > Found block with too small length at 96345; Skipped > > Found link that points at 1869304580 (outside data file) at 96742 > > Found link that points at 1060896819 (outside data file) at 96747 > > Found link that points at 1684956426 (outside data file) at 98542 > > Found link that points at 1685013256 (outside data file) at 100089 > > Found block with too small length at 100703; Skipped > > Found block with too small length at 103330; Skipped > > Found block with too small length at 103464; Skipped > > Found block with too small length at 103469; Skipped > > Found block with too small length at 110131; Skipped > > Found link that points at 1937072644 (outside data file) at 116672 > > Found link that points at 1060896869 (outside data file) at 116677 > > Found block with too small length at 121234; Skipped > > Found block with too small length at 259446; Skipped > > Found link that points at 2037138960 (outside data file) at 316114 > > Found block with too small length at 317694; Skipped > > Found block with too small length at 317810; Skipped > > Found block with too small length at 318914; Skipped > > Found block with too small length at 320717; Skipped > > Found block with too small length at 326437; Skipped > > Found block with too small length at 327235; Skipped > > Found block with too small length at 327251; Skipped > > Found block with too small length at 332383; Skipped > > Found link that points at 1952871756 (outside data file) at 336925 > > Found link that points at 1818586217 (outside data file) at 354634 > > Found link that points at 538976288 (outside data file) at 368192 > > Found block with too small length at 401884; Skipped > > Found link that points at 1852270956 (outside data file) at 410866 > > Found block with too small length at 412086; Skipped > > Found block with too small length at 415513; Skipped > > Found block with too small length at 420405; Skipped > > Found block with too small length at 434583; Skipped > > Found block with too small length at 435551; Skipped > > Found block with too small length at 448955; Skipped > > Found link that points at 1006658816 (outside data file) at 460282 > > Found block with too small length at 461319; Skipped > > Found link that points at 1785491204 (outside data file) at 461883 > > Found link that points at 1060896792 (outside data file) at 461888 > > Found block with too small length at 468037; Skipped > > Found block with too small length at 520312; Skipped > > Found link that points at 1600415597 (outside data file) at 601955 > > Found block with too small length at 609236; Skipped > > Found block with too small length at 609241; Skipped > > Found block with too small length at 609640; Skipped > > Found link that points at 1701999620 (outside data file) at 626125 > > Found link that points at 1060900833 (outside data file) at 626130 > > Found block with too small length at 661866; Skipped > > Found block that points outside data file at 669603 > > Found block that points outside data file at 673841 > > Found block that points outside data file at 678463 > > Found block that points outside data file at 683373 > > Found block with too small length at 683390; Skipped > > Found block that points outside data file at 690679 > > Found block that points outside data file at 693446 > > Found block that points outside data file at 697102 > > Found block that points outside data file at 704604 > > Found block that points outside data file at 708929 > > > > Now what do I do?? > > > > > > > > > / Carsten > > > -- > > > Carsten H. Pedersen > > > keeper and maintainer of the bitbybit.dk MySQL FAQ > > > http://www.bitbybit.dk/mysqlfaq > > > > --------------------------------------------------------------------- > > 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 > > > > --------------------------------------------------------------------- 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
