MySQL dates changed to 0000-00-00
Previously, on my huge table(~81000 rows), I have had `date` and `time` fields set as `VARCHAR` instead of `date/time`. All those dates were of the type `MM/DD/YY`. I changed the type from `VARCHAR` to `DATE` and `TIME` respectively and most of my dates(which had DD>=13) to **0000-00-00**.

So now, I am left with a backup I took 3 months ago(~77400 rows) and then the newer ones. Is there any way that I can restore the older dates?

The way I see it, I'll have to try updating the dates using the older `.SQL` file for those 77400 rows and after that will have to write a script to check and increment date with each passing 24 hour span in the `TIME` column.

Damn me! But I didn't have a backup taken after 12th April and didn't consider taking one while altering the database. :(
MySQL dates changed to 0000-00-00
===

Previously, on my huge table(~81000 rows), I have had `date` and `time` fields set as `VARCHAR` instead of `date/time`. All those dates were of the type `MM/DD/YY`. I changed the type from `VARCHAR` to `DATE` and `TIME` respectively and most of my dates(which had DD>=13) to **0000-00-00**.

So now, I am left with a backup I took 3 months ago(~77400 rows) and then the newer ones. Is there any way that I can restore the older dates?

The way I see it, I'll have to try updating the dates using the older `.SQL` file for those 77400 rows and after that will have to write a script to check and increment date with each passing 24 hour span in the `TIME` column.

Damn me! But I didn't have a backup taken after 12th April and didn't consider taking one while altering the database. :(