I stumbled across an old website log system I wrote a couple of months back when I was cleaning up old code and I noticed a field type in MySQL was set to 'Text' for a date entry. Immediatly I changed this to a 'Date' type and it set ALL current entries in the table to '00-00-0000'. But when I changed it back to 'Text' it still remained. Have I lost the original data indefinetly or is there a way to recover it?
Regards,
Have I lost data from my database indefinetly?
Moderator: General Moderators
Does your mysql server by any chance keep a binary log? see http://dev.mysql.com/doc/internals/en/r ... y-log.html
Now is the perfect time to develop and establish a backup plan.
Now is the perfect time to develop and establish a backup plan.