Database take too much hard drive space

2004-01-13 Thread Xavier Fernández i Marín
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

Re: Database take too much hard drive space

2004-01-13 Thread walt
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 change

MySQL running out of Hard drive space

2002-04-30 Thread Mike Mike
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

RE: MySQL running out of Hard drive space

2002-04-30 Thread Lopez David E-r9374c
[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. How do I

Hard Drive Space

2001-03-02 Thread Dave Loisel
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]

Re: Hard Drive Space

2001-03-02 Thread Steve Ruby
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 corrupted.