Greetings

for a while I simply can not import properly timestamp data back to
database. I dump all databases with mysqldump --opt --all-databases >
backup.sql and backup file is correctly created. All my tables have
timestamp column since VB programs and MyODBC do not work properly
without it. When I import data back, every timestamp column is
restored to 0000-00-00 00:00:00. That is incorrect data and time
format and my application fails since MyODBC doesn't work properly. I
need to find a way to back up full database structure but dump every
field except timestamp fields or I must find a way to restore old
timestamp values. Anything but 0000-00-00 00:00:00.

Thank you all,
Bruno