I'm running considerably larger and more complex databases on the same MySQL server with no memory problems, CPU issues or limitations that would adversely effect this database.
Well PS3 shouldn't do any auto delete and I know there is no admin area to do that, unless you deleted the item options and their values one by one. Trust me, I did not go in and take the time to delete all my options and their values one by one. Never the less, your application errored somehow or MySQL threw an error and deleted the values for just a few tables, which seems unlikely. But then I have never heard of something like this, nor have any of my programers on staff. Somehow the options and their associated values all disappeared in a matter of seconds. I checked IP's that have logged into the database to see if anyone hacked the database, and only know IP's have logged in. Still not ruling that out.
Please see attached logs and see if there is anything in them that you notice that is abnormal. Note how few seconds it took for the options to be deleted.
I've attached screenshots of the tables that show the ID's and the current new values so you can get an idea of how I'm using the options for this website.
I'd appreciate any help you can give me. This site is supposed to be live next week and I'm nervous to tell the client it's ready to go and have their website lose info.