[thelist] mysql: timestamp fields all changed to 11th March 2000

Dunstan Orchard dunstan at 1976design.com
Tue Nov 25 07:07:21 CST 2003

Hi there,

I recently swapped all my data from one database to another, and in the 
process I've found that most (but not all) of my dates in a TIMESTAMP 
field have changed to 11th March 2000.

My field type is:
cmnt_date timestamp(10) NOT NULL,

What I did:
[1] Exported all the tables in my original database to a sql file.
[2] Uploaded this sql file into the new database to create all the 
tables with their data.

The timestamps in the sql files are correct, but when I loaded them into 
the new db, 90% of them seem to have changed to 11th March 2000.

Can anyone tell me:

[1] Why!
[2] How to get around this without manually updating them all (which 
works, as I've started doing it)

Thanks very much - Dunstan

Dorset, England
Work: http://www.1976design.com/
Play: http://www.1976design.com/blog/
Learn: http://webstandards.org/

More information about the thelist mailing list