Repair with keycache

2005-02-15 Thread Mohamed Badri
Hi, just had a problem with a myisam table who reached 4GB of data, I increased the number of rows by doing : ALTER TABLE foo MAX_ROWS=10 mysql server created some temporary files on disk ( 3 hours ) #sql-7ad2_d6cb95.MYD #sql-7ad2_d6cb95.MYI #sql-7ad2_d6cb95.frm and now the process

Re: Repair with keycache

2005-02-15 Thread Mohamed Badri
thank you for the links, I can't change system variables at runtime, so the only choice I have is, probably, to stop mysql server set variables and then run another ALTER TABLE. ;-( I'm going to siwtch to mysql4 as soon as possible. Selon Kevin A. Burton [EMAIL PROTECTED]: Mohamed Badri

Partial replication

2004-09-13 Thread Mohamed Badri
Hi, I have a question about Mysql replication, I wanted to know how can I replicate a part of a Table data between 2 databases in mysql4, and not the all tables data. I already set mysql replication between the databases, and its worked fine, But I need to filter data to replicate based on