Re: 1114 : The table 'SQL43ec4_0' is full

have a look at mysql startup options. one of them is --big-tables or so, and you need to start MySQL with it. At 12:24 9.1. 2001, Daniele Cesarini wrote the following: -------------------------------------------------------------- >Hi, > >I have a table with more than 70000 records and when I do a SELECT * >from table limit 20 I receive this error. >PHP 4.0.3pl1 >Mysql 3.22.32 > >I tried to rise the amount of memory php uses, no effect > >Any help? > >-- > Daniele > >-- >PHP General Mailing List (http://www.php.net/) >To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net >For additional commands, e-mail: php-general-help@lists.php.net >To contact the list administrators, e-mail: php-list-admin@lists.php.net ------end of quote------ ____________________________________________________________ Cynic: A member of a group of ancient Greek philosophers who taught that virtue constitutes happiness and that self control is the essential part of virtue. cynic@mail.cz