Re: delete temp data...

2004-05-20 Thread I D
Jonathan Villa wrote: I'm administering a Red Hat machine which is used soley for MySQL. The person working with the db has more than 15 million records in various tables...they were trying to run some queries to create one table from these many tables. When this was happening, they ran out of di

Re: delete temp data...

2004-05-20 Thread Ware Adams
Jonathan Villa wrote: > >in /usr/local/mysql/data there is one dir named the same as the db >they are working on, then there is this other file called ibdata1 >which is 2.1G in size.I take a look at the first few lines and all >I get is garbled data, as if it were a binary file or something.

delete temp data...

2004-05-20 Thread Jonathan Villa
I'm administering a Red Hat machine which is used soley for MySQL. The person working with the db has more than 15 million records in various tables...they were trying to run some queries to create one table from these many tables. When this was happening, they ran out of disk space. They had abo