Warning: Creating default object from empty value in /www/htdocs/v030397/mysql-qotd/wp-content/plugins/sitepress-multilingual-cms/sitepress.class.php on line 4991

Warning: Creating default object from empty value in /www/htdocs/v030397/mysql-qotd/wp-content/plugins/sitepress-multilingual-cms/sitepress.class.php on line 4993
Question 68: Pick 2 backup methods, which can be used to setup replication – MySQL Question of the Day

Skip to content

By plogi in mysql questions

 

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. plogi15. 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.