Hey everyone,
I just posted new blog post about an online training class I will be doing
January the 13th. This class will cover backups, recovery and disaster
planning. It is completely free with no strings attached. If you are
interested, take a look at the blog post here:
http://www.paragon
beetween MyISAM and InnoDB Tables. You suggest,
changing the Order of "FLUSH LOGS" and place it before the Dumps are
generated.
Also, have you thought about doing the hourly backups against the master
instead of a slave and do full backups off the slave since they naturally
take longer?
Hello everybody,
i have a Question concering MySQL-Backups in a Master/Slave Replication-Setup
(MYISAM and InnoDB Tables) and incremental Backups using the Binary-Logs from
the Slave.
Well, in case something will go wrong (hopefully not) I'm currently trying
to implement a recovery S
x27;PUNO' WHERE idCliente='000273999'
UPDATE cliente SET ciudad='AREQUIPA' WHERE idCliente='00454507'
.
to only have the option to edit the column ciudad for some row
i hope you see my point now
thanks in advanced
--
View this message in context:
http://www.nabble.com/Some-way-tool-to-do-this-with-database-scripts-backups-tp16496072p16633902.html
Sent from the MySQL - General mailing list archive at Nabble.com.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
hments.
> ASML is neither liable for the proper and complete transmission of the
> information contained in this communication, nor for any delay in its
> receipt.
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>
>
--
View this message in context:
http://www.nabble.com/Some-way-tool-to-do-this-with-database-scripts-backups-tp16496072p16524400.html
Sent from the MySQL - General mailing list archive at Nabble.com.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
> if i have for example
> a simple table call person
>
> with 'id' and 'name' how columns
>
> i can do a backup and get some file (A.sql)
> with all the inserts statements
>
> here, all fine
>
> but
> how i can do this?
Have a look at the 'mysqldump' command line utility.
It goes somethin
w B.sql, with update statements
its possible do this?
even worst, if a have a table with 20 columns
i need the way to generate the same B.sql
but with my desired columns to update
thanks in advanced
--
View this message in context:
http://www.nabble.com/Some-way-tool-to-do-this-with-data
I'm curious if anyone has any thoughts on how I can handle a data
retention issue I've been facing with a larger dataset.
My process, roughtly is run mysqldump against the DB and gzip the
output. Then I transfer it off to a different machine for archival
onto optical media (yes I know the
Hey all,
I'm curious if anyone has any thoughts on how I can handle a data
retention issue I've been facing with a larger dataset.
My process, roughtly is run mysqldump against the DB and gzip the
output. Then I transfer it off to a different machine for archival
onto optical media (yes I
I am new to MySQL administration, and must devise a backup plan, I have read
the manual but still want to know if I am understanding and applying the
principals correctly, please let me know if you have a better way, or if I
am wrong somewhere, my main question is regardng the locking of the databa
Hi,
Ofer Inbar wrote:
We've got a couple of production databases using mostly MyISAM tables,
that can't be taken offline without bringing down our application. To
reduce downtime, we run a full mysqldump once a week and back up the
binary logs every day, so we can always use them to "catch up"
Hi Ofer,
I prefer to use mylvmbackup and lvm to backup mysql. It's snapshot
includes a copy of the relay-log.info file which has the
exec_master_log_pos and relay_master_log_file. These allow you to use
the snapshot to restore another slave. It's also much faster to take a
snapshot of the file sy
We've got a couple of production databases using mostly MyISAM tables,
that can't be taken offline without bringing down our application. To
reduce downtime, we run a full mysqldump once a week and back up the
binary logs every day, so we can always use them to "catch up" from
the most recent full
ington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
www.the-infoshop.com
www.giiexpress.com
www.etudes-marche.com
> -Original Message-
> From: Mike Blezien [mailto:[EMAIL PROTECTED]
> Sent: Monday, May 14, 2007 11:52 AM
> To: John Meyer; MySQL General
> Subje
On Mon, May 14, 2007 17:56, John Meyer wrote:
> Mike Blezien wrote:
>> Hello,
>> - Original Message - From: "John Meyer" <[EMAIL PROTECTED]>
>> To: "MySQL General"
>> Sent: Monday, May 14, 2007 10:26 AM
>> Subject: Re: Sc
Mike Blezien wrote:
> Hello,
> - Original Message - From: "John Meyer" <[EMAIL PROTECTED]>
> To: "MySQL General"
> Sent: Monday, May 14, 2007 10:26 AM
> Subject: Re: Scheduled backups
>
>
>> J Trahair wrote:
>>> Hi
Hello,
- Original Message -
From: "John Meyer" <[EMAIL PROTECTED]>
To: "MySQL General"
Sent: Monday, May 14, 2007 10:26 AM
Subject: Re: Scheduled backups
J Trahair wrote:
Hi Everyone
I have set up a scheduled backup using MySQL Administrator. Stored
c
J Trahair wrote:
> Hi Everyone
>
> I have set up a scheduled backup using MySQL Administrator. Stored
> connection, database, dates and time, even the Windows user password (in
> fact, blank). It doesn't start at the correct time, or indeed any time.
>
> Have I missed something?
>
> Thanks for yo
D]
Sent: Monday, May 14, 2007 11:06 PM
To: MySQL General
Subject: Scheduled backups
Hi Everyone
I have set up a scheduled backup using MySQL Administrator. Stored
connection, database, dates and time, even the Windows user password (in
fact, blank). It doesn't start at the correct ti
Hi Everyone
I have set up a scheduled backup using MySQL Administrator. Stored connection,
database, dates and time, even the Windows user password (in fact, blank). It
doesn't start at the correct time, or indeed any time.
Have I missed something?
Thanks for your help.
Jonathan Trahair
Hi,
Yesterday I had a problem in a InnoDB table that I needed
to DROP and reimport the table.
When I tryed to reimport the table, most of the data was lost.
So, I´ve tryed to reimport the data from the backups (created via
mysqldump) and these datas were still corrupted.
So, it brings to my
> I am attempting to set and and schedule automated MySQL backups
> using the MySQL Administrator Tool downloaded from mysql.com. All
> of my back ups work fien when I perform them manually. However
> none of the scheduled backups ever get done. I am not sure where
> the gli
I am attempting to set and and schedule automated MySQL backups using the MySQL
Administrator Tool downloaded from mysql.com. All of my back ups work fien
when I perform them manually. However none of the scheduled backups ever get
done. I am not sure where the glicth is but here is what the
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
---
-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
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.
On 4/12/06, Tim Lucia <[EMAIL PROTECTED]> wrote:
> Would you not lock tables on the slave? The idea of catching it up implies
> this is way it is done. Catching up means once replication can proceed once
> the tables are unlocked (on the slave).
>
> At least that is the way I read it...
On the s
:[EMAIL PROTECTED] On Behalf Of
Terry Burton
Sent: Tuesday, April 11, 2006 6:20 PM
To: mysql@lists.mysql.com
Subject: mySQL Backups
On 4/11/06, Dana Diederich <[EMAIL PROTECTED]> wrote:
> We use a dedicated replicated instance for backups.
>
> Every night, we lock all of the tables,
On 4/11/06, Dana Diederich <[EMAIL PROTECTED]> wrote:
> We use a dedicated replicated instance for backups.
>
> Every night, we lock all of the tables, and dump all of them to
> compressed files, and unlock them afterwards. It takes a while to catch
> up, but that doesn&#x
d have the data be as portable as
necessary.
Just my $0.02.
J.R.
-Original Message-
From: Dana Diederich [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 11, 2006 9:15 AM
To: Greg 'groggy' Lehey; Jim
Cc: mysql@lists.mysql.com
Subject: RE: mySQL Backups
We use a dedicated rep
We use a dedicated replicated instance for backups.
Every night, we lock all of the tables, and dump all of them to
compressed files, and unlock them afterwards. It takes a while to catch
up, but that doesn't hurt anything.
Cheers,
-Dana
-Original Message-
From: Greg 'gro
On Tuesday, 11 April 2006 at 18:40:23 +1000, Jim wrote:
>
> What is the standard procedure for mySQL backups.
> We need to backup at least once a day on a windows OS.
> Is there a SQL Server Job Agent type solution?
At the moment it's a mess. We're working on cleaning up th
Jim wrote:
Hi All,
What is the standard procedure for mySQL backups.
We need to backup at least once a day on a windows OS.
Is there a SQL Server Job Agent type solution?
mysql has an implemented mysqldumper.
You could use that.
Ther are also some php dumper scripts and perl
Alan,
- Original Message -
From: ""Alan Fisher"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Thursday, March 09, 2006 8:38 PM
Subject: InnoiDB Backups
All,
I would like to knew if anyone knows of a way to automate innoDB Hot
Backups
of
All,
I would like to knew if anyone knows of a way to automate innoDB Hot Backups
of several databases that can be set to occur at off hours. Also, is it
possible to run several backups at one time. I am using MySQL 4.1.x on a
Solaris system.
Thanks,
Alan Fisher
--
MySQL General Mailing List
On Mon, 23 Jan 2006, George Law wrote:
Just a quick question regarding mysql backups.
I know myisam tables are portal from machine to machine, but I know
there are some differences
Between innodb tables.
I am running mysql 5.0.18 on suse linux 10. I have innodb set up so it
stores each table
with, but it also gives a bit more detail.
-Sheeri
On 1/23/06, George Law <[EMAIL PROTECTED]> wrote:
> Just a quick question regarding mysql backups.
>
> I know myisam tables are portal from machine to machine, but I know
> there are some differences
> Between innodb tables.
&
Hello.
Have a look here:
http://dev.mysql.com/doc/refman/5.0/en/backing-up.html
George Law wrote:
> Just a quick question regarding mysql backups.
>
> I know myisam tables are portal from machine to machine, but I know
> there are some differences
> Between innodb tables.
&g
Just a quick question regarding mysql backups.
I know myisam tables are portal from machine to machine, but I know
there are some differences
Between innodb tables.
I am running mysql 5.0.18 on suse linux 10. I have innodb set up so it
stores each table in its own
.idb file.
I've read
work, perhaps even to a machine located on an alternate
> network accessed via a second ethernet card?
>
> Finally, after reading about replication, this seems most attractive
> as I would have a duplicate of the existing server from which my
> backups could be performed. This way my
> 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
backups could be performed. This way my data is always available
online to customers. However, if I read correctly, does this mean I
will need 1 additional machine of at least equal speed to achieve this?
How do others handle replication issues when you have several MySQL
servers. . . having 1
Hello.
> 3.23 to 4.0 and then upgrading from 4.0 to 4.1. Does that mean that I
> can't just move databases from a machine that was 3.23 to a machine
> that is 4.1?
You can, however usually it won't work as supposed without additional
actions (like index repairing).
Curious Georg
Thanks for the replies so far,
I still haven't got this figured out, but I left out one important
piece of information. I'm moving 3.23 databases to a 4.1 installation.
Looking at the documentation, I see instructions for upgrading from
3.23 to 4.0 and then upgrading from 4.0 to 4.1. Does that mean
Hello.
Login as root though mysql command line client and check
if new tables exist and if you're able to work with them.
Under what user are you working in phpMyAdmin? Does he have
some privileges on just created databases or 'SHOW DATABASES'
privilege. See:
http://dev.mysql.com/doc/refm
rious George" <[EMAIL PROTECTED]>
To:
Sent: Saturday, December 03, 2005 7:05 AM
Subject: Moving databases from backups not working . . .
Greetings all,
I've got some headaches I need to make go away over the weekend. I
used phpMyAdmin to backup some small mysql databases. (S
Greetings all,
I've got some headaches I need to make go away over the weekend. I
used phpMyAdmin to backup some small mysql databases. (So I've got a
bunch of _dbname_.sql files)
I have a different machine with a newer version of MySQL (4.1.13a)
running and configured so that I can connect from t
If you open your terminal, you'll see some error messages waiting for you.
Apparently it's buggy. I turned off my admin backups.
Cheers
John Doneker:
> Is this because this free software doesn't supply this functionality? Or could
> it be a bug? Is there another answer?
I've downloaded the MySQL Admin 1.1 freeware tool to backup a mysql database.
It works fine except that the timer doesn't work. When I set a time in the
'time' field, lets say 8:00, the backup never kicks off.
Is this because this free software doesn't supply this functionality? Or could
it b
Hello
JT> Did you try that link? When I follow it, I get a search results page
JT> saying <>. Too
JT> bad it doesn't actually show the search results
Sorry. Try this links
http://solutions.mysql.com/search.php?pc=4%2C86&q=backup&level=0
http://solutions.mysql.com/software/?c=backup
Since
"Ryan Stille" <[EMAIL PROTECTED]> wrote on 07/21/2005 05:47:28 PM:
> I'm trying to get a handle on MySQL backups and hot backups using MyISAM
> and InnoDB tables together. We plan to switch from SQL Server to MySQL
> soon.
>
> How are you guys handling
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
To: mysql@lists.mysql.com
Subject: Questions about backups, InnoDB tables, etc.
I'm trying to get a handle on MySQL backups and hot backups using MyISAM
and InnoDB tables together. We plan to switch from SQL Server to MySQL
soon.
How are you guys handling full-backups of databases with mi
To: Ryan Stille; mysql@lists.mysql.com
> Subject: Re: Questions about backups, InnoDB tables, etc.
>
> Hello
>
> RS> I'm trying to get a handle on MySQL backups and hot
> backups using MyISAM
> RS> and InnoDB tables together. We plan to switch from SQL
&g
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
Ryan Stille wrote:
I've been doing some testing and came across something I don't
understand. I filled my test InnoDB formatted table with a lot of data
so mysqldump will take a while to complete. Then I start mysqldump on
this database with the --single-transaction option. While that is
runni
Hello
RS> I'm trying to get a handle on MySQL backups and hot backups using MyISAM
RS> and InnoDB tables together. We plan to switch from SQL Server to MySQL
RS> soon.
Did you see it:
http://solutions.mysql.com/search.php?pc=0%2C0&q=backup&level=0 ?
Sincerely,
Mic
I'm trying to get a handle on MySQL backups and hot backups using MyISAM
and InnoDB tables together. We plan to switch from SQL Server to MySQL
soon.
How are you guys handling full-backups of databases with mixed MyISAM
and InnoDB tables? From what I've read (and I've been readin
> to flush tables, you're right :
>
> flush table TOTO <= flushes only toto
> flush table TOTO,TITI<= flushes only toto and titi
> flush tables <= flushes ALL
OK, that's good news.
> Have'nt you thought to a master-slave replication and
> 1) Reading TFM (http://dev.mysql.com/doc/mysql/en/flush.html) it appears
> that I do not have to 'FLUSH TABLES WITH READ LOCK' for each individual
> database. This statement flushes and locks all simultaneously. Am I
> correct?
HI,
to flush tables, you're right :
flush table TOTO
Hi,
Our MySQL 4.1.10 environment runs on Solaris 8 and the data is stored on
a NetApp filer. The schemas contain a mix of MyISAM and InnoDB tables.
To make a backup we lock all tables in all databases (USE database;
FLUSH TABLES WITH READ LOCK), and then tell NetApp to make a snapshot.
We have a
-
From: Ware Adams [mailto:[EMAIL PROTECTED]
Sent: 25 May 2005 17:31
To: David Brewster
Cc: mysql@lists.mysql.com
Subject: Re: Restoring InnoDB databases from backups causing problems
On May 25, 2005, at 10:06 AM, David Brewster wrote:
> Here is the log dump :-
>
> Thanks
> David
>
&g
On May 25, 2005, at 10:06 AM, David Brewster wrote:
Here is the log dump :-
Thanks
David
050525 13:24:10 InnoDB: Started
/usr/sbin/mysqld-max: ready for connections.
Version: '4.0.15-Max' socket: '/var/lib/mysql/mysql.sock' port: 3306
050525 13:24:11 InnoDB: Assertion failure in thread 114
en/Crashing.html contains
information that should help you find out what is causing the crash.
Number of processes running now: 0
-Original Message-
From: Ware Adams [mailto:[EMAIL PROTECTED]
Sent: 25 May 2005 15:58
To: David Brewster
Cc: mysql@lists.mysql.com
Subject: Re: Restoring InnoDB datab
encountered failure when
attempting to read from various tables even using the mysql command
prompt.
At this stage we decided to try restoring from backups. Now mysqld
seems to start but then die perpetually but restart itself each
time. This means that if you try something from the
various tables even using the mysql command prompt.
At this stage we decided to try restoring from backups. Now mysqld seems to
start but then die perpetually but restart itself each time. This means that if
you try something from the mysql command prompt, it usually gives you, for
example
The option in my.cnf is log-bin = 'logfilename here'
Michael
-Original Message-
From: Daniel Kasak [mailto:[EMAIL PROTECTED]
Sent: Thursday, 10 February, 2005 14:58
To: Jerry Swanson; mysql@lists.mysql.com
Subject: Re: Daily Incremental Backups on Mysql
Jerry Swanson wro
Jerry Swanson wrote:
Does binary logs are avaialbe in Mysql 4 or only in Mysql 5?
Thanks
On Thu, 10 Feb 2005 10:28:56 +1100, Daniel Kasak
<[EMAIL PROTECTED]> wrote:
Jerry Swanson wrote:
Is it possible to do "daily incremental backups" on mysql?
Thanks
MySQL 4.x
> -Original Message-
> From: Jerry Swanson
> Sent: Thursday, February 10, 2005 08:33
> To: Daniel Kasak
> Cc: mysql@lists.mysql.com
> Subject: Re: Daily Incremental Backups on Mysql
>
> Does binary logs are avaialbe in Mysql 4 or only in Mysql 5?
> Thanks
&g
Does binary logs are avaialbe in Mysql 4 or only in Mysql 5?
Thanks
On Thu, 10 Feb 2005 10:28:56 +1100, Daniel Kasak
<[EMAIL PROTECTED]> wrote:
> Jerry Swanson wrote:
>
> >Is it possible to do "daily incremental backups" on mysql?
> >
> >
> >Thank
Jerry Swanson wrote:
Is it possible to do "daily incremental backups" on mysql?
Thanks
Yes.
mysqldump will give you a starting point, and the binary transaction
logs give you your incremental backups - copy these somewhere each day -
onto a backup tape or something. Read the doc
Is it possible to do "daily incremental backups" on mysql?
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
At 19:29 +0530 10/29/04, Anil Doppalapudi wrote:
Is it possible to take incremental backups in mysql.if yes please provide me
links or info on it
Your binary logs are your incremental backups.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General
Is it possible to take incremental backups in mysql.if yes please provide me
links or info on it
Thanks
Anil
DBA
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
NLM= Novell Loadable Module
>>> Egor Egorov <[EMAIL PROTECTED]> 6/10/04 4:09:13 PM >>>
"Mark Goldfarb" <[EMAIL PROTECTED]> wrote:
> I saw the script. I am actually fine running a shutdown on the
server
> prior to each backup. Veritas BackupExec supports running commands
> prior and after eac
On Thursday 10 June 2004 15:09, Egor Egorov might have typed:
> "Mark Goldfarb" <[EMAIL PROTECTED]> wrote:
> > I saw the script. I am actually fine running a shutdown on the server
> > prior to each backup. Veritas BackupExec supports running commands
> > prior and after each backup. The problem
"Mark Goldfarb" <[EMAIL PROTECTED]> wrote:
> I saw the script. I am actually fine running a shutdown on the server
> prior to each backup. Veritas BackupExec supports running commands
> prior and after each backup. The problem I am having is if I run the
> mysqladmin --shutdown command, it gene
I saw the script. I am actually fine running a shutdown on the server
prior to each backup. Veritas BackupExec supports running commands
prior and after each backup. The problem I am having is if I run the
mysqladmin --shutdown command, it generates a message saying NLM has
been shutdown, press
"Mark Goldfarb" <[EMAIL PROTECTED]> wrote:
> Hi. Hope someone can help me. I am running MySQL on a NetWare 6.x
> server. I am using Veritas BackupExec. I currently manually copy the
> files before a backup or manually unload the MySQL server. I would like
> to automate the backup. What is t
Hi. Hope someone can help me. I am running MySQL on a NetWare 6.x
server. I am using Veritas BackupExec. I currently manually copy the
files before a backup or manually unload the MySQL server. I would like
to automate the backup. What is the best way to do a backup on a
NetWare server.
Th
Ben Ricker wrote:
I believe all the tables are MyISAM...the DB is 3.2.x.
I know there will be an inconsistency as we only do nightly backups; any
transactions that occur before the scp will not be there. If we failover
before the backup, we can have up to 24 hours of data missing.
I am concerned
I believe all the tables are MyISAM...the DB is 3.2.x.
I know there will be an inconsistency as we only do nightly backups; any
transactions that occur before the scp will not be there. If we failover
before the backup, we can have up to 24 hours of data missing.
I am concerned that we will
Ricker
To: [EMAIL PROTECTED]
Sent: 5/18/04 2:14 PM
Subject: Doing MySQl DB File backups
I am working on doing backups of a MySQl server that is running approx
20
databases. Our failover is to do a nightly scp of all /data directory
from
one server to the backup. I know that replication or
I am working on doing backups of a MySQl server that is running approx 20
databases. Our failover is to do a nightly scp of all /data directory from
one server to the backup. I know that replication or mysqldump would be
best, but I do not want to get into that.
My question is what is the
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 i
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 themselves
On Fri, Mar 19, 2004 at 11:50:43AM -0500, Charles Hauser wrote:
>
> I'm interested in writing a cron job to backup mysql that will:
> - Backup all the global information first (users and groups, typically)
This information is in the mysql database; unlike postgres, there's no
concept of ''global
All,
I'm new to mysql.
I'm interested in writing a cron job to backup mysql that will:
- Backup all the global information first (users and groups, typically)
- Backup each database independently (not dumpall)
For postgres I can dump:
- globals
pg_dumpall -U $PG_ADMIN -g > $PG_BACK
In a message dated 2/11/2004 2:26:09 PM Eastern Standard Time,
[EMAIL PROTECTED] writes:
I read this over and over.. I am curious why replication is such high
finance?? I run it here. The Production system is a high finance machine and the
replicated box is a old clunker basically.. It doesn't t
ster in the past!
Thanks,
Mike
Mike,
This is a great topic of interest to me, as I am rolling out MySQL throughout
our enterprise and naturally, the MS SysAdmin are not comfortable doing
backups on a Linux box--so I move the dumps to their backup server.
Have you tried to do all of that in o
whole thing simply uses the MS scheduler in windows.
Might be a help
Paul
> -Original Message-
> From: Michael McTernan [mailto:[EMAIL PROTECTED]
> Sent: 11 February 2004 21:41
> To: David Brodbeck; Michael Collins
> Cc: [EMAIL PROTECTED]
> Subject: RE: best-practices bac
[mailto:[EMAIL PROTECTED]
> Sent: 11 February 2004 19:27
> To: 'Michael McTernan'; Michael Collins
> Cc: [EMAIL PROTECTED]
> Subject: RE: best-practices backups
>
>
> > > -Original Message-
> > > From: Michael Collins [mailto:[EMAIL PROTECTED]
> -Original Message-
> From: Madscientist [mailto:[EMAIL PROTECTED]
> We use this mechanism, but we do our mysqldumps from a slave
> so the time doesn't matter.
Excellent idea.
> Interesting side effect: A GZIP of the data files is _huge_.
> A GZIP of the
> mysqldump is _tiny_. For
From: "David Brodbeck" <[EMAIL PROTECTED]>
Sent: Wednesday, February 11, 2004 9:27 PM
> > > -Original Message-
> > > From: Michael Collins [mailto:[EMAIL PROTECTED]
>
> > > Is there any "best-practices" wisdom on what is the most preferable
> > > method of backing up moderately (~10-20,000
date log
as necessary to get to the desired point. I use a script with the 'find'
command to weed out old backups and update logs older than a certain number
of weeks. All of this is run nightly by cron entries.
The disadvantage of this method is that mysqldump can take a while to dump
l
1 - 100 of 253 matches
Mail list logo
