Skip to content

Question 68: Pick 2 backup methods, which can be used to setup replication

15. June 2010
By plogi in mysql questions

1 Comment

 

a) data pump
b) ibbackup
c) mysqldump  --master-data
d) flush tables with read lock;
   -- write down binlog position
   -- copy all files
   unlock tables;

 
[ Data Backup and Recovery Methods (15%) - Introduction ]

Tags: , ,

Comment Feed

One Response

  1. plogi — 15. June 2010 @ 18:52:40 —


    You needed to name only 2, but b, c and d are correct.
    The data pump is an Oracle tool.
    A backup, which can be used to set up replication, can also be used for point-in-time recovery.

You must be logged in to post a comment.