Fred, Jim,
Thank you very much for your kind help! I still have other questions about the MySQL
operation.
If a service host is redundant, one is in active status, the other is standby. I want
to make the following operation .
1. database backup.
This is done on the standby one with the following command.
mysqldump --opt --quote-names --flush-logs database_name > database.backup
2. database restore.
Restore the database with the previous backup. I am not sure what to do. I guess there
will be two methods to finish this.
* disconnect the two host and make operation on each one individually as
following
mysql database_namve < database.backup
Then restart Mysql.
* do restore on the active one with the following command. Because the standby
host are the backup of the active one. So the data on both of the hosts will finally
be identical in the end. I don't know whether it will be in such case.
mysql database_namve < database.backup
If my description is wrong, Would you please let me know the correct methods?
Thanks!
Lenny Li
==================================
LSS-MI Development, R&D, Lucent Qingdao
[EMAIL PROTECTED] 86-532-8702000-5033
http://gdcsr60.gdc.lucent.com/~lennyli
> -----Original Message-----
> From: Frederic Wenzel [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, February 25, 2004 4:13 PM
> To: Li, Lenny Yong Bo (Lenny)
> Cc: [EMAIL PROTECTED]
> Subject: Re: A question about mysql database backup.
>
>
> Li, Lenny Yong Bo (Lenny) wrote:
>
> > Now I am assigned to do the backup of a whole mysql
> database (version: 3.23.36). I want to make sure whether the
> following procedures are correct for database backup.
> > 1. mysqldump -F --opt database_name > database_name.backup
>
> In my opinion, you should generally add the -Q option which
> quotes table
> and row names. Otherwise, restoring data can be really hard in case of
> perhaps only one "complicated" row name...
>
> Regards,
> Fred
>
>
> --
> Condense soup, not books!
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
