| View previous topic :: View next topic |
| Author |
Message |
Rukie
l33t
Joined: 26 Jan 2004
Posts: 692
Location: SE Wi, Home of cheese and cowtippers.......
|
 Posted: Thu Jan 25, 2007 3:58 pm Post subject: mysql and large files.... harddrive full! |
 |
|
Alright, I wanted to install wikipedia on my laptop. After numerous attempts and deleting of the tables and starting over again, my harddrive has become increassingly full with the same crap, again and again and again.
My harddrive is like 99.999999 percent full after I deleted one or two tiny little files...
So I ask you know, how do I delete these previous mysql databases that... haven't really been deleted when I used "delete from page;"
Thanks for a nyhelp.
_________________
Gentoomania! Support the Open Source!
http://www.rukie.ath.cx |
|
| Back to top |
|
 |
martin20450
Tux's lil' helper
Joined: 30 Sep 2005
Posts: 91
|
| Posted: Thu Jan 25, 2007 4:22 pm Post subject: |
|
|
| You can use mysqldump to dump any legitimate tables you have going on, then simply remove /var/lib/mysql/* |
|
| Back to top |
|
|
Rukie
l33t
Joined: 26 Jan 2004
Posts: 692
Location: SE Wi, Home of cheese and cowtippers.......
|
| Posted: Thu Jan 25, 2007 4:24 pm Post subject: |
|
|
alright, what will mysqldump actually do? save the tables or w hat?
_________________
Gentoomania! Support the Open Source!
http://www.rukie.ath.cx |
|
| Back to top |
|
|
jmbsvicetto
Moderator
Joined: 27 Apr 2005
Posts: 4735
Location: Angra do Heroísmo (PT)
|
|
| Back to top |
|
|
martin20450
Tux's lil' helper
Joined: 30 Sep 2005
Posts: 91
|
| Posted: Thu Jan 25, 2007 4:28 pm Post subject: |
|
|
If you don't have any databases that you need to save then don't worry about the mysqldump, it can be used to save the databases you want, eg mysqldump wantedTable > wantedTable.sql.
So if this is purely for your wikipedia then rm /var/log/mysql/* -rf && emerge --config mysql (Not sure on that one but think that's right). |
|
| Back to top |
|
|
Rukie
l33t
Joined: 26 Jan 2004
Posts: 692
Location: SE Wi, Home of cheese and cowtippers.......
|
| Posted: Thu Jan 25, 2007 4:46 pm Post subject: |
|
|
from 100% full to 29% full, thanks  Now I just ogtta reinstall mediawiki and I'm set.
_________________
Gentoomania! Support the Open Source!
http://www.rukie.ath.cx |
|
| Back to top |
|
|
Mad Merlin
Veteran
Joined: 09 May 2005
Posts: 1155
|
| Posted: Thu Jan 25, 2007 8:13 pm Post subject: |
|
|
You probably had lots of binary logs left over. The binary log is a record of every SQL statement that could have possibly changed a table. The easier way to clear them out is to issue a
to mysql.
_________________
Game! - Where the stick is mightier than the sword! |
|
| Back to top |
|
|
Rukie
l33t
Joined: 26 Jan 2004
Posts: 692
Location: SE Wi, Home of cheese and cowtippers.......
|
| Posted: Thu Jan 25, 2007 11:26 pm Post subject: |
|
|
shucks, too late  thanks for future reference tho.
_________________
Gentoomania! Support the Open Source!
http://www.rukie.ath.cx |
|
| Back to top |
|
|
pteppic
l33t
Joined: 28 Nov 2005
Posts: 781
|
| Posted: Fri Jan 26, 2007 11:15 am Post subject: |
|
|
| Mad Merlin wrote: | | You probably had lots of binary logs left over. |
Or you could just comment out 'log-bin' from your /etc/mysql/my.cnf after you remove the binary logs. |
|
| Back to top |
|
|
Janne Pikkarainen
Veteran
Joined: 29 Jul 2003
Posts: 1143
Location: Helsinki, Finland
|
| Posted: Fri Jan 26, 2007 6:50 pm Post subject: |
|
|
| pteppic wrote: | | Mad Merlin wrote: | | You probably had lots of binary logs left over. |
Or you could just comment out 'log-bin' from your /etc/mysql/my.cnf after you remove the binary logs. |
Or if you want to have a small backlog just in case, you might want to run something like this in cron:
| Code: | | PURGE MASTER LOGS BEFORE NOW() - INTERVAL 20 HOUR; |
_________________
Yes, I'm the man. Now it's your turn to decide if I meant "Yes, I'm the male." or "Yes, I am the Unix Manual Page.". |
|
| Back to top |
|
|
|
Networking & Security
