Re: Restore 20 gigabytes of binary logfiles

2004-05-13 Thread JFL
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

Re: Restore 20 gigabytes of binary logfiles

2004-05-13 Thread Jeremy Zawodny
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

Re: Restore 20 gigabytes of binary logfiles

2004-05-13 Thread Jacob Friis Larsen
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

Re: Restore 20 gigabytes of binary logfiles

2004-05-13 Thread Jeremy Zawodny
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

Restore 20 gigabytes of binary logfiles

2004-05-12 Thread JFL
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 Thanks, Jacob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: Restore 20 gigabytes of binary logfiles

2004-05-12 Thread Sasha Pachev
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