ERROR 1114: The table 'SQLb07dc_0' is full

[Chappuis J.-Vincent]

Hi,
I have this error when I execute a query : ERROR 1114: The table 'SQLb07dc_0' is full
I can execute other queries without problems but when I want to execute the query :

SELECT DISTINCT person.*
FROM person, training, cursus 
where training.BRANCH_ID=101
and training.CURSUS_SID=cursus.CURSUS_SID 
and cursus.STUDENT_SID=person.PERSON_SID;
 
there is always the same error message. 
How can I do to reset the table 'SQLb07dc_0' or to reset the sql buffer ?
 
Regards 

table history or tracabitity

[Chappuis J.-Vincent]

Hi all !

I have a problem : I have a table "my_table". 
desc my_table :

FieldType NullKeyDefaultExtra  
mytable_sidint(11) 
auto_increment 
value  double (6.2) 

this is the table sturcture 2 weeks ago

Today the table structure is this one :

FieldType NullKeyDefaultExtra  
mytable_sidint(11) 
auto_increment 
value  int(11)
 
I would like to know when the fields value has been changed and by wich user ?
Does it exist a trace or an history of the tables in mysql database ?

If yes,  how do do it ?

regards 

jv