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.
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: [EMAIL PROTECTED]
>>-----Original Message-----
>>From: Sammy Lau [mailto:[EMAIL PROTECTED]]
>>Sent: Saturday, December 29, 2001 6:06 PM
>>To: Li, Robert; [EMAIL PROTECTED]
>>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" <[EMAIL PROTECTED]>
>>To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
>>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
>>> [EMAIL PROTECTED]
>>>
>>>
>>---------------------------------------------------------------------
>>> Before posting, please check:
>>> http://www.mysql.com/manual.php (the manual)
>>> http://lists.mysql.com/ (the list archive)
>>>
>>> To request this thread, e-mail <[EMAIL PROTECTED]>
>>> To unsubscribe, e-mail
>><[EMAIL PROTECTED]>
>>> Trouble unsubscribing? Try:
>>http://lists.mysql.com/php/unsubscribe.php
>>>
>>>
>>
>>
>>
>>---------------------------------------------------------------------
>>Before posting, please check:
>> http://www.mysql.com/manual.php (the manual)
>> http://lists.mysql.com/ (the list archive)
>>
>>To request this thread, e-mail <[EMAIL PROTECTED]>
>>To unsubscribe, e-mail
>><[EMAIL PROTECTED]>
>>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>>
>>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
