On 02/25/2004 09:13 AM Frederic Wenzel 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 shou
on 02/27/2004 12:11 AM, Li, Lenny Yong Bo (Lenny) at [EMAIL PROTECTED]
wrote:
>
> 1. database backup.
> This is done on the standby one with the following command.
> mysqldump --opt --quote-names --flush-logs database_name > database.backup
How does this operations handle binary fields, password
]
> 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
-
> 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
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 gen
Ms./Sir,
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
2. stop mysqld if is running. Then start it with "--log-bin"
would mean a second
copy of MySQL
but you would only need a low spec system..
I hope this helps...
Simon
-Original Message-
From: Kathy Reyes [mailto:[EMAIL PROTECTED]]
Sent: 19 March 2002 21:37
To: mysql
Subject: MYSQL DATABASE BACKUP
I am trying to backup a table in mysql without
not quite sure what you mean by locking.
each table will be locked during "readout" for the dump automaticly for the
time the select runs and delivers data to the dumping program.
it is not needed to lock the tables (more than one) in advance for a dump, but
that, might better for dataintegrety.
PROTECTED]]
Sent: Tuesday, March 19, 2002 1:37 PM
To: mysql
Subject: MYSQL DATABASE BACKUP
I am trying to backup a table in mysql without locking my tables it this
posible
-
Before posting, please check:
http://www.mysql.com
I am trying to backup a table in mysql without locking my tables it this
posible
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
Hello,
could anyone explain me how to backup and in case of system crash
restore
the mysql database (main database where data about other databases,
grants,users, etc. is kept)?
Thanks in advance !
Regards,
Saulius Gurklys
mailto:[EMAIL PROTECTED]
--
11 matches
Mail list logo