Options disappeared from database
I've been adding all my products to my PS3 store and each item has two options. I add the "color" option first and the "size" option second. The options appeared in that order until I added the options for one of the products at about the 110th item. I entered the options in the same sequence, but they appeared backwards, top to bottom. So I checked the front end of the website and all but the latest item had no options. They had all disappeared. I looked at the database tables and all of my options were gone, with the exception of the last entry. The option ID's started at number 517. So how did 516 options all delete themselves all by themselves? I need to add a couple hundred options with about 30 values per option, but I'm worried that I may loose all the data again. And what about the stability the application? I've never had a database auto delete entries like this in the 15 years I've been building websites. Please help, explain before I waste another 12 hours of work.