By gausarts on

Has anybody experienced a growing size of mysql-bin.000... files in WAMP? They are located in wamp/mysql/mysql version/bin/data along with other database folders. It' s reaching 45GB now in my disk, consuming lots of spaces. I am on vista, this vista alone has real problem with shadow copies :(

I've searched mysql forum (http://forums.mysql.com/read.php?22,20962,86454#msg-86454), and wamp forum (saying, endless Your search is running, please be patient :), but can't find related except for that host-bin stuff. This doesn't happen to xampp before.

What should I do with the files? Anyone experienced with WAMP here? Sorry if wrong forum anyway. Just in case I can get a light here.

Thanks for any hint.

Comments

WorldFallz’s picture

WorldFallz commented

First result in google (using mysql-bin.000): http://forums.mysql.com/read.php?26,127650,127650

gausarts’s picture

gausarts commented

Ah, perfect wording. I typed "wamp mysql-bin.000" before I ask to less relevant results. Thanks for the light.

love, light n laughter

WorldFallz’s picture

WorldFallz commented

yep-- i find less is often more when searching. Start out with the bare minimum and then gradually add terms if you have to in order to narrow down results.

dc1258’s picture

dc1258 commented

I was wondering what your end result was on this. Did you just delete the older files labeled "mysql-bin.0000..." and haven't had a problem? Is there any logical reason to keep them?

Also any idea when these files are made? Like what activities are done to make them?

khanz’s picture

khanz commented

try running these commands in mysql console

mysql> FLUSH LOGS;

mysql> RESET MASTER;

dependind on size it might take some time to clear the logs.

------------
Volvo, Video, Velcro. (I came, I saw, I stuck around.)

gausarts’s picture

gausarts commented

Hi,

I tried purging the bin as said here http://dev.mysql.com/doc/refman/5.0/en/purge-binary-logs.html

And the wonder is it only takes a flash to purge 42GB. Never crossed my mind how quickly it grows and deleted :)

Any possible problem I missed after purging?

Thanks

love, light n laughter

khanz’s picture

khanz commented

if there's any, i dont know about it ;)... but i have used above commands several times to purge my logs and never encountered any sort of problem.

------------
Volvo, Video, Velcro. (I came, I saw, I stuck around.)