如何复制数据库 [英] How to duplicate a DB

问题描述

亲爱的所有人，



在我的应用程序中，我在MySql Server中有一个数据库（例如MyDataBase）。让我们假设MyDatabase包含5个表，每个表都更新了一些数据。现在我想创建一个名为MyDataBase1的重复数据库，它是MyDatabase的副本，它将包含与MyDataBase相同的表和数据。我该怎么做？

请帮忙。

提前谢谢大家。



问候，

Vidi

Dear All,

In my application, I''ve a database(e.g. MyDataBase) in MySql Server. Lets assume that MyDatabase contains 5 table and each table has updated wit some data. Now i want to create a duplicate database with name MyDataBase1, duplicate of MyDatabase, which will contain same table and data as MyDataBase. How can i do this?
Please help.
Thank you all in advance.

Regards,
Vidi

推荐答案

Hii

此链接对您非常有用...只需看看......





http://stackoverflow.com/ question / 268381 / using-smo-to-copy-a-database-and-data [ ^ ]





谢谢很乐意帮助...

Hii
this link is really useful for you...just take a look...


http://stackoverflow.com/questions/268381/using-smo-to-copy-a-database-and-data[^]


Thanks Happy to Help...

您可以随时备份数据库并将其恢复到另一个数据库中 - MySqlBackup.NET - 用于C＃，VB.NET，ASP.NET的MySQL备份解决方案 [ ^ ]。

You can always take a backup of the database and restore it in another database - MySqlBackup.NET - MySQL Backup Solution for C#, VB.NET, ASP.NET[^].

我已阅读此内容



MySQL数据库复制程序 [ ^ ]

I''d have a read of this

MySQL Database Replication Procedure[^]

这篇关于如何复制数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！