Mysql Directory taking up a lot of space

R

romanus

Well-Known Member
Jul 17, 2004
68
0
156
Can anyone tell me wether its safe for me to delete host-bin.001 type files and what are they? I am also wondering if it is safe to delete a .err and .pid file?

I have about 12gig of these files dating back 4 months.

Thanks for your help
 
AndyReed

AndyReed

Well-Known Member
PartnerNOC
May 29, 2004
2,217
4
193
Minneapolis, MN
romanus said:
Can anyone tell me wether its safe for me to delete host-bin.001 type files and what are they? I am also wondering if it is safe to delete a .err and .pid file?

I have about 12gig of these files dating back 4 months.
Click to expand...
Yes, you can delete those files, unless you're running a master/slave replication setup.

Check your mysql variables SHOW VARIABLES for log_bin, make sure it's off. You can also disable that in /etc/my.cnf. It's not required for MySQL to run, any way.
 
Last edited:
You must log in or register to reply here.
Thread starter Similar threads Forum Replies Date
S How to store mysql 'slow_query_log' file under '/var/log' directory Databases 1
G Directory /var/run/mysqld deleted after server reboot (Graceful Server Reboot) Databases 10
B In Progress [CPANEL-26532] The user “mysql” cannot write to the configured temporary file directory Databases 5
O mysqli_connect(): (HY000/2002): No such file or directory Databases 1
W Home Directory and MySQL space Databases 3
Similar threads
How to store mysql 'slow_query_log' file under '/var/log' directory
Directory /var/run/mysqld deleted after server reboot (Graceful Server Reboot)
In Progress [CPANEL-26532] The user “mysql” cannot write to the configured temporary file directory
mysqli_connect(): (HY000/2002): No such file or directory
Home Directory and MySQL space
Top Bottom