Programming This forum is for all programming questions.
The question does not have to be directly related to Linux and any language is fair game. |
Notices |
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
Are you new to LinuxQuestions.org? Visit the following links:
Site Howto |
Site FAQ |
Sitemap |
Register Now
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
|
 |
09-18-2007, 08:46 AM
|
#1
|
Member
Registered: Feb 2004
Location: Athens, Greece
Distribution: Gentoo,FreeBSD, Debian
Posts: 705
Rep:
|
(my)sql: drop database doesn't remove database
Hi,
i am working on a DB. I drop it and rebuild/repopulate it quite often. However, i have noticed, that when dropped, no space is freed from the HD.
What's the problem?
|
|
|
09-19-2007, 09:09 AM
|
#2
|
Senior Member
Registered: Jan 2005
Location: Roodepoort, South Africa
Distribution: Ubuntu 12.04, Antix19.3
Posts: 3,797
|
How do you know that? Output of df or du? Or do you still see the files?
I posted a link in http://www.linuxquestions.org/questi...d.php?t=555519 that explains why there might be differences between du and df. Might apply to your sitation as well.
PS not really a programming question inmy opinion.
Last edited by Wim Sturkenboom; 09-19-2007 at 09:12 AM.
|
|
|
09-19-2007, 10:59 AM
|
#3
|
Member
Registered: Feb 2004
Location: Athens, Greece
Distribution: Gentoo,FreeBSD, Debian
Posts: 705
Original Poster
Rep:
|
I posted in this subforum by mistake; it is because i usually post my mysql questions here.
As far as my problem is concerned, i am using "df". In this case, "du -ca /" gives me ~40GB used and and "df" ~80GB.
|
|
|
09-19-2007, 01:32 PM
|
#4
|
Member
Registered: Sep 2005
Distribution: LFS
Posts: 60
Rep:
|
From http://dev.mysql.com/doc/refman/4.1/...-database.html:
Quote:
If other files or directories remain in the database directory after MySQL removes those just listed, the database directory cannot be removed. In this case, you must remove any remaining files or directories manually and issue the DROP DATABASE statement again.
|
My guess is that mysqld user does not have permission to delete the database files.
|
|
|
All times are GMT -5. The time now is 04:18 PM.
|
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.
|
Latest Threads
LQ News
|
|