Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Huge files being created


ComputrGrl

Recommended Posts

I recently had a problem with my OS Commerce store -- I exceeded my disk space quota at my host because 'my-username-bin.001, my-username-bin.002, my-username-bin.003, my-username-bin.004', etc. files were being created by my OS Commerce store in my SQL directory ....... they are huge files and I am wondering if I can delete them?

 

Has anyone else had these problems or files?

Link to comment
Share on other sites

the file contains tons of the same requested information, see below for a short example of the same repeated lines of code found in the files:

 

3.23.58-log

 

insert into whos_online --- then a bunch of code and characters

insert into sessions values --- then a bunch of code and characters

update sessions set expiry --- then a bunch of code and characters

delete from whos_online where time_last_click

Link to comment
Share on other sites

Is it from the log on the server?

 

If so, contact your host company and ask them to stop duplicating the log files.

Link to comment
Share on other sites

Those files are MYSQL binary update logs. They are used for crash recovery (point in time recovery).

 

They aren't on by default, someone had to enable them for them to show up. For more info: http://www.mysql.com/doc/en/Binary_log.html

 

To safely remove them you can issue a MYSQL command like:

PURGE MASTER LOGS TO 'my-username-bin.004';

I'd rather be flying!

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...