On Thu, May 13, 2004 at 10:16:52PM +0200, Jacob Friis Larsen wrote: > >> I need to restore 20 gigabytes of binary logfiles. > >> What should I do in order to get the job done as quickly as possible? > > > > There is a faster way, but it is rather tricky. > > > > 4.0 slave can be tricked into thinking that those binary logs are in > > fact the relay logs that it gathered from the master. So we trick the > > server into thinking it is a slave of the server that produced them. You > > just need to pick a server-id that is not the same as the one that > > produced them. Then if you list the logs in in the relay log info file > > in the correct order, hand-craft relay-log.info file to point at the > > first one), then start the slave with skip-slave-start, and then just > > start the SQL thread manually (SLAVE START SQL_THREAD), it will process > > them until it is done. Periodically run SHOW SLAVE STATUS to see if it > > got to the end of the last log. > > How should relay-log.info look like? > Like this: > > linuxweb1-bin.001 > linuxweb1-bin.002 > linuxweb1-bin.003 > ...
That looks right. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ [book] High Performance MySQL -- http://highperformancemysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]