List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:February 19 2002 2:20am
Subject:Re: How to restore all databases in one instance?
View as plain text  
At 13:13 +1100 2/19/02, Li, Robert wrote:
>Hi, all
>As we know, we can backup all dbs in one instance
>using "mysqldump --alldatabases > all_db.sql",
>so can we restore all of these dbs from "all_db.sql" in one time?
>Mysql  client  program "mysql" can only restore one database
>per time---mysql sample_db < sample_db.sql.
>Thanks in advance.

Why do you say that?  The output from mysqldump --all-databases includes
the appropriate USE statements to switch databases.

>
>Best regards
>
>Robert Li
>Computer Associates
>R&D Centre Beijing , China
>Tel:    +86 10 6561 1136 ext 852 (O)
>            +86 10 6731 1652 (H)
>Fax:    +86 10 8529 8979
>E-mail: robert.li03@stripped
>
>
>>>-----Original Message-----
>>>From: Sammy Lau [mailto:sammy@stripped]
>>>Sent: Saturday, December 29, 2001 6:06 PM
>>>To: Li, Robert; mysql@stripped
>>>Subject: Re: how to setup Mysql multiple instances
>>>
>>>
>>>http://www.mysql.com/documentation/mysql/bychapter/manual_MySQ
>>>L_Database_Adm
>>>inistration.html#Multiple_servers
>>>----- Original Message -----
>>>From: "Li, Robert" <Robert.Li03@stripped>
>>>To: <announce@stripped>; <mysql@stripped>
>>>Sent: Saturday, December 29, 2001 5:58 PM
>>>Subject: how to setup Mysql multiple instances
>>>
>>>
>>>>  Hi,all MySQL teams:
>>>>
>>>>  First let me wish you all happy new year!
>>>>  Wish Mysql win more victories in DB area.
>>>>
>>>>  I am a programmer in CA. I know Mysql supports
>>>>  multiple instances. One way is to install different servers,
>>>>  on each server, runs an instance. The other way is to
>>>>  use one server, one installation to run multi instances.
>>>>  Now i can setup the environment in the first way.
>>>>  I want to know how to setup in the second way.
>>>>
>>>>  Would you pls kindly help me to solve this problem?
>>>>  Thank you very much!
>>>>
>>>>  Regards
>>>>
>>>>  Robert Li
>>>>  Computer Associates
>>>>  Programmer, R&D Beijing (China)
>>>>  Tel:  +86 10 65611136 ext 852
>>>>  Fax: +86 10 85298979
>  >>> robert.li03@stripped
Thread
How to restore all databases in one instance?Robert Li19 Feb
  • Re: How to restore all databases in one instance?Paul DuBois19 Feb