Big MySql Problem!

[Anon]

hi all,
iam using php and mysql
actually i have a table caleld report with 3 fields:
1.date stored as varchar(30)
2.username varchar(30)
3.task text
none of them is s a primary key also

wanted to change the date column to something other name such as repdate and also the column type of date field to 'date'

i executed the following command;

alter table report change date repdate varchar(30);
alter table report modify repdate date;

					it was succesful and now the date coulmn became repdate and stored as date 

but whatevr existing date was there are changed to 0000-00-00
iam shocked,all my dates are gone
nearly 200 rows i had and all the dates are now zero zero

how do i get back my dates back?
please help me

                            Regards 
                            roopa

[tomhath]

I don't know of any way to repair the table, other than to restore from a backup.

Probably too late to help you now, but this is why you should back up the database often, and always to this kind of administration on a test database first; and update the live database only after you just backed it up and are sure you can restore the backup. You'd be surprised how often people find their backups don't restore.