Re: How to summarize a table?

2005-06-19 Thread Juan Pedro Reyes Molina
Hi, Mathias Thanks for your link. Now I'm in the process of upgrading mysql from 4.0 to 4.1 in production environment. I will go for 5.0 when it is considered stable. It may help you know that in http://www.google.com/language_tools?hl=en I translated page from german to english. Machine

Got error 127 from storage engine

2005-06-19 Thread Amir Shay
Hi, Using Linux 9 with mySQL 4.1.11-standard the tables are MyISAM When trying to delete from quit large tables (millions of records) range or records (few thousands) I got the error that there is a problem in the table and we need to do a repair. Then we run the repair table which finished

Re: Got error 127 from storage engine

2005-06-19 Thread mfatene
Hi amir, you have error 127 which means : C:\perror 127 MySQL error code 127: Record-file is crashed what i suggest is to use some of the solutions given here : http://dev.mysql.com/doc/mysql/en/repair.html if you could. another way is to increase tmp_table_size and use show processlist during

Re: Backup database with MyISAM and InnoDB tables together

2005-06-19 Thread Gleb Paharenko
Hello. Among other suggestions think about such way. If you MyISAM and InnoDB tables are used by different applications or consistent state between them doesn't play big value, and the size of MyISAM tables is low enough, you could perform the dump in two steps listing the tables of the

MySQL server has gone away error?

2005-06-19 Thread Michael
I'm using PHP with MySQL to save files uploaded by users (up to 50MB) to a database. I'm having problems getting MySQL to handle this much data in a single query I guess. I was getting a *max allowed packet error so I raised that. Now I get a MySQL server has gone away error. Can anyone tell