This is all about db4free.net and the database systems that it offers. The main focus are practical examples of the new features of MySQL 5 and 6 that should show you how to use them for your advantage in your daily life ;-).
I don't think that it's a bug, I can dump a table containing date/time information and re-import it and get the same results, at least on the same MySQL 5.0 server from where the dump file results. However, I created yesterday's dump file from a MySQL 4.0 server, so maybe there's some incompatibility. But with disabling tz-utc it was easy to work around this problem.
Thank you very much for clarifying this. I ran into the problem when restoring parts of a single table due to a user accidentally deleting... in case partial restores are needed, no timezone conversion makes life far more easier.
I don't think that it's a bug, I can dump a table containing date/time information and re-import it and get the same results, at least on the same MySQL 5.0 server from where the dump file results. However, I created yesterday's dump file from a MySQL 4.0 server, so maybe there's some incompatibility. But with disabling tz-utc it was easy to work around this problem.
ReplyDeleteThank you very much for clarifying this. I ran into the problem when restoring parts of a single table due to a user accidentally deleting... in case partial restores are needed, no timezone conversion makes life far more easier.
ReplyDelete