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 f
---
-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
> -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,
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
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, compresse
nt: Sunday, 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 G
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
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
> 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
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 i
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 dat
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 FOREIG
]]
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 with
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
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. Wo
> 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
-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 expe
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
> pro
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: Ba
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
---
-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 th
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Iikka, et al --
...and then Iikka Meriläinen said...
%
% On Mon, 28 Oct 2002, David T-G wrote:
%
...
% >
% > What I need is a way to connect to the database from a cron job without
% > exposing the password in the environment. What amazes me is tha
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 liv
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 --pa
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 "loc
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
>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
hundr
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
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 w
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 tr
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 the
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 ther
32 matches
Mail list logo
