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
Mar 2016 8:15 pm, "Lisa Smith" <lea...@gmail.com> 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
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
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
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
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 does
- 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
includes, among others, --lock-tables which is senseful
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
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
.
Any other tips?
Best regards,
Rafal Radecki.
2013/2/18 Johan De Meersman vegiv...@tuxera.be:
- Original Message -
From: Rafał Radecki radecki.ra...@gmail.com
3) drop mysql and app databases;
4) restore them from backup;
Instead of dropping the DBs, simply restore to another
Thanks, I will use this tool :)
2013/2/19 Johan De Meersman vegiv...@tuxera.be:
- Original Message -
From: Rafał Radecki radecki.ra...@gmail.com
pt-table-checksum performs an online replication consistency check by
executing checksum queries on the master, which produces
- Original Message -
From: Rafał Radecki radecki.ra...@gmail.com
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
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
- Original Message -
From: Rafał Radecki radecki.ra...@gmail.com
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 tool
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 may want
to script it to kill the 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
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
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
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 datadir
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, mostly
On Thu, Nov 1, 2012 at 11:34 AM, Rick James rja...@yahoo-inc.com 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
Why
Am 01.11.2012 16:36, schrieb Singer Wang:
On Thu, Nov 1, 2012 at 11:34 AM, Rick James rja...@yahoo-inc.com
mailto:rja...@yahoo-inc.com wrote:
Full backup:
* Xtrabackup (Backup: slight impact on source; more if you have MyISAM
(as mentioned))
* Slave (Backup: zero impact
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
once
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)
On Thu, Nov 1, 2012 at 11:41 AM, Reindl Harald h.rei
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 with master
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
[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
following:
1. Backup method that doesn't take long and don't
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
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
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
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 pgb...@motorola.comwrote:
Hi,
After following the steps at the following
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
http://www.percona.com/doc/percona-xtrabackup/
Cheers
Claudio
2012/10/23 Sabika M sabika.makhd...@gmail.com
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
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 time
On 2012-06-09, Miguel Cardenas renit...@gmail.com 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
Am 09.06.2012 03:29, schrieb Keith Keller:
On 2012-06-09, Miguel Cardenas renit...@gmail.com 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
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 - software (IEM
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 multiple databases and all
On Fri, May 13, 2011 at 10:21, Joerg Bruehe joerg.bru...@oracle.com 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 (via SSH or FTP)
Off
On Tue, May 10, 2011 at 22:58, Michael Heaney mhea...@jcvi.org 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 vegiv...@tuxera.be wrote:
Zmanda ZRM backup, although the fancy webinterface is only
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: Michael Heaney
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
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
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 h.rei...@thelounge.net
To: mysql@lists.mysql.com
Sent: Monday, 21 March, 2011 12:44:08 PM
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 h.rei...@thelounge.net
To: mysql@lists.mysql.com
Sent: Monday, 21 March, 2011 12:44:08 PM
Subject: Re: Question about
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; and that the backup needs to be
consistent :-p
- Original
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.
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,
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 asks when
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 a...@apple.com wrote:
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
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
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 which
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
xtrabackup, mysqlhotcopy for myisam, incremental backup using zamanda.
Krishna
On Tue, Mar 15, 2011 at 9:09 PM, petya pe...@petya.org.hu wrote:
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
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 archives: http
- Original Message -
From: Krishna Chandra Prajapati prajapat...@gmail.com
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,
reports well and backs
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 protection against a single disk
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 depends on the
company requirement too.
RAID is no backup!
A RAID
to more convenient ways, as storage and hardware is pretty cheap but
time in a critical failure is not cheap.
Jim McNeely
On Mar 15, 2011, at 1:51 PM, Wm Mussatto wrote:
On Tue, March 15, 2011 12:36, Joerg Bruehe wrote:
Hi!
Adarsh Sharma wrote:
Dear all,
Taking Backup is must needed
at 02:55, Ananda Kumar anan...@gmail.com wrote:
there is -p option please used that.
On Thu, Feb 10, 2011 at 12:47 PM, Johan De Meersman vegiv...@tuxera.be
wrote:
On Thu, Feb 10, 2011 at 7:43 AM, Adarsh Sharma
adarsh.sha...@orkash.com
wrote:
I am researching all the ways to backup
Hmm, I haven't seen the mail from Singer, yet.
On Thu, Feb 10, 2011 at 9:33 AM, Ananda Kumar anan...@gmail.com wrote:
On Thu, Feb 10, 2011 at 1:58 PM, Singer X.J. Wang w...@singerwang.comwrote:
mysqldump -u[user] -p[pass] --where=db=`whatyouwant` and
name=`whatyouwant` mysql proc
Yes, 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
On Thu, Feb 10, 2011 at 7:43 AM, Adarsh Sharma adarsh.sha...@orkash.comwrote:
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
there is -p option please used that.
On Thu, Feb 10, 2011 at 12:47 PM, Johan De Meersman vegiv...@tuxera.bewrote:
On Thu, Feb 10, 2011 at 7:43 AM, Adarsh Sharma adarsh.sha...@orkash.com
wrote:
I am researching all the ways to backup in mysql and donot able to find a
command that take
Hi
Please be send sample incremental backup script (bash Shell script
Easy to understand)
Thanks Regards,
Kranthikiran
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
/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: Backup
hmm a yesterday backup? MySqldump using where clauses? Why do you only want
yesterday?
-- Sent from my HTC
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
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, short.cut...@yahoo.com.cn wrote:
Hello,
Is there any good document for backup of InnoDB?
includes the increment backup and full backup
Hi,
On Sat, Oct 9, 2010 at 4:21 AM, short.cut...@yahoo.com.cn 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
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 inno...@gmail.com wrote:
2010/10/10 kranthi kranthikiran@gmail.com:
Hi
, 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 kranthikiran@gmail.com
Date: Sun, Oct 10, 2010 04:51
Subject
2010/10/10 kranthi kranthikiran@gmail.com:
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
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
...@gmail.com 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 failed due
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 anand@gmail.com wrote:
redirect your standard errors to some log file..
mysqldump --all-databases
In infinite wisdom Angelina Paul arshup...@gmail.com wrote:
[1 text/plain; ISO-8859-1 (7bit)]
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
-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 arshup...@gmail.com wrote:
[1 text/plain; ISO-8859-1 (7bit)]
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 rights of the script file to rwx-- . So only
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 InnoDB
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, Carlos Mennens carlosw
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
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 of permissions needed
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 think i
Gavin,
Right,
that is also an option, but you are really not sure 100% that everything
that is on memory is on the disk (buffers etc...)
also if it is definitely good for a disaster recovery.
What I meant is that the only way to have a 100% guaranteed consistent
binary backup is when
no guarantee that there isn't an application
in the middle of multiple insert statements the moment you shut your
database or your application. You can't magically get full consistency out
of your database if your application hasn't been designed for it.
Shutting systems down for backup may be fine
, what 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.mysqlperformanceblog.com/2006/08/21/using-lvm-for-mysql-backup
On Wed, Apr 21, 2010 at 10:50 AM, Claudio Nanni claudio.na...@gmail.comwrote:
Johan,
Is the fact that InnoDB ignores the command FLUSH TABLES WITH READ LOCK;
enough? :)
InnoDB has buffers and activities going on even if you locked the tables
and you are not sure that its buffers are on the
1 - 100 of 1024 matches
Mail list logo