On Thu, May 13, 2004 at 10:28:26AM +0200, JFL 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? > >> > >> I am considering this: > >> mysqlbinlog --database=mydb logfiles | mysql -f > > > > 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. > > Would that be faster than having converted the binary logs to sql > commands in one file and then use that?
It would be, yes. It's hard to say how much faster though. -- 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]
