blocks|key|636834|text|如果您只处理普通数据，则可以尝试以下三种方法之一。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|636835|导出/导入CSV|offset|length|style|BOLD|636836|纯数据库方法是从各种表中进行选择，并将其放入导出文件中，以便稍后在另一端重新加载。|636837|例如：|636838|SELECT+...+FROM+...+INTO+OUTFILE+'export.csv'+FIELDS+TERMINATED+BY+','+OPTIONALLY+ENCLOSED++BY+'"'+LINES+TERMINATED+BY+'\n'|code-block|syntax|javascript|636839|这将创建一个CSV格式的导出文件，您可以稍后在其他系统上重新加载：|636840|LOAD+DATA+INFILE+'export.csv'+INTO+TABLE+...+FIELDS+TERMINATED+BY+','+OPTIONALLY+ENCLOSED++BY+'"'+LINES+TERMINATED+BY+'\n'|636841|这需要直接访问您的MySQL服务器，但如果成功，速度会非常快。BINARY或BLOB类型字段不适用于CSV，因为它们与分隔符冲突。|CODE|636842|导出/导入YAML|636843|每个模型都能够将自身输出为序列化的YAML。基本上，您可以在一端转储所有需要的对象，然后在另一端重新加载。|636844|File.open('dump.yml',+'w')+do+%7Cf%7C
++f.write(Object.where(:attribute+=>+'condition').all.to_yaml)
end|636845|您可以在另一端重新加载这些内容：|636846|File.open('dump.yml')+do+%7Cf%7C
++Object.transaction+do
++++YAML.load(f).each+do+%7Cattributes%7C
++++++Object.create!(attributes)
++++end
++end
end|636847|Object.transaction部分意味着要么添加所有记录，要么不添加任何记录，因此如果出现错误，您可以更正它并再次运行脚本，而不会发生冲突。|636848|SQL转储/恢复|636849|mysqldump命令接受可用于过滤记录的--where参数：|636850|mysqldump+database+table+--no-create-db+--no-create-info+--where+`attribute='condition'`+>+table.sql|636851|这应该只有INSERT语句，但请检查以确保。|636852|entityMap^0|0|0|8|0|0|0|0|0|0|V|6|12|4|0|0|9|0|0|0|0|0|0|I|0|0|8|0|0|9|L|7|0|0|5|6|0^^$0|@$1|2|3|4|5|6|7|1J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1K|8|@$D|1L|E|1M|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|1N|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|1O|8|@]|9|@]|A|$]]|$1|L|3|M|5|N|7|1P|8|@]|9|@]|A|$O|P]]|$1|Q|3|R|5|6|7|1Q|8|@]|9|@]|A|$]]|$1|S|3|T|5|N|7|1R|8|@]|9|@]|A|$O|P]]|$1|U|3|V|5|6|7|1S|8|@$D|1T|E|1U|F|W]|$D|1V|E|1W|F|W]]|9|@]|A|$]]|$1|X|3|Y|5|6|7|1X|8|@$D|1Y|E|1Z|F|G]]|9|@]|A|$]]|$1|Z|3|10|5|6|7|20|8|@]|9|@]|A|$]]|$1|11|3|12|5|N|7|21|8|@]|9|@]|A|$O|P]]|$1|13|3|14|5|6|7|22|8|@]|9|@]|A|$]]|$1|15|3|16|5|N|7|23|8|@]|9|@]|A|$O|P]]|$1|17|3|18|5|6|7|24|8|@$D|25|E|26|F|W]]|9|@]|A|$]]|$1|19|3|1A|5|6|7|27|8|@$D|28|E|29|F|G]]|9|@]|A|$]]|$1|1B|3|1C|5|6|7|2A|8|@$D|2B|E|2C|F|W]|$D|2D|E|2E|F|W]]|9|@]|A|$]]|$1|1D|3|1E|5|N|7|2F|8|@]|9|@]|A|$O|P]]|$1|1F|3|1G|5|6|7|2G|8|@$D|2H|E|2I|F|W]]|9|@]|A|$]]|$1|1H|3|-4|5|6|7|2J|8|@]|9|@]|A|$]]]|1I|$]]

If you're just dealing with plain data, you might try one of three approaches.

Export/Import CSV

The pure database approach is to select from your various tables into an export file you can use to later re-load on the other end.

For example:

<pre><code>SELECT ... FROM ... INTO OUTFILE 'export.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n'
</code></pre>

This creates a CSV-formatted export file you can later re-load on the other system:

<pre><code>LOAD DATA INFILE 'export.csv' INTO TABLE ... FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n'
</code></pre>

This requires direct access to your MySQL server, but it's very fast if successful. <code>BINARY</code> or <code>BLOB</code> type fields do not work with CSV as they conflict with the delimiters.

Export/Import YAML

Every model is capable of outputting itself as serialized YAML. You can basically dump all of the objects you need on one end, then re-load on the other.

<pre><code>File.open('dump.yml', 'w') do |f|
 f.write(Object.where(:attribute =&gt; 'condition').all.to_yaml)
end
</code></pre>

You can re-load these on the other end:

<pre><code>File.open('dump.yml') do |f|
 Object.transaction do
 YAML.load(f).each do |attributes|
 Object.create!(attributes)
 end
 end
end
</code></pre>

The <code>Object.transaction</code> part means either all records get added or none do, so if there's an error you can correct it and run the script again without conflict.

SQL Dump/Restore

The <code>mysqldump</code> command takes a <code>--where</code> argument that can be used to filter records:

<pre><code>mysqldump database table --no-create-db --no-create-info --where `attribute='condition'` &gt; table.sql
</code></pre>

This should have just <code>INSERT</code> statements, but check to be sure.

blocks|key|1001|text|您可以将备份数据库添加到database.yml中，从其中读取对象，切换回主数据库并重新创建丢失的对象。类似于：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1002|ActiveRecord::Base.establish_connection(:backup_database)

objects+=+Object.where(attribute:+'condition')

ActiveRecord::Base.establish_connection(:master_database)

objects.each+{+%7Cobject%7C+Object.create!+object.attributes+}|code-block|syntax|javascript|1003|entityMap^0|C|C|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|P|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|L|$]]

You could add the backup database to your <code>database.yml</code>, read your objects from it, switch back to the main database and re-create the missing objects. Something like:

<pre><code>ActiveRecord::Base.establish_connection(:backup_database)

objects = Object.where(attribute: 'condition')

ActiveRecord::Base.establish_connection(:master_database)

objects.each { |object| Object.create! object.attributes }
</code></pre>

I'm doing a database restore of specific objects that were destroyed. There's roughly a hundred of them. Is there an elegant way to perform this?

Ideally, I'd love to do a command such as : <code>Object.where(attribute: 'condition')</code> , and then copy the console output, and be able to console into the other database and create all my objects off of that output..

Any recommends?

Looking for an elegant way to copy cherry-picked objects from one database to another

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我正在对被销毁的特定对象进行数据库恢复。大概有上百个。有没有一种优雅的方式来实现这一点？理想情况下，我希望执行一个命令，如：Object.where(attribute: 'condition')，然后复制控制台输出，并能够通过控制台连接到其他数据库，并根据该输出创建我的所有对象。有什么建议吗？

问寻找一种优雅的方法将精心挑选的对象从一个数据库复制到另一个数据库
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问寻找一种优雅的方法将精心挑选的对象从一个数据库复制到另一个数据库EN