存档的MySQL数据库转储 [英] Archived Dump of MySQL Database

问题描述

我们正计划搬到另一台服务器，并想知道是否有一种方法可以对数据库进行存档转储？


如果所以，怎么会去做这样的事情。


谢谢，

Ryan

We are planning on moving to a different server and was wondering if
there was a way to make an archived dump of the database?

If so, how would one go about doing such a thing.

Thanks,
Ryan

推荐答案

Ryan写道：

Ryan wrote:

我们正计划搬到另一台服务器，并想知道是否有办法对数据库进行存档转储？

如果是这样，怎么会做这样的事情。

We are planning on moving to a different server and was wondering if
there was a way to make an archived dump of the database?

If so, how would one go about doing such a thing.

看看这些是否满足你的需求：

http://www.mysql.com/doc/en /mysqldump.html

http://www.mysql.com/doc/en/mysqlhotcopy.html

http://www.mysql.com/doc/en/mysqlimport.html

See if these fill your needs:

http://www.mysql.com/doc/en/mysqldump.html

http://www.mysql.com/doc/en/mysqlhotcopy.html

http://www.mysql.com/doc/en/mysqlimport.html

2004年1月8日08:47 ：32 -0800，在mailing.database.mysql中
ki ******** ****@yahoo.com （Ryan）写道：

On 8 Jan 2004 08:47:32 -0800, in mailing.database.mysql
ki************@yahoo.com (Ryan) wrote:

|我们正计划搬到另一台服务器，并想知道是否
|有一种方法可以对数据库进行存档转储吗？
|
|如果是这样，怎么会去做这样的事情。
|
|谢谢，
| Ryan

| We are planning on moving to a different server and was wondering if
| there was a way to make an archived dump of the database?
|
| If so, how would one go about doing such a thing.
|
| Thanks,
| Ryan

使用mysqldump - 在bin文件夹中找到。

mysqldump -B [database] -e -F -f> [filename]


这会将表创建语句及其数据转储到文本

文件中。使用mysqldump --help查看可用选项的完整列表。

----------------------------- ----------------------------------
jn **** @ yourpantsbigpond.net.au ：脱掉裤子回复

------------- --------------------------------------------------

Use mysqldump - found in the bin folder.
mysqldump -B [database] -e -F -f > [filename]

This will dump the table create statements and its data to a text
file. Use mysqldump --help to see full list of options available.
---------------------------------------------------------------
jn****@yourpantsbigpond.net.au : Remove your pants to reply
---------------------------------------------------------------

Ryan写道：

Ryan wrote:

我们正计划搬到另一台服务器，并想知道是否有一个如何制作数据库的存档转储？

如果是这样，怎么会做这样的事情。

We are planning on moving to a different server and was wondering if
there was a way to make an archived dump of the database?

If so, how would one go about doing such a thing.

看看这些是不是满足您的需求：

http：// www.mysql.com/doc/en/mysqldump.html

http://www.mysql.com/doc/en/mysqlhotcopy.html

http://www.mysql.com/doc/en/mysqlimport.html

See if these fill your needs:

http://www.mysql.com/doc/en/mysqldump.html

http://www.mysql.com/doc/en/mysqlhotcopy.html

http://www.mysql.com/doc/en/mysqlimport.html

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