Re: Mysql backup for large databases

at 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 server >> in usa, and slave in south africa. They need mast

Re: Mysql backup for large databases

ster - master replication with master server > in usa, and slave in south africa. They need master backup to be done in > the states. > > > > > > Sent via my BlackBerry from Vodacom - let your email find you! > > > > -Original Message- >

Re: Mysql backup for large databases

; Sent via my BlackBerry from Vodacom - let your email find you! > > -Original Message- > From: Reindl Harald > Date: Thu, 01 Nov 2012 16:49:45 > To: mysql@lists.mysql.com > Subject: Re: Mysql backup for large databases > > good luck &g

RE: Mysql backup for large databases

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

Re: Mysql backup for large databases

ent via my BlackBerry from Vodacom - let your email find you! > > -Original Message- > From: Reindl Harald > Date: Thu, 01 Nov 2012 16:49:45 > To: mysql@lists.mysql.com > Subject: Re: Mysql backup for large databases > > good luck >

Re: Mysql backup for large databases

ith master server in usa, and slave in south africa. They need master backup to be done in the states. Sent via my BlackBerry from Vodacom - let your email find you! -Original Message- From: Reindl Harald Date: Thu, 01 Nov 2012 16:49:45 To: mysql@lists.mysql.com Subject: Re: Mysql backup

Re: Mysql backup for large databases

good luck i would call snapshots on a running system much more dumb than "innodb_flush_log_at_trx_commit = 2" on systems with 100% stable power instead waste IOPS on shared storages Am 01.11.2012 16:45, schrieb Singer Wang: > Assuming you're not doing dumb stuff like innodb_flush_log_at_tx=0 or 2

Re: Mysql backup for large databases

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

Re: Mysql backup for large databases

Am 01.11.2012 16:36, schrieb Singer Wang: > 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

Re: Mysql backup for large databases

e (5.6.x?), you can disconnect a partition from a > table and move it to another table; this will greatly speed up "archiving". > > > -Original Message- > > From: Reindl Harald [mailto:h.rei...@thelounge.net] > > Sent: Thursday, November 01, 2012 4:47 AM > > To:

RE: Mysql backup for large databases

t] > Sent: Thursday, November 01, 2012 4:47 AM > To: mysql@lists.mysql.com > Subject: Re: Mysql backup for large databases > > > > Am 01.11.2012 11:28, schrieb Machiel Richards - Gmail: > > Using mysqldump and restores on an 80-100GB database seems a bit > > un

Re: Mysql backup for large databases

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 to wh

Re: Mysql backup for large databases

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 Enterprise

Re: MySQL Backup solution for non-technical user

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 (via SSH or FTP) > > Off-site = good

Re: MySQL Backup solution for non-technical user

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 a

Re: MySQL Backup solution for non-technical user

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 the > commercial

Re: MySQL Backup solution for non-technical user

;Michael Heaney" > To: mysql@lists.mysql.com > Sent: Tuesday, 10 May, 2011 9:58:43 PM > Subject: Re: MySQL Backup solution for non-technical user > > Check out Zmanda: http://zmanda.com/zrm-mysql-enterprise.html > > > Michael Heaney > JCVI > -- Bier met grenady

Re: MySQL Backup solution for non-technical user

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 their

Re: MySQL-Backup incremental Backups in a Master/Slave Environment

Hi, first thanks for your response Are you using InnoDb or MyISAM? If you are using Inno, I would add --single-transaction to your mysqldump command within the Perl script and flush the logs prior to doing the backup and not backup the new bin-log file until the next. No, there is a mixture b

Re: Mysql backup scheduler.

Manivannan - In a word, no. It's database software, not, um, cron. :) There are scheduled events in 5.1, but that is more of a trigger-like functionality than what you need, which is a scheduled task to save your data somewhere. http://dev.mysql.com/doc/refman/5.1/en/events.html You could loo

Re: mysql backup methods

Vitaliy Okulov a écrit : > Здравствуйте, mysql. > > Hi all. I searching mysql backup script, which detect type of table & > use mysqlhotcopy for MyISAM or mysqldump --single-transaction for > InnoDB. > Also save structure of table in file. > And support recovery for dumped db an tables. > Somebody

Re: Mysql Backup/Dump

I just moved my databases to 4.1 from 3.23. It went pretty smoothly. First I used mysqldump to back up the data. Then installed 4.1. First thing did was import only the mysql table. Then ran /mysql_fix_privilege_tables command. After that I was able to login to mysql with my old root password.

Re: Mysql Backup/Dump

It is recommended that you upgrade to 4.0.x first from 3.23.xx, because of any changes to the grant tables in the mysql database, make sure you read the upgrade notes before upggrading, here's a good link to upgrade, http://dev.mysql.com/doc/mysql/en/upgrade.html I find it very simple to zip all

Re: Mysql Backup/Dump

If you are on Windows then you can use a GUI like SQLyog (www.webyog.com) to do the job. I think it will be the easiest way to do that. Karam --- Kory Wheatley <[EMAIL PROTECTED]> wrote: > I want to backup our entire Mysql database structure > for > mysql 3.23.58 and dump it in the newly insta

Re: Mysql Backup/Dump

different box, different versions, use export/import (backup table or LOAD DATA) Mathias Selon Kory Wheatley <[EMAIL PROTECTED]>: > I want to backup our entire Mysql database structure > for > mysql 3.23.58 and dump it in the newly installed > mysql 4.1.10 > > What is the best command to do a

Re: MySQL backup not backing up all tables

I assume you are running this with cron. Do you get an error message from cron? Do you have enough room on the destination disk for all 88 tables? How big is the backup file? For completeness, what is your OS, and what is your mysql version? Michael Danny Smitherman wrote: I am having trouble

Re: mysql backup script

Thanks to all that responded. The answer was a little different from the one below. So what it came out to was this: while [ -f $mysqlpid ] do sleep 1 /etc/rc.d/init.d/mysqld stop done For those that recommended webmin. Although I have webmin installed, because of the

Re: mysql backup script

On Tue, Jun 15, 2004 at 08:04:00AM -0500, Steve Buehler wrote: > I am having a problem with a backup script that is written in a shell > (/bin/sh) script to backup my mysql databases. For some reason on any day > with an even number I get the following error: > MySQL could not be stopped, exitin

Re: MySQL Backup advice

y, March 04, 2004 12:09 PM Subject: Re: MySQL Backup advice > Hi Ware Adams, > > thanks for your answer. Here's another question: > > Is it possible to set MySQL to save all the changes that can happen, for > example, if some one insert a new record into table X, MySQL save a l

Re: MySQL Backup advice

Andre MATOS wrote: >Is it possible to set MySQL to save all the changes that can happen, >for example, if some one insert a new record into table X, MySQL save >a log about this task performed and all data that was inserted. I >another person update one field from table Y, MySQL save all the >info

Re: MySQL Backup advice

Hi Ware Adams, thanks for your answer. Here's another question: Is it possible to set MySQL to save all the changes that can happen, for example, if some one insert a new record into table X, MySQL save a log about this task performed and all data that was inserted. I another person update one

Re: MySQL Backup advice

Andre MATOS wrote: >What is the best way to make a good and trustable backup from a live >database, in other words, without shutdown the database? Is there any >free open source tool for this also? There's no free/open source tool that makes a true hot backup when you're using InnoDB. mysqldump

Re: Mysql backup problem

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Binay -- Saw your post over in php-general but it's better over here :-) ...and then Binay said... % % Hi all ! Hi! % % I have two systems. % one with mysql-version: 3.23.37 % other with mysql-version: 3.23.58 OK. % % now i want to take the

RE: MySQL Backup

> >> > >> > > > >I usually just copy the complete DB directory from one > computer to another > >one. With fast ethernet it takes around 5-10 minutes (30 > minutes if I have > >to backup the table where I store images). Only thing is > that mysql can't > >write to the table currently being

Re: MySQL Backup

Hello! Erlend Hopsø Strømsvik wrote: > > >>-Original Message- >>From: Tom McCay (Ramesys - Nottingham) [mailto:[EMAIL PROTECTED]] >>Sent: 3. september 2002 11:59 >>To: [EMAIL PROTECTED] >>Subject: MySQL Backup >> >> >>Hi, can someone point me in the right direction please >>regarding

RE: MySQL Backup

> -Original Message- > From: Tom McCay (Ramesys - Nottingham) [mailto:[EMAIL PROTECTED]] > Sent: 3. september 2002 11:59 > To: [EMAIL PROTECTED] > Subject: MySQL Backup > > > Hi, can someone point me in the right direction please > regarding backing up > a MySQL database using Veritas

RE: RE: MySQL Backup and Recovery

-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 03, 2002 1:53 PM To: Chetan Lavti Subject: Re: RE: MySQL Backup and Recovery Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the

Re: MySQL Backup and Recovery

CTED]> Sent: Saturday, March 02, 2002 9:31 PM Subject: Re: MySQL Backup and Recovery > On Fri, Mar 01, 2002 at 09:26:36AM +0530, Chetan Lavti wrote: > > > > Hi, > > > > I am planning to have MySQL database backup and recovery from the > > web interface. Is it possi

Re: MySQL Backup and Recovery

On Fri, Mar 01, 2002 at 09:26:36AM +0530, Chetan Lavti wrote: > > Hi, > > I am planning to have MySQL database backup and recovery from the > web interface. Is it possible to do this. If yes, then what > procedure I should follow. If anybody have any idea about this then > please, do help me.

Re: [MySQL] Backup error

>Fortunately, these were only test databases so there won't be much >loss. My question is in the future, is there a recommended way of backing >up the databases that will not cause any errors? I'm using mysqldump to create backups.. but that's on linux, I'm not sure about windooz version. Pr

Re: [MySQL] Backup error

Unfortunately, you're using MySQL on a Microsoft product, and you've probably run into one of those issues where Redmond decided what's best for you (changing the 'case' of the filenames). BUT, in both the Microsoft and UNIX realm of products, 'packaging' files (on UNIX using 'tar' and 'gzip',

Re: MySql backup and restore.

You dont need a script or command to restore the database, mysqlhotcopy just creates a copy of your database files (.MYI, etc.) in the /pathToTheBackupDirectory/. It basicaly performs the same function as the unix command cp, only it does the necessary locking, etc. John Barton Unix Systems Admin