MySQL Enterprise Backup 8.0.16, a new version of the online MySQL backup
tool, is now available for download from the My Oracle Support (MOS) website
as our latest GA release. This release will be available on eDelivery (OSDC)
after the next upload cycle. MySQL Enterprise Backup is a commercial
Dear MySQL users,
MySQL Enterprise Backup v3.12.4, a new version of the online MySQL backup
tool, is now available for download from the My Oracle Support (MOS) website
as our latest GA release. This release will be available on eDelivery (OSDC)
after the next upload cycle. MySQL Enterprise
Dear MySQL users,
MySQL Enterprise Backup 8.0.15, a new version of the online MySQL backup
tool, is now available for download from the My Oracle Support (MOS) website
as our latest GA release. This release will be available on eDelivery (OSDC)
after the next upload cycle. MySQL Enterprise Backup
MySQL Enterprise Backup 8.0.14, a new version of the online MySQL backup
tool, is now available for download from the My Oracle Support (MOS) website
as our latest GA release. This release will be available on eDelivery (OSDC)
after the next upload cycle. MySQL Enterprise Backup is a commercial
Dear MySQL users,
MySQL Enterprise Backup 8.0.13, a new version of the online MySQL backup
tool, is now available for download from the My Oracle Support (MOS) website
as our latest GA release. This release will be available on eDelivery (OSDC)
after the next upload cycle. MySQL Enterprise
Dear MySQL users,
MySQL Enterprise Backup 8.0.12, a new version of the online MySQL backup
tool, is now available for download from the My Oracle Support (MOS) website
as our latest GA release. This release will be available on eDelivery (OSDC)
after the next upload cycle. MySQL Enterprise
Dear MySQL users,
MySQL Enterprise Backup 8.0.11, a new version of the online MySQL backup
tool, is now available for download from the My Oracle Support (MOS)
website
as our latest GA release. This release will be available on eDelivery
(OSDC)
after the next upload cycle. MySQL Enterprise
Dear MySQL users,
MySQL Enterprise Backup v4.1.0, a new version of the online MySQL backup
tool, is now available for download from the My Oracle Support (MOS) website
as our latest GA release. This release will be available on eDelivery (OSDC)
after the next upload cycle. MySQL Enterprise
Dear MySQL users,
MySQL Enterprise Backup v4.0.2, a new version of the online MySQL backup
tool, is now available for download from the My Oracle Support (MOS) website
as our latest GA release. This release will be available on eDelivery (OSDC)
after the next upload cycle. MySQL Enterprise
On 22 Mar 2016 8:15 pm, "Lisa Smith" wrote:
> Hello all,
>
> I have not run across this problem where Workbench will not let me access
> the "Online Backup"
> link and claims that my version of MySQL Enterprise Backup is 0.0.0 (it is
> 4.0.0).
>
> I ha
Hello all,
I have not run across this problem where Workbench will not let me access
the "Online Backup"
link and claims that my version of MySQL Enterprise Backup is 0.0.0 (it is
4.0.0).
I had backups running and scheduled through Workbench previously. Yesterday
I changed my dat
Dear MySQL users,
MySQL Enterprise Backup v4.0.0, a new version of the online MySQL backup
tool, is now available for download from the My Oracle Support (MOS)
website
as our latest GA release. This release will be available on eDelivery
(OSDC)
after the next upload cycle. MySQL Enterprise
Hi All
I use mysqldump to take the backup of the entire DB. I want to know if
there is way to find out how much disk space would mysqldump require to
take the backup of the entire DB in .sql file.
Currently what we are doing is to check the size of the
/var/lib/mysql/data directory and
Dear MySQL users,
MySQL Enterprise Backup v3.11.1, a new version of the online MySQL backup
tool, is now available for download from the My Oracle Support (MOS) website
as our latest GA release. This release will be available on eDelivery (OSDC)
after the next upload cycle. MySQL Enterprise
XTrabackup can handle both InnoDB and MyISAM in
a consistent way while minimizing lock time on
MyISAM tables ...
http://www.percona.com/doc/percona-xtrabackup/2.1/
--
Hartmut Holzgraefe, Principal Support Engineer (EMEA)
SkySQL - The MariaDB Company | http://www.skysql.com/
--
MySQL General Ma
ase has a mixture of MyISAM- and
> InnoDB-tables. A backup of this mix does not seem to be easy. Until now it
> was dumped using "mysqldump --opt -u root --databases mausdb ...". What I
> understand until now is that --opt is not necessary because it is default. It
> incl
Hi,
i've been already reading the documentation the whole day, but still confused
and unsure what to do.
We have two databases which are important for our work. So both are stored
hourly. Now I recognized that each database has a mixture of MyISAM- and
InnoDB-tables. A backup of this mix
Dear MySQL users,
MySQL Enterprise Backup 3.10.2, a new version of the online MySQL backup
tool, is now available for download from the My Oracle Support (MOS)
website
as our latest GA release. This release will be available on eDelivery
(OSDC)
after the next upload cycle. MySQL Enterprise
Dear MySQL users,
MySQL Enterprise Backup v3.10.0, a new version of the online MySQL backup
tool, is now available for download from the My Oracle Support (MOS) website
as our latest GA release. This release will be available on eDelivery (OSDC)
after the next upload cycle. MySQL Enterprise
- Original Message -
> From: "Rafał Radecki"
>
> pt-table-checksum performs an online replication consistency check by
> executing checksum queries on the master, which produces
>different results on replicas that are inconsistent with the
> master. -> It should be used for verifi
Thanks, I will use this tool :)
2013/2/19 Johan De Meersman :
> - Original Message -
>> From: "Rafał Radecki"
>>
>> pt-table-checksum performs an online replication consistency check by
>> executing checksum queries on the master, which produces
>>different results on replicas tha
lem.
Any other tips?
Best regards,
Rafal Radecki.
2013/2/18 Johan De Meersman :
> - Original Message -
>> From: "Rafał Radecki"
>>
>> 3) drop mysql and app databases;
>> 4) restore them from backup;
>
> Instead of dropping the DBs, simply resto
- Original Message -
> From: "Rafał Radecki"
>
> 3) drop mysql and app databases;
> 4) restore them from backup;
Instead of dropping the DBs, simply restore to another database or server. That
will also allow you to perform a comparison using some graphical t
Hi All.
I have a development database which is replicated to a slave. Backup
is taken daily from this slave. I need to test if the restore
procedure is ok.
I would like to:
1) block all application access (stop services + iptables block) to
the database and lock it read only;
2) make a backup
, I will want to
do the following: a) restore the database backup; b) apply binary logs starting
from the exact position as of which that backup is a snapshot of my database.
If I have to use the binary logs taken on another database (f.e. backups are
taken on a replica and binary logs on a
,
>
> For doing backups on the primary database, I know nothing better than have
> your tables in InnoDB and use Innobackup (or MySQL Enterprise backup).
> This, however, still has the possibility of hanging as it is using FLUSH
> TABLES WITH READ LOCK for taking backups of MyISAM tables.
Hi,
For doing backups on the primary database, I know nothing better than have your
tables in InnoDB and use Innobackup (or MySQL Enterprise backup). This,
however, still has the possibility of hanging as it is using FLUSH TABLES WITH
READ LOCK for taking backups of MyISAM tables.One
machiel.richa...@gmail.com [mailto:machiel.richa...@gmail.com]
> Sent: Thursday, November 01, 2012 8:54 AM
> To: Reindl Harald; mysql@lists.mysql.com
> Subject: Re: Mysql backup for large databases
>
> Well, the biggest problem we have to answer for the clients is the
> followin
as said:
use a replication slave dedicated for backups
you can even let a slave write a binlog and
sync another slave with this one
* rsync backups working with diff
* they are extremly fast after the first time
* a dedicated backup-slave has ZERO impact
i am doing rsync-backups of 1.5 TB data
Well, the biggest problem we have to answer for the clients is the following:
1. Backup method that doesn't take long and don't impact system
2. Restore needs to be done on a quick as possible way in order to minimize
downtime.
The one client is running master - master replication w
ush_log_at_tx=0 or 2 and
> etc, you should be fine. We have been
> using the trio: flush tables with read lock, xfs_freeze, snapshot for months
> now without any issues. And we test
> the backups (we load the backup into a staging once a day, and dev once a
> week)
>
>
Assuming you're not doing dumb stuff like innodb_flush_log_at_tx=0 or 2 and
etc, you should be fine. We have been using the trio: flush tables with
read lock, xfs_freeze, snapshot for months now without any issues. And we
test the backups (we load the backup into a staging once a day, and dev
Am 01.11.2012 16:36, schrieb Singer Wang:
> On Thu, Nov 1, 2012 at 11:34 AM, Rick James <mailto:rja...@yahoo-inc.com>> wrote:
>
> Full backup:
> * Xtrabackup (Backup: slight impact on source; more if you have MyISAM
> (as mentioned))
> * Slave (Ba
On Thu, Nov 1, 2012 at 11:34 AM, Rick James wrote:
> Full backup:
> * Xtrabackup (Backup: slight impact on source; more if you have MyISAM (as
> mentioned))
> * Slave (Backup: zero impact on Master -- once replication is set up)
> * LVM -- a minute of server down; see below
&g
Full backup:
* Xtrabackup (Backup: slight impact on source; more if you have MyISAM (as
mentioned))
* Slave (Backup: zero impact on Master -- once replication is set up)
* LVM -- a minute of server down; see below
Full restore:
* Xtrabackup - Takes time
* Slave - minute(s) to "failover&quo
Am 01.11.2012 11:28, schrieb Machiel Richards - Gmail:
> Using mysqldump and restores on an 80-100GB database seems a bit unpractical
> as the restore times seems to
> get quite long as well as the backup times.
* setup a master/slave configuration
* stop the slave
* rsync the raw d
On 01/11/2012 11.28, Machiel Richards - Gmail wrote:
[...]
I am busy investigating some options relating to the backup for
MySQL databases when they get quite large.
When using the MySQL enterprise, there is the option to use the
MySQL enterprise backup as it is part of the
Hi All
I am busy investigating some options relating to the backup for
MySQL databases when they get quite large.
When using the MySQL enterprise, there is the option to use the
MySQL enterprise backup as it is part of the Enterprise license.
However, when using the GA
Just for others to know, it was the memory problem. I re-set the memory
parameters for ndbmtd (two nodes) to minimum. Then I could run the backup
successfully.
Thanks
BA
On Wed, Oct 24, 2012 at 11:57 AM, Bheemsen Aitha wrote:
> Hi,
>
> After following the steps at the following w
On 10/24/2012 11:57 AM, Bheemsen Aitha wrote:
Hi,
After following the steps at the following website, I tried to do an online
backup of the cluster.
http://dev.mysql.com/doc/refman/5.0/en/mysql-cluster-backup-using-management-client.html
It is a plain vanilla command which is below. The
Hi,
After following the steps at the following website, I tried to do an online
backup of the cluster.
http://dev.mysql.com/doc/refman/5.0/en/mysql-cluster-backup-using-management-client.html
It is a plain vanilla command which is below. The cluster is almost an
empty database, but backup is
http://www.percona.com/doc/percona-xtrabackup/
Cheers
Claudio
2012/10/23 Sabika M
> hi!
>
> I am trying to work with percona's extra backup. Has anyone found any
> simple instructions how to install it? We are using innodb file per table
>
> Thanks!
> Sabika
>
--
Claudio
hi!
I am trying to work with percona's extra backup. Has anyone found any
simple instructions how to install it? We are using innodb file per table
Thanks!
Sabika
Am 09.06.2012 03:29, schrieb Keith Keller:
> On 2012-06-09, Miguel Cardenas wrote:
>> I'm still backing up and will take some time before restore the
>> system, in the mean time I want to know if I can restore the databases
>> from the *.frm *.MYD and *.MYI files, maybe creating the databases
>>
On 2012-06-09, Miguel Cardenas wrote:
>
> My linux system died due a bad system driver and it does not boot
> ANYMORE, I am backing up my data files to restore a previous worlking
> backup of the whole system that DOES NOT INCLUDE THE DATABASES...
I hope you will be correcting that i
Hello
My linux system died due a bad system driver and it does not boot
ANYMORE, I am backing up my data files to restore a previous worlking
backup of the whole system that DOES NOT INCLUDE THE DATABASES...
I'm still backing up and will take some time before restore the
system, in the mean
> Hello,
>
> I'm new here, so since this is my first question email, I'm looking for an
> advice/help a way to do it or a link which can explain me more about my
> related question.
> [snip]
Carlos, you might have better luck if you break the problem down into smaller
pieces.. both to make it
Hello,
I'm new here, so since this is my first question email, I'm looking for an
advice/help a way to do it or a link which can explain me more about my
related question.
This is the thing:
Reciently I've made a backup of a database using INNODB, 1GB database, for
a web based
On Fri, May 13, 2011 at 10:21, Joerg Bruehe wrote:
> Hi everybody!
>
>
> Dotan Cohen wrote:
>> Is there a simple browser-based MySQL backup solution for
>> non-technical users. [[...]]
>> The main features needed are:
>> 1) Automatic scheduled off-site backups
Hi everybody!
Dotan Cohen wrote:
> Is there a simple browser-based MySQL backup solution for
> non-technical users. [[...]]
> The main features needed are:
> 1) Automatic scheduled off-site backups (via SSH or FTP)
Off-site = good (for reliability purposes).
> 2) Backup multipl
On Tue, May 10, 2011 at 22:58, Michael Heaney wrote:
> Check out Zmanda: http://zmanda.com/zrm-mysql-enterprise.html
>
> Michael Heaney
> JCVI
>
On Wed, May 11, 2011 at 10:00, Johan De Meersman wrote:
> Zmanda ZRM backup, although the fancy webinterface is only available in
Zmanda ZRM backup, although the fancy webinterface is only available in the
commercial version. Backups are stored on the host that runs the server, and of
course it serves multiple MySQL machines.
Webinterface is annoyingly slow, though :-)
- Original Message -
> From: "
On 5/10/2011 3:55 PM, Dotan Cohen wrote:
Is there a simple browser-based MySQL backup solution for
non-technical users. The server is running Red Hat Enterprise Linux.
The main features needed are:
1) Automatic scheduled off-site backups (via SSH or FTP)
2) Backup multiple databases and all
Is there a simple browser-based MySQL backup solution for
non-technical users. The server is running Red Hat Enterprise Linux.
The main features needed are:
1) Automatic scheduled off-site backups (via SSH or FTP)
2) Backup multiple databases and all their tables
3) Single-table recovery via GUI
u have the dump function do the locking it will also remember
to "restart" it when its done.
> On Mar 22, 2011, at 6:01 AM, Johan De Meersman wrote:
>
>>
>> You are assuming that the database is one table of 5.000 gigabyte, and
>> not 5.000 tables of one gigabyte;
at the database is one table of 5.000 gigabyte, and not
> 5.000 tables of one gigabyte; and that the backup needs to be consistent :-p
>
>
> - Original Message -
>> From: "Reindl Harald"
>> To: mysql@lists.mysql.com
>> Sent: Monday, 21 March, 2011 12:
You are assuming that the database is one table of 5.000 gigabyte, and not
5.000 tables of one gigabyte; and that the backup needs to be consistent :-p
- Original Message -
> From: "Reindl Harald"
> To: mysql@lists.mysql.com
> Sent: Monday, 21 March, 2011 12:44:
X.J. Wang wrote:
> Also, very important but often not asked:
>
> 1) What's my budget?
>
>
> On Mon, Mar 21, 2011 at 14:24, Karen Abgarian wrote:
> Hi,
>
> The statement like 'I need to back up a 5T database' is not a backup
> strategy. It is inte
Hi,
The statement like 'I need to back up a 5T database' is not a backup strategy.
It is intention. There are some specifics that have to be determined to work
out a strategy. Going from there, the backup solution can be chosen. The
examples of questions one typically
Forget mysqldump because TABLE LOCKS for so hughe databases
I would setup a replication-slave because you can stop
the salave and make a filesystem-backup of the whole db-folder
while the production server is online, we do this with our
dbmail-server since 2009
Am 21.03.2011 12:23, schrieb Pedro
Hi
I need set up a backup strategy for a mysql database in a ubuntu server,
the database will grow up to a 5TB.
What would be the best option ?? Maybe a script that uses mysqldump?? There
is a better way to do this?
Thanks in advance to all
Pedro.
Interestingly, this page does not say anything about MySQL Enterprise
Backups.
On Mar 15, 2011, at 8:48 AM, a.sm...@ukgrid.net wrote:
Hi,
there is a lot of info on different backup methods here:
http://dev.mysql.com/doc/refman/5.1/en/backup-methods.html
For example, for incremental
e:
>>> Dear all,
>>>
>>> Taking Backup is must needed task in Database Servers. [[...]]
>>
>> Correct.
>>
>>>
>>> We have options RAID, mylvmbackup , mysqldump. But it depends on the
>>> company requirement too.
>>
>&g
On Tue, March 15, 2011 12:36, Joerg Bruehe wrote:
> Hi!
>
>
> Adarsh Sharma wrote:
>> Dear all,
>>
>> Taking Backup is must needed task in Database Servers. [[...]]
>
> Correct.
>
>>
>> We have options RAID, mylvmbackup , mysqldump. But it depend
Hi!
Adarsh Sharma wrote:
> Dear all,
>
> Taking Backup is must needed task in Database Servers. [[...]]
Correct.
>
> We have options RAID, mylvmbackup , mysqldump. But it depends on the
> company requirement too.
RAID is no backup!
A RAID system may give you protectio
- Original Message -
> From: "Krishna Chandra Prajapati"
>
> incremental backup using zamanda.
I'm running Zmanda on about two dozen hosts, and it comes well-recommended. It
doesn't do anything that you can't do yourself, but it's easy to set up,
Hi,
there is a lot of info on different backup methods here:
http://dev.mysql.com/doc/refman/5.1/en/backup-methods.html
For example, for incremental backups see "Making Incremental Backups
by Enabling the Binary Log",
cheers Andy.
--
MySQL General Mailing List
For list arch
xtrabackup, mysqlhotcopy for myisam, incremental backup using zamanda.
Krishna
On Tue, Mar 15, 2011 at 9:09 PM, petya wrote:
> Hi,
>
> What storage engine are you using?
>
> Peter Boros
>
> On 03/15/2011 02:12 PM, Adarsh Sharma wrote:
>
>> Dear all,
>>
>
Hi,
What storage engine are you using?
Peter Boros
On 03/15/2011 02:12 PM, Adarsh Sharma wrote:
Dear all,
Taking Backup is must needed task in Database Servers. I research a lot
and find techniques to perform it in Mysql.
We have options RAID, mylvmbackup , mysqldump. But it depends on the
Dear all,
Taking Backup is must needed task in Database Servers. I research a lot
and find techniques to perform it in Mysql.
We have options RAID, mylvmbackup , mysqldump. But it depends on the
company requirement too.
We have a database of more than 250GB in mysql database & whic
Hmm, I haven't seen the mail from Singer, yet.
On Thu, Feb 10, 2011 at 9:33 AM, Ananda Kumar wrote:
> On Thu, Feb 10, 2011 at 1:58 PM, Singer X.J. Wang wrote:
>
>> mysqldump -u[user] -p[pass] --where="db=`whatyouwant` and
>> name=`whatyouwant`" mysql proc
>>
>
Yes, I thought of that, too; but th
; On Thu, Feb 10, 2011 at 02:55, Ananda Kumar wrote:
>
>> there is -p option please used that.
>>
>> On Thu, Feb 10, 2011 at 12:47 PM, Johan De Meersman > >wrote:
>>
>> > On Thu, Feb 10, 2011 at 7:43 AM, Adarsh Sharma <
>> adarsh.sha...@orkash.com
>&g
there is -p option please used that.
On Thu, Feb 10, 2011 at 12:47 PM, Johan De Meersman wrote:
> On Thu, Feb 10, 2011 at 7:43 AM, Adarsh Sharma >wrote:
>
> > I am researching all the ways to backup in mysql and donot able to find a
> > command that take individual backup
On Thu, Feb 10, 2011 at 7:43 AM, Adarsh Sharma wrote:
> I am researching all the ways to backup in mysql and donot able to find a
> command that take individual backup of only one procedure in mysql.
>
Have a look at the SHOW CREATE PROCEDURE syntax. It's not mysqldump, but i
Dear all,
I am researching all the ways to backup in mysql and donot able to find
a command that take individual backup of only one procedure in mysql.
I know this command and it needs some modification. Please help.
mysqldump -h192.168.0.10 -uroot -porkash --routines --no-create-info
--no
On 10/13/2010 9:18 AM, kranthi wrote:
Hi
Please be send sample incremental backup script (bash Shell script
Easy to understand)
Thanks& Regards,
Kranthikiran
I think you missed the points of the previous replies.
MySQL does not do incremental backups the the same way
Hi
Please be send sample incremental backup script (bash Shell script
Easy to understand)
Thanks & Regards,
Kranthikiran
Hi,
On Sat, Oct 9, 2010 at 4:21 AM, wrote:
> Hello,
>
> Is there any good document for backup of InnoDB?
> includes the increment backup and full backup.
There is an overview of backups here
http://dev.mysql.com/doc/refman/5.1/en/backup-methods.html
XtraBackup supports increme
I'm interested in InnoDB backups. Does anyone use PHPMyAdmin ? I've a
MySQL server on a shared hosting server.
Cheers
Neil
On Sat, Oct 9, 2010 at 3:21 AM, wrote:
> Hello,
>
> Is there any good document for backup of InnoDB?
> includes the increment backup and f
Hi kranthi,
Take a look at LVM and xtrabackup.
http://www.mysqlperformanceblog.com/2009/02/24/xtrabackup-open-source-alternative-for-innodb-hot-backup-call-for-ideas/
http://marcus.bointon.com/archives/87-MySQL-backups-with-Perconas-XtraBackup.html
Krishna
CGI (cgi.com)
On Sun, Oct 10, 2010
/var/log/mysql/bin.123456 \
>
> > /tmp/mysql_restore.sql
>
>
>
>
>
> Thanks all
>
>
>
>
>
> From: andrew.2.mo...@nokia.com [mailto:andrew.2.mo...@nokia.com]
> Sent: Sunday, October 10, 2010 4:46 AM
> To: kranthikiran@gmail.com
> Subject: Re:
Sent: Sunday, October 10, 2010 4:46 AM
To: kranthikiran@gmail.com
Subject: Re: Backup
hmm a yesterday backup? MySqldump using where clauses? Why do you only want
yesterday?
-- Sent from my HTC Desire on 3 --
- Reply message -
From: "ext kranthi"
Date: Sun, Oct 10, 20
Hey Kranthi,
If you have binlogs enabled, do a binary logs backup everyday i.e going to
be your everyday backup which consists of the sql modified statements.
On Sun, Oct 10, 2010 at 11:13 AM, yung wrote:
> 2010/10/10 kranthi :
> >
> >
> > Hi ,
> >
> >
2010/10/10 kranthi :
>
>
> Hi ,
>
> My database size is 900GB.i don't want full database backup. I
> need only yesterday backup. how can I take, please help me.
>
How about the document there:
http://dev.mysql.com/doc/refman/5.1/en/backup-strategy-example.html
Hello,
Is there any good document for backup of InnoDB?
includes the increment backup and full backup.
Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
>-Original Message-
>From: Raj Shekhar [mailto:rajl...@rajshekhar.net]
>Sent: Friday, May 28, 2010 2:40 PM
>To: mysql@lists.mysql.com
>Cc: mysql@lists.mysql.com
>Subject: Re: mysqldump backup
>
>In infinite wisdom Angelina Paul wrote:
>
>> [1 ]
>>
In infinite wisdom Angelina Paul wrote:
> [1 ]
> I looking for a way to corrupt a mysql database forcefully for testing
> purpose
> and then the mysqldump utility will fail for taking backup against it.
kill -9 MYSQLD_PID while the backup is running should give you an
indicatio
I looking for a way to corrupt a mysql database forcefully for testing
purpose
and then the mysqldump utility will fail for taking backup against it.
On Fri, May 28, 2010 at 8:06 AM, Anand.S wrote:
> redirect your standard errors to some log file..
>
> mysqldump --all-databases --f
wrote:
> Could you please inform me how to test the mysql databases backup failure
> by
> using the mysqldump utility. I written a unix script for sending status
> notification against ten mysql databases. I need to test the nine databases
> backups have completed successfully and one f
Could you please inform me how to test the mysql databases backup failure by
using the mysqldump utility. I written a unix script for sending status
notification against ten mysql databases. I need to test the nine databases
backups have completed successfully and one failed due some reason
Hi,
I have the problem that i have to backup several databases who include a mix of
InnoDB- and MyISAM-tables.
I'd like to use mysqldump. The manpage proposes different options for MyISAM-
and InnoDB-tables. What is about --single-transaction ? --single-transaction is
recommend for I
Carlos mennens wrote:
>
> Can you guys recommend something for me here? I don't really
> know enough about MySQL 'grant' permissions to determine
> which would work or if the 'backup' user would require high
> level privileges.
>
Hi,
Set the
I downloaded a MySQL script that backs up all my databases
automatically which looks to work amazing. My question is in this
particular script (linked below) there is a section to add a user name
and password for someone who has access to the databases I am
attempting to backup with the script
Hi Carlos,
I would say the below grants for a user to perform backup is the minimum
grants which we can provide..
grant select , lock tables, file on *.* to backup_user'@'localhost'
identified by 'somepassword';
Thanks
Anand
On Wed, Apr 28, 2010 at 10:28 PM, C
I downloaded a MySQL backup script today since I have 3 or 4
relatively small databases. The script can be found here:
http://sourceforge.net/projects/automysqlbackup/
Now I was wondering if I can create a local database user
'backup'@'localhost' & grant him a level
hello,
i'm new to MySQL, so i have currently some basic questions.
I have a MySQL-Server with 15 users. Every User can create databases. I expect
that the amount of data which has to be backuped will increase constantly. What
i want:
I'd like to have a backup on a regular basis. I th
Claudio,
So innodb may not be consistent between memory and disk at all times, but
that's actually not important. What is important is that the files on disk to
be consistent with a specific binlog position. That's all that is needed for a
consistent backup, and can be done with
>-Original Message-
>From: Claudio Nanni [mailto:claudio.na...@gmail.com]
>Sent: Wednesday, April 21, 2010 2:12 AM
>Cc: mysql@lists.mysql.com
>Subject: Re: better way to backup 50 Gig db?
>
[JS]
[JS] Unless I've forgotten something from earlier in my career (w
t I state
>> is
>> that there is only one 100% guaranteed safe way to have binary backups.
>>
>> have a look at these, very interesting:
>>
>> http://forge.mysql.com/w/images/c/c1/MySQL_Backups_using_File_System_Snapshots-2009-02-26.pdf
>>
>> http://www.
A Nice SQL dump with table locked are also very good, the problem is you
will lock the database for the time needed to dump it.
If you do it good like:
lock all tables
flush logs
dump
unlock tables
you will know where to start in case of recovery dump+binary logs
Cheers!
Claudio
2010/4/21 Jo
1 - 100 of 1057 matches
Mail list logo
