Re: Automating database full backup

2004-07-09 Thread John
- From: Tim Bunce [EMAIL PROTECTED] To: John [EMAIL PROTECTED] Cc: DBI-Users [EMAIL PROTECTED] Sent: Thursday, July 08, 2004 8:45 PM Subject: Re: Automating database full backup On Thu, Jul 08, 2004 at 01:17:04PM +0300, John wrote: Ok, can mysqlhotcopy create a dump? That is what i want. like

Re: Automating database full backup

2004-07-08 Thread John
, July 07, 2004 9:09 PM Subject: Re: Automating database full backup On Wed, Jul 07, 2004 at 01:41:19PM -0400, Hardy Merrill wrote: A bit OT here, but I'm curious - does mysqlhotcopy allow you to do a backup without shutting down MySQL? Yes, hence hot copy. http://dev.mysql.com/doc/mysql/en

Re: Automating database full backup

2004-07-08 Thread Tim Bunce
PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, July 07, 2004 9:09 PM Subject: Re: Automating database full backup On Wed, Jul 07, 2004 at 01:41:19PM -0400, Hardy Merrill wrote: A bit OT here, but I'm curious - does mysqlhotcopy allow you to do

Re: Automating database full backup

2004-07-08 Thread John
PROTECTED] Cc: DBI-Users [EMAIL PROTECTED] Sent: Thursday, July 08, 2004 11:59 AM Subject: Re: Automating database full backup On Thu, Jul 08, 2004 at 10:05:32AM +0300, John wrote: Well, If we are talking about mysql utilites, then mysqldump is an excellent tool for me and what i wan to do

Re: Automating database full backup

2004-07-08 Thread Tim Bunce
: Tim Bunce [EMAIL PROTECTED] To: John [EMAIL PROTECTED] Cc: DBI-Users [EMAIL PROTECTED] Sent: Thursday, July 08, 2004 11:59 AM Subject: Re: Automating database full backup On Thu, Jul 08, 2004 at 10:05:32AM +0300, John wrote: Well, If we are talking about mysql utilites, then mysqldump

Automating database full backup

2004-07-07 Thread John
I want to automate a mysql backup Can this be done via perl and how?

Re: Automating database full backup

2004-07-07 Thread Hardy Merrill
I quick search on google for automate mysql backup perl dbi revealed this as one of the 1st 5 links: http://www.csc.liv.ac.uk/~u2pj/SQL_Perl.htm Check out RW MySQL Dump - looks to me like it might be just what you're looking for. Or if you still want to do it yourself, just reading its

Re: Automating database full backup

2004-07-07 Thread Tim Bunce
I believe mysql also ships with mysqlhotcopy (which I wrote) you may find it useful. Tim. On Wed, Jul 07, 2004 at 10:05:42AM -0400, Hardy Merrill wrote: I quick search on google for automate mysql backup perl dbi revealed this as one of the 1st 5 links:

Re: Automating database full backup

2004-07-07 Thread Hardy Merrill
A bit OT here, but I'm curious - does mysqlhotcopy allow you to do a backup without shutting down MySQL? http://dev.mysql.com/doc/mysql/en/mysqlhotcopy.html I know this is over-simplifying, but couldn't automating MySQL backups with mysqlhotcopy be as simple as adding a MySQL user with read(?)

Re: Automating database full backup

2004-07-07 Thread Tim Bunce
On Wed, Jul 07, 2004 at 01:41:19PM -0400, Hardy Merrill wrote: A bit OT here, but I'm curious - does mysqlhotcopy allow you to do a backup without shutting down MySQL? Yes, hence hot copy. http://dev.mysql.com/doc/mysql/en/mysqlhotcopy.html [Umm, ought to ask them to acknowledge that I wrote