MySQL Time is not resolved in YAML

[anrichter]

The generated .yml files doesn't contain the right values for time fields in a mysql database. For example the created_at and updated_at fields.

Here is a part from a yml file:
updated_at: !ruby/object:Mysql::Time {}

ActiveRecord::Base.connection.select_all generate an array with hashes. The value for the time fields in the hashes is a Mysql::Time instead of an string. I think YAML.dump can't convert an instance from Mysql::Time into a string.

It would be nice, if you can fix this bug.

[mattconnolly]

Thanks for reporting this bug. It seems that mysql time objects really don't play nice with yaml in ruby 1.9.3 and appear as empty objects {}.

Can you try add this to your gem file:

gem 'rails-backup-migrate', :git => "git://github.com/mattconnolly/rails-backup-migrate.git", :branch => "7-mysql-times"

and then bundle exec rake site:backup and bundle exec rake site:restore and let me know if it works.

This might slow it down if you have a large data set. But more important for it to work.

[anrichter]

Ok. Thanks for the fix. It worked like a charm :)