On May 7, 2006, at 11:29 PM, Robert DiFalco wrote:
Fast, incremental, compressed, and no max-size limitations. Must be
transaction safe; able to run while transactions are going on without
including any started after the backup began; the usual stuff.
Incremental, transaction safe,
On 5/8/06, David Hillman [EMAIL PROTECTED] wrote:
On May 7, 2006, at 11:29 PM, Robert DiFalco wrote:
Fast, incremental, compressed, and no max-size limitations. Must be
transaction safe; able to run while transactions are going on without
including any started after the backup began; the
-Original Message-
From: Daniel da Veiga [mailto:[EMAIL PROTECTED]
Sent: Monday, May 08, 2006 1:55 PM
To: mysql@lists.mysql.com
Subject: Re: Backups with MySQL/InnoDB
On 5/8/06, David Hillman [EMAIL PROTECTED] wrote:
On May 7, 2006, at 11:29 PM, Robert DiFalco wrote:
Fast
---
-Original Message-
From: Duzenbury, Rich [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 9 May 2006 6:39 AM
To: mysql@lists.mysql.com
Subject: RE: Backups with MySQL/InnoDB
-Original Message-
From: Daniel da Veiga
On Sunday, May 07, 2006 6:14 PM, Greg 'groggy' Lehey wrote:
On Sunday, 7 May 2006 at 9:27:31 -0700, Robert DiFalco wrote:
What are people doing for backups on very large MySQL/InnoDB
databases? Say for databases greater than 200 GB. Curious about
the backup methods, procedures, and
On Sunday, 7 May 2006 at 9:27:31 -0700, Robert DiFalco wrote:
What are people doing for backups on very large MySQL/InnoDB databases?
Say for databases greater than 200 GB. Curious about the backup methods,
procedures, and frequency.
A second question, but not for the first time: how would
, May 07, 2006 6:14 PM
To: Robert DiFalco
Cc: mysql@lists.mysql.com
Subject: Re: Backups with MySQL/InnoDB
On Sunday, 7 May 2006 at 9:27:31 -0700, Robert DiFalco wrote:
What are people doing for backups on very large MySQL/InnoDB
databases?
Say for databases greater than 200 GB. Curious about
Furthermore, would it make more sense to have the data dump locally,
and then use a script to move the contents of the dump to a machine
on the network, perhaps even to a machine located on an alternate
network accessed via a second ethernet card?
This would be the simplest approach. That is
Hi
I'd say that you have an ideal situation to use a Raid level 1 system.
Rick Dwyer [EMAIL PROTECTED] a écrit dans le message de news:
[EMAIL PROTECTED]
Hello all.
I am looking into the different back up methods available for
safeguarding my MySQL databases.
Ideally, I would like to have
I would really like to hear how some of you are handling backups on
high-availability servers. The DBA in my company is skeptical about
switching from MSSQL Server to MySQL, this is one of his reasons
(backups). If someone is making MySQL work in a high-availabity
environment, let's hear about
Mauricio Pellegrini said:
Hi I'm using, Mysql version 4.1.1 with InnoDB under SuSE linux 8.2
I don't know if this is the right place to ask. If not please point me
in the right direction.
I'm performing nightly backups of the datadir. So my backups include a
database and the Mysql databases
On Thursday 20 March 2003 23:25, Andreas wrote:
I'm trying to get going with InnoDB.
As for now I created several tables which relate to each other with some
foreign key restrictions.
mysqldump --all --opt writes 6++ MB stuff in a textfile that mysqld
won't accept without SET
]]
Sent: January 7, 2003 15:49
To: mysql users
Cc: Jonas Widarsson
Subject: Re: Backups mechanism
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jonas --
...and then Jonas Widarsson said...
%
% Hello world!
Hi!
% Every attempt I have made to find a decent way of backing up a database
% ends up
I use mysqldump to do a total backup of my database. This is done once a
day just after midnight. The file is then taken up by our tape backup
software. I do hourly backups of our more important databases, also using
mysqlbackup. Works fine and I have used it for restorals on a number of
On Tue, 7 Jan 2003 [EMAIL PROTECTED] wrote:
I use mysqldump to do a total backup of my database. This is done once a
day just after midnight. The file is then taken up by our tape backup
software. I do hourly backups of our more important databases, also using
mysqlbackup. Works fine
Jonas,
We use mysqlhotcopy as a command line script set to run daily as a cron
job. Seems to work fine. You can add flags that allow you to maintain
previous copies of the db in case you need to go back a version or two. It
took about 10 minutes to set up. We then run TSM backups to storage of
What we have done it right a small script:
It logs on to the MySQL server.
It then locks the databases and tables we have put in a config file.
Simply copies the data files to a new directory.
Unlocks the tables.
Once this is done (copy if fast) you can tar or zip up the copied files.
Simon
Can you post this script? (Minus the passwords, etc.)
- Original Message -
From: Simon Green [EMAIL PROTECTED]
To: 'Jonas Widarsson' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, January 07, 2003 11:18 AM
Subject: RE: Backups mechanism
What we have done it right a small script
On Tue, 7 Jan 2003, Jonas Widarsson wrote:
Hello world!
Every attempt I have made to find a decent way of backing up a database
ends up with tons of reading to show hundreds of ways to do database
backups.
I want to know which way to do complete backups is most commonly used by
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jonas --
...and then Jonas Widarsson said...
%
% Hello world!
Hi!
% Every attempt I have made to find a decent way of backing up a database
% ends up with tons of reading to show hundreds of ways to do database
% backups.
Heh :-) And you
On Mon, 28 Oct 2002, David T-G wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi, all!
I would like to dump my mysql databases to cold files for separate
backups; we're too cheap to buy the database agent that will do it live.
I started with
mysqldump --user=root
create a .my.cnf file in your home directory, and enter the useid and
password here.
David T-G wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi, all!
I would like to dump my mysql databases to cold files for separate
backups; we're too cheap to buy the database agent that will do it
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Gerald --
...and then gerald_clark said...
%
% create a .my.cnf file in your home directory, and enter the useid and
% password here.
Ahhh... That's also not a bad idea. Between that and perhaps
certificates I might be getting somewhere.
Will
Personally I just tar up the data dir every hour and have a script to
rotate the tar file ( up to 10 tar files.. ).
There are some other utilities out there that are nicer tho. I can't
remember them off the top of my head tho.
--
sh
On Fri, 2002-03-29 at 11:05, Tab Alleman wrote:
What do you
Hello Tab,
Friday, March 29, 2002, 10:05:20 PM, you wrote:
Which table type do you use ? Well if you do not know it's probably
MYISAM. In this case you may use BACKUP TABLE to make a quick
consistent backup of the table. If you want to have consistent
snapshot of several tables you may use
Perform a hot copy of the databases (using mysqlhotcopy). This also
seems to take a while, but at least the database server does not have
to
shutdown. The trouble with this is that it locks the table from writes
when
it does the copy. Some of my tables take a while to copy (they are
hundreds
Another suggestion I saw someone make that seems reasonable is to use a
break away mirror for backups. I think they lock the tables for a minute
break the mirror and unlock the tables. Then they backup the broken mirror
at their leisure.
Dave
On Tue, Dec 18, 2001 at 06:00:49PM -0500, Dave Greco
Dave Greco wrote:
Looking over the documentation for MySQL, there doesn't seem to be a
consensus on the best way to perform backups of MySQL databases. So far, I
have come up with the following ideas:
1. Just copy the files in the data directory to wherever I want them backed
up. This
sql
Stefan Hinz schrieb am Freitag, 17. August 2001, 21:28:54:
It's not secure, though
(http://www.securereality.com.au/studyinscarlet.txt), so make sure to
protect the directory it's installed in with .htaccess when running it
on a public server.
To make a long story short: dont't trust
On Fri, 17 Aug 2001, hanan khader wrote:
Hi everybody
I want to make backing up for my databases from the server into my pc, I
login to the server with the administrator username and password, how could
this backing up be done? and is there any risk that i should be aware of ?
is there
Dear Hanan,
try PhpMyAdmin (www.phpmyadmin.com). Nice and easy to backup databases
and tables, and easy to import from the backup SQL files. It's browser
based, so it's platform independent.
It's not secure, though
(http://www.securereality.com.au/studyinscarlet.txt), so make sure to
protect
31 matches
Mail list logo