如何复制数据库 [英] How to copy a database
问题描述
我需要
1)复制整个mysql数据库,包括表格结构和数据
2)将其安装到另一台机器上的anotehr mysql数据库中
怎么样?
或者直接指导我这个网络资源。
试图到达Kolinahr,torjon写道:
我需要
1)复制整个mysql数据库,包括表格结构和数据
2 )将它安装到另一台机器上的anotehr mysql数据库中
如何?
或者至少可以直接向我发送关于此的网络资源。
>
我猜你正在寻找mysqldump ...
-
#Peace和长寿...
Registeret Linux用户#292411
On Sun,2004年4月4日21:25:14 +0200,Andreas Paasch
< An *****@Paasch.Net>写道:
试图到达Kolinahr,torjon写道:
我需要
1)复制整个mysql数据库,包括表格结构和数据
2)将其安装到另一台机器上的anotehr mysql数据库中
如何?
或者至少可以直接向我发送关于此的网络资源。 / blockquote>
我猜你正在寻找mysqldump ......
#Peace和长寿...
Registeret Linux用户#292411
我已经阅读了文档,并且有很多关于如何转储的信息,但没有
如何从该转储恢复。你知道语法吗?
顺便说一句,当我进行转储时,转储转到什么目录 - 数据库的根目录
?
谢谢!! ps我正在使用Windows,msdos提示。对不起
On Sun,2004年4月4日21:25:14 +0200,Andreas Paasch
< An *** **@Paasch.Net>写道:
试图到达Kolinahr,torjon写道:
我需要
1)复制整个mysql数据库,包括表格结构和数据
2)将其安装到另一台机器上的anotehr mysql数据库中
如何?
或者至少可以直接向我发送关于此的网络资源。 / blockquote>
我猜你正在寻找mysqldump ......
#Peace和长寿...
Registeret Linux用户#292411
我已经阅读了文档,并且有很多关于如何转储的信息,但没有
如何从该转储恢复。你知道语法吗?
顺便说一句,当我进行转储时,转储转到什么目录 - 数据库的根目录
?
谢谢!! ps我正在使用Windows,msdos提示。对不起
I need to
1)Copy an entire mysql database, including table structres and data
2)install it into anotehr mysql db on another machine
How?
Or at lease direct me to net resources about this.解决方案Attempting to reach the Kolinahr, torjon wrote:
I need to
1)Copy an entire mysql database, including table structres and data
2)install it into anotehr mysql db on another machine
How?
Or at lease direct me to net resources about this.
I guess you are looking for mysqldump ...
--
#Peace and long life ...
Registeret Linux user #292411
On Sun, 04 Apr 2004 21:25:14 +0200, Andreas Paasch
<An*****@Paasch.Net> wrote:
Attempting to reach the Kolinahr, torjon wrote:I need to
1)Copy an entire mysql database, including table structres and data
2)install it into anotehr mysql db on another machine
How?
Or at lease direct me to net resources about this.
I guess you are looking for mysqldump ...
--
#Peace and long life ...
Registeret Linux user #292411
I''ve read the docs and there''s lots of info on how to dump, but not
how to restore from that dump. Do you know the syntax?
By the way, when I do a dump, what dir does the dump go to--the root
of the db?
Thanks!! ps I''m using windows, msdos prompt. Sorry
On Sun, 04 Apr 2004 21:25:14 +0200, Andreas Paasch
<An*****@Paasch.Net> wrote:
Attempting to reach the Kolinahr, torjon wrote:I need to
1)Copy an entire mysql database, including table structres and data
2)install it into anotehr mysql db on another machine
How?
Or at lease direct me to net resources about this.
I guess you are looking for mysqldump ...
--
#Peace and long life ...
Registeret Linux user #292411
I''ve read the docs and there''s lots of info on how to dump, but not
how to restore from that dump. Do you know the syntax?
By the way, when I do a dump, what dir does the dump go to--the root
of the db?
Thanks!! ps I''m using windows, msdos prompt. Sorry
这篇关于如何复制数据库的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!