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: [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