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
RD 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, RD 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