Xavier Fernández i Marín wrote:
>
> Hi,
>
> I've been inserting a csv file of about 150Mb into a mysql database. The
> problem is that there is no enough free space on the hard disk, and the
> process have been collapsed.
>
> Now I've been trying to access to the database to drop the table and c
Hi,
I've been inserting a csv file of about 150Mb into a mysql database. The
problem is that there is no enough free space on the hard disk, and the
process have been collapsed.
Now I've been trying to access to the database to drop the table and change
the directory where mysql stores the inf
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 30, 2002 7:17 AM
To: [EMAIL PROTECTED]
Subject: MySQL running out of Hard drive space
Hello,
I have made a couple of partisions in Linux. Somehow
MySQL got installed in a partision that doesn't have a
lot of space and i'm running very low
Hello,
I have made a couple of partisions in Linux. Somehow
MySQL got installed in a partision that doesn't have a
lot of space and i'm running very low. How do I add
more space to that directory or partision?
I have a lot of space on my user partision and my home
partition. Is there a command in
Dave Loisel wrote:
>
> I have filled my hard drive by inserting data into a table (15 gigs).
>
> The table was then corrupted.
>
> I have freed 1 gigs to repair the table and there is nothing else to delete.
>
> How can I repair my table?
>
If you mean that 1 gig is not enough free space, the
It depends on your table type, check the manual, you will want
myisamchk or isamchk if you are using 3.23.x you can do SQL
REPAIR TABLE so long as your table is MyISAM.
Dave Loisel wrote:
>
> I have filled my hard drive by inserting data into a table (15 gigs).
>
> The table was then corrupte
I have filled my hard drive by inserting data into a table (15 gigs).
The table was then corrupted.
I have freed 1 gigs to repair the table and there is nothing else to delete.
How can I repair my table?
__
Dave Loisel
DBA
Wanted technologies
[EMAIL PROTECTED]
---
