Railsでmysqlをdump、reset、restoreする�Rakeタスク - Qiita

namespace :db do desc 'Dump the database to tmp/dbname.dump' task dump: %i[environment load_config] do config = ActiveRecord::Base.configurations[Rails.env] ignore_table_option = %w[ar_internal_metadata schema_migrations].map { |table| "--ignore-table=#{config['database']}.#{table}" }.join(' ') sh "mysqldump -u #{config['username']} -p#{config['password']} #{config['database']} --no-create-info #{