Re: Recovering mysql data - mysqlbinlog

2008-05-01 Thread Matthew Seaman
Mel wrote: On Thursday 01 May 2008 22:24:33 Paul Schmehl wrote: --On Thursday, May 01, 2008 21:52:05 +0200 Mel <[EMAIL PROTECTED]> wrote: On Thursday 01 May 2008 21:13:41 John wrote: Thank you Mel and Paul for the suggestions. From what I understand the general query log is more for debuggin

Re: Recovering mysql data - mysqlbinlog

2008-05-01 Thread Mel
On Thursday 01 May 2008 22:24:33 Paul Schmehl wrote: > --On Thursday, May 01, 2008 21:52:05 +0200 Mel > > <[EMAIL PROTECTED]> wrote: > > On Thursday 01 May 2008 21:13:41 John wrote: > >> Thank you Mel and Paul for the suggestions. From what I understand the > >> general query log is more for debug

Re: Recovering mysql data - mysqlbinlog

2008-05-01 Thread Paul Schmehl
--On Thursday, May 01, 2008 21:52:05 +0200 Mel <[EMAIL PROTECTED]> wrote: On Thursday 01 May 2008 21:13:41 John wrote: Thank you Mel and Paul for the suggestions. From what I understand the general query log is more for debugging and the binary log is for point in time recovery and replicatio

Re: Recovering mysql data - mysqlbinlog

2008-05-01 Thread Mel
On Thursday 01 May 2008 21:13:41 John wrote: > Thank you Mel and Paul for the suggestions. From what I understand the > general query log is more for debugging and the binary log is for point in > time recovery and replication. I'll be adding a my.cnf file (using the > my-large.cnf as a skeleton)

RE: Recovering mysql data - mysqlbinlog

2008-05-01 Thread John
tion. -John -Original Message- From: Mel [mailto:[EMAIL PROTECTED] Sent: Thursday, May 01, 2008 2:23 PM To: freebsd-questions@freebsd.org Cc: John; [EMAIL PROTECTED] Subject: Re: Recovering mysql data - mysqlbinlog On Thursday 01 May 2008 19:45:32 John wrote: > Can someone direct me t

Recovering mysql data - mysqlbinlog

2008-05-01 Thread John Vaughan
Can someone direct me to where the MySQL transaction logs are stored? I am running FreeBSD 6.1 with MySql 5.0.41 which I installed from ports, no extra config. From what I've read online, unless you disable them (which I couldn't find in the makefile) the logs should be being created. Doing a fin

Re: Recovering mysql data - mysqlbinlog

2008-05-01 Thread Mel
On Thursday 01 May 2008 19:45:32 John wrote: > Can someone direct me to where the MySQL transaction logs are stored? I am > running FreeBSD 6.1 with MySql 5.0.41 which I installed from ports, no > extra config. From what I've read online, unless you disable them (which I > couldn't find in the ma

Re: Recovering mysql data - mysqlbinlog

2008-05-01 Thread Paul Schmehl
--On Thursday, May 01, 2008 13:45:32 -0400 John <[EMAIL PROTECTED]> wrote: Can someone direct me to where the MySQL transaction logs are stored? I am running FreeBSD 6.1 with MySql 5.0.41 which I installed from ports, no extra config. From what I've read online, unless you disable them (which

Recovering mysql data - mysqlbinlog

2008-05-01 Thread John
Can someone direct me to where the MySQL transaction logs are stored? I am running FreeBSD 6.1 with MySql 5.0.41 which I installed from ports, no extra config. From what I've read online, unless you disable them (which I couldn't find in the makefile) the logs should be being created. Doing a fi