Re: The table 'SQLa0f9_0' is full. Any reason?

roy woods wrote: > > Hello > > I got an error which says that one of the table is > full. I do not know why. The database is Mysql with > Linux operating system. There is no error when with > the other tables. The exact error message is: > > The table 'SQLa0f9_0' is full. > > The error number is 1114. > > Why this is happening? There is nothing wrong with the > script itself. It was ok few days ago and there was no > error. By the way, if you know the error number > returned from mysql database, could you track down the > error? And how? > Check the Mysql Documentation... :) but seriously what is happening is that the temprary table is filling up. That explains why you probaly don't recognise the name name.. (you never did say...) Have a look at http://www.mysql.com/documentation/mysql/bychapter/manual_Problems.html#Full_table Symptom, description of the problem and the soltion in just a few paragraphs.... -- george@laopdr.com Network Administrator Planet Online Vientiane, Lao PDR