Search code examples
ruby-on-railsyamlmysqldump

Best way to dump one database table with limit and all association

class Profile < ActiveRecord::Base
  has_many :favorites, :dependent => :destroy
  has_many :friends, :dependent => :destroy
end

I need smth like this: 

mysqldump --opt --where="1 limit 1000" -uroot development profiles  > profiles.sql

But this dump contains (as expected) only 1000 profiles rows, without associations friends, favorites.

Should I do it using YAML or how should I do it?

Solution

  • Take first 5000 records:

    mysqldump --opt --where="1 limit 5000" -uroot development profiles  > profiles.sql

    Then find all associated with this records friends:

    mysqldump --opt --lock-all-tables --where="profile_id IN (SELECT * FROM (SELECT id FROM profiles LIMIT 5000) temp);" -uroot development friends  > friends.sql