Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Help, mysql dropping table records


carloscanas

Recommended Posts

Posted

I'm running an online store and lately I have discovered that mysql is dropping entries from my tables. If a customer sets up an order, the order entry is completely dropped from all tables at somepoint at midnight. I have been backing up the database just before midnight and I am able to restore in the morning but it does not seem normal that all new entries are dropped. As far as I know, there are no processes running that could affect mysql unless someone has hijacked my server as I am running on a dedicated server. I even had the server completely re-imaged to eliminate any roge programs and still have the problem. Is it there a limit to mysql table size?

 

Please I need your help as I am getting desperate.

:'(

Posted
I'm running an online store and lately I have discovered that mysql is dropping entries from my tables. If a customer sets up an order, the order entry is completely dropped from all tables at somepoint at midnight. I have been backing up the database just before midnight and I am able to restore in the morning but it does not seem normal that all new entries are dropped. As far as I know, there are no processes running that could affect mysql unless someone has hijacked my server as I am running on a dedicated server. I even had the server completely re-imaged to eliminate any roge programs and still have the problem. Is it there a limit to mysql table size?

 

Please I need your help as I am getting desperate.

:'(

 

 

How is the disk space on your server?

Archived

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

×
×
  • Create New...