Backup MySQL DB

On Tue, 15 Jul 2003 10:55:07 +0000 (UTC), Frank @ MyPlace.Com (Frank) wrote:

>For a small DB is it oK just to copy the DB to another location ?

It's OK for any size database, so long as the datafiles aren't being changed
whilst you do it.

So lock all the tables first.

mysqlhotcopy does this for you. http://www.mysql.com/doc/en/mysqlhotcopy.html

--
Andy Hassall (andy@andyh.co.uk) icq(5747695) (http://www.andyh.co.uk)
Space: disk usage analysis tool (http://www.andyhsoftware.co.uk/space)

Is there anything similar that is NOT Perl ?

Our Test Win2000 Server does not have Perl Support, and niether does
our test linux box..

Thanks

On Tue, 15 Jul 2003 21:26:17 +0100, Andy Hassall <andy@andyh.co.uk>
wrote:

>On Tue, 15 Jul 2003 10:55:07 +0000 (UTC), Frank @ MyPlace.Com (Frank) wrote:
>
>>For a small DB is it oK just to copy the DB to another location ?
>
> It's OK for any size database, so long as the datafiles aren't being changed
>whilst you do it.
>
> So lock all the tables first.
>
> mysqlhotcopy does this for you. http://www.mysql.com/doc/en/mysqlhotcopy.html
>
>--
>Andy Hassall (andy@andyh.co.uk) icq(5747695) (http://www.andyh.co.uk)
>Space: disk usage analysis tool (http://www.andyhsoftware.co.uk/space)

On Wed, 16 Jul 2003 09:50:37 +0000, Frank wrote:

> Is there anything similar that is NOT Perl ?
>
> Our Test Win2000 Server does not have Perl Support, and niether does our
> test linux box..
>
<snip!>

Well why the heck not? Perl is available and free of charge for both!

--
Jeffrey D. Silverman | jeffrey AT jhu DOT edu
Johns Hopkins University | Baltimore, MD
Website | http://www.wse.jhu.edu/newtnotes/

Frank wrote:

> Is there anything similar that is NOT Perl ?
>
> Our Test Win2000 Server does not have Perl Support, and niether does
> our test linux box..
>
> Thanks
>
> On Tue, 15 Jul 2003 21:26:17 +0100, Andy Hassall <andy@andyh.co.uk>
> wrote:
>
> >On Tue, 15 Jul 2003 10:55:07 +0000 (UTC), Frank @ MyPlace.Com (Frank) wrote:
> >
> >>For a small DB is it oK just to copy the DB to another location ?
> >
> > It's OK for any size database, so long as the datafiles aren't being changed
> >whilst you do it.
> >
> > So lock all the tables first.
> >
> > mysqlhotcopy does this for you. http://www.mysql.com/doc/en/mysqlhotcopy.html
> >
> >--
> >Andy Hassall (andy@andyh.co.uk) icq(5747695) (http://www.andyh.co.uk)
> >Space: disk usage analysis tool (http://www.andyhsoftware.co.uk/space)

Can you just use mysqldump?

Shawn
--
Shawn Wilson
shawn@glassgiant.com
http://www.glassgiant.com