Thanks, I'll try that! Robert
On Tue, 2003-01-14 at 14:54, Dyego Souza do Carmo wrote: > Dobrý den, > terça-feira, 14 de janeiro de 2003, 16:58:08, napsal jste: > > RC> I'm new to administering MySQL, so bear with me: > > RC> We run a large MySQL database with one of the tables amassing > RC> over 40 million entries. It somehow got corrupt and now I'm > RC> running isamchk -o (-r failed) and it's in its 110th hour and > RC> it's getting slower. I'm running 3.23.38 and cannot upgrade > RC> due to compatibility issues. Also, the tables are quite old > RC> and are in ISAM format. Here's a couple of questions: > > RC> Will stopping the repair midway affect the data/table? > > Upgrade to 3.23.54 ( 3.23.54 is compatible with 3.23.38 ) > > RC> Can I convert a corrupted table to MyISAM? > > yes... run the command: ALTER TABLE table_name Type=MyISAM; > the mysql atomically creates a MyISAM table and new index to the table > > RC> How will that affect my data? > Your data in MyISAM is more safe than ISAM > > RC> Will myisamchk run faster in fixing the corruption (in general, > RC> I know there's not enough information)? > more less. > > Upgrade your mysql to 3.23.54 ( max ) and use the InnoDB tables ( > http://www.innodb.com ), this table type is VERY SECURE than MyISAM. > The InnoDB tables are stored in a tablespace and have a "crash > recovery". To convert your tables from ISAM to Innodb is simple. > > 1 - Configure the InnoDB options em my.cnf > 2 - run ALTER TABLE table_name Type=InnoDB; > > and have fun ! ;) > > ps: ISAM support is deprecated and is not present in next version of > mysql ( 4.x ) > > sql,query > > ------------------------------------------------------------------------- > ++ Dyego Souza do Carmo ++ Dep. Desenvolvimento > ------------------------------------------------------------------------- > E S C R I B A I N F O R M A T I C A > ------------------------------------------------------------------------- > The only stupid question is the unasked one (somewhere in Linux's HowTo) > Linux registred user : #230601 > -- > $ look into "my eyes" > look: cannot open my eyes > ------------------------------------------------------------------------- > Reply: [EMAIL PROTECTED] > --------------------------------------------------------------------- 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
