>>>>Does anyone know if it's possible to recover deleted records from a mySQL table - and if so, how do ya do it?
>>>>
>>>>Thanks!
>>>
>>>If MySQL is like SQL Server - No.
>>
>>That's what I thought...thanks.
>
>Hi Victor
>
>Please don't be offended if you already know this, but you may consider taking a similar approach in vfp and remote databases. When a record is deleted by a user, stamp it with a date/time. Then have a purging routine dump or even archive records that are older than x days.
>
>In vfp, I so stamp "deleted" records and then I physically delete and pack them later. This empowers the users to recover things on their own.
Well that's how I normally do it.
There is a timestamp field in the mySQL database and my routine deletes records more than 7 days old, but for some reason it looks like either a few 100 records that shouldn't of been deleted were, or the person who pulled the data down simply messed up. There is no place for the user to enter the 'delete from' date, and I steped though my program to make sure all the paramaters for my remote view looked correct which they are.
I'm begining to think its a 'human factor' problem.
ICQ 10556 (ya), 254117