Andrew Loughe wrote:
Hello,
MySQL version: 3.23.58
Each week I make a hotcopy of numerous database files.
I tar them and gzip them, and move them to an archive machine.
I then use a second machine to read from the archive, untar and ungzip
the files, and presto! I have exact copies of my database
At 19:08 -0600 5/4/04, Andrew Loughe wrote:
Hello,
MySQL version: 3.23.58
Each week I make a hotcopy of numerous database files.
I tar them and gzip them, and move them to an archive machine.
I then use a second machine to read from the archive, untar and ungzip
the files, and presto! I have exac
> From:
> [EMAIL PROTECTED]
> om
> [mailto:[EMAIL PROTECTED]
> .mysql.com] On Behalf Of Andrew Loughe
> Sent: Wednesday, 5 May 2004 1:09 p.m.
> To: [EMAIL PROTECTED]
> Subject: MySQL hotcopy problem (poor man's replication)
>
>
> Hello,
>
> MySQL version
Hello,
MySQL version: 3.23.58
Each week I make a hotcopy of numerous database files.
I tar them and gzip them, and move them to an archive machine.
I then use a second machine to read from the archive, untar and ungzip
the files, and presto! I have exact copies of my databases running on
a backup
Mark,
Wednesday, March 13, 2002, 9:53:08 PM, you wrote:
MS> Quick question -
MS> I have a db named content with user "admin" and pass "mypass" Do I still
MS> use -u root p maypass ? or would I use
MS> mysqlhotcopy -u admin -p mypass content /path/to/copy/the/data/to
MS> Thanks again for your hel
-
From: Dan Patnaude <[EMAIL PROTECTED]>
To: Mark Stringham <[EMAIL PROTECTED]>
Cc: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Wednesday, March 13, 2002 10:41 AM
Subject: Re: mysql hotcopy
>Try the following:
>
>mysqlhotcopy -u root -p /path/to/copy/the/data/to
>
&g
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
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
Can anyone give me an example of how to run mysqlhotcopy from the command
line? What can I expect as the output and where is the file created/ stored?
Thanks
Mark
-Original Message-
From: Michael Grassman <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Tuesday, March 1