Re: Data disappearing from mysql database

[Peter Brawley]

> I don't know where it's going, but it's in the database, then it's not.

Till we've identified the rogue or error process responsible for the data losses you're seeing, we're all just guessing. Have you studied the mysql error log? The cause could be bugs in your code that have just recently met their enabling conditions, or it could be you've hit a limitation of the engine or OS you're using, or it could be sql injection as Barry suggests, or it could be a rogue user.

To find what it is, you'll need to get proactive and grow more curiosity about it than has been on display here so far, eg ...

- study the mysql error log,

- study the application's error log,

- enable the mysql general log so you have a record of every query that's executed and by whom,

- add some stubs to your code to log the changes you see appearing and disappearing.