Database has some very large temporary tables in it

[afeuer]

I was looking through the database today and I noticed that it was over 350mb. When I started looking at the files, I noticed that there was a lot of temporary tables. Some of the biggest culprits are tempnotetable.MYD @ 99MB, tempcmtable.MYD @ 93MB and tempdttable.MYD @ 48 MB. These files are way bigger than any of the actual data tables. I was wondering if they might be from any of my really bad attempts at writing querys or maybe from the conversion from mogo. Either way I would like to get rid of them to speed up my backup. Any suggestions?

Thanks,
Adam

[jordansparks]

Yes, probably from writing queries. Stop the mysql service, and then VERY CAREFULLY AND SLOWLY delete the database files that start with "temp". Restart the mysql service.