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
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
]
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: 3.23.58
Each week I make a hotcopy of numerous database files.
I tar them
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
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 help.
If
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 12,
Try the following:
mysqlhotcopy -u root -p password dbname /path/to/copy/the/data/to
so, if you want to copy the db foobar, you do the following:
mysqlhotcopy -u root -p password foobar /backup/data
and a new dir will be created called /backup/data/foobar
with all the tables there
-dan
On
Try the following:
mysqlhotcopy -u root -p password dbname /path/to/copy/the/data/to
so, if you want to copy the db foobar, you do the following:
mysqlhotcopy -u root -p password foobar /backup/data
and a new dir will be created called /backup/data/foobar
with all the tables there
-dan
On
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 password dbname /path/to/copy/the/data/to
so, if you want to copy the db foobar, you do