Re: mysql hotcopy

2002-03-13 Thread Dan Patnaude
Try the following: mysqlhotcopy -u root -p /path/to/copy/the/data/to so, if you want to copy the db "foobar", you do the following: mysqlhotcopy -u root -p foobar /backup/data and a new dir will be created called /backup/data/foobar with all the tables there -dan On Wednesday 13 March 2002

Re: mysql hotcopy

2002-03-13 Thread Dan Patnaude
Try the following: mysqlhotcopy -u root -p /path/to/copy/the/data/to so, if you want to copy the db "foobar", you do the following: mysqlhotcopy -u root -p foobar /backup/data and a new dir will be created called /backup/data/foobar with all the tables there -dan On Wednesday 13 March 2002

Re: On the logging of BLOBS

2002-03-11 Thread Dan Patnaude
hope this info helps. -Dan On Monday 11 March 2002 02:38, you wrote: > On Mon, Mar 11, 2002 at 01:43:59PM -0500, Dan Patnaude wrote: > > Is there SQL syntax to do selective logging. We have logging > > turned on, but queries involving BLOBS tend to screw with the > > lo

Re: On the logging of BLOBS

2002-03-11 Thread Dan Patnaude
hope this info helps. -Dan On Monday 11 March 2002 02:38, Jeremy Zawodny wrote: > On Mon, Mar 11, 2002 at 01:43:59PM -0500, Dan Patnaude wrote: > > Is there SQL syntax to do selective logging. We have logging > > turned on, but queries involving BLOBS tend to screw with the >

Re: On the logging of BLOBS

2002-03-11 Thread Dan Patnaude
hope this info helps. -Dan On Monday 11 March 2002 02:38, Jeremy Zawodny wrote: > On Mon, Mar 11, 2002 at 01:43:59PM -0500, Dan Patnaude wrote: > > Is there SQL syntax to do selective logging. We have logging > > turned on, but queries involving BLOBS tend to screw with the >

On the logging of BLOBS

2002-03-11 Thread Dan Patnaude
Hi- Is there SQL syntax to do selective logging. We have logging turned on, but queries involving BLOBS tend to screw with the logs. Any help would be useful TIA, -Dan - Before posting, please check: http://www.mysql

Large table problems

2002-03-11 Thread Dan Patnaude
Hi- We are running mysql version 3.23.33, along with resin. The tables we are using are large, but not overly so. We also, for reasons I cannot comprehend, but for which my manager thinks is a good idea, have index files that are as big as the data files themselves. So, here is the problem: E

Large table problems

2002-03-11 Thread Dan Patnaude
Hi- We are running mysql version 3.23.33, along with resin. The tables we are using are large, but not overly so. We also, for reasons I cannot comprehend, but for which my manager thinks is a good idea, have index files that are as big as the data files themselves. So, here is the problem: E