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
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
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
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
]
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
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
but 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
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)
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
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.
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