Backup

Hi!

I have been reading a little about how to make backups on a database with
mostly InnoDB-tables and the scheme that seems to be the best (as far as I
understand) is to run two instances of mysql on the same machine and having
one of the instances to replicate the other. This because one can take the
slave down for backup without disturbing the master.

Is this the preferd (free) solution?

And since I'm already writing, how do I get mysqld to use a
configuration-file named C:\mysql\conf\master.conf?

Thanks in advance
Roland Carlsson


------------------------------------------------------------ ---------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail win32-thread10686@lists.mysql.com

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail win32-unsubscribe@lists.mysql.com instead.

RE: backup

I backup a MySQL database like this.

I run a Windows batch file that contains

C:\cygwin\bin\bash expdump.sh

The file expdump.sh contains

/cygdrive/C/Program\ Files/MySQL/MySQL\ Server\ 5.0/bin/mysqldump.exe -a =
-h --opt -u -p -P3306 -rpedump.sql
/cygdrive/C/Util/pkzip -a expdump$(/cygdrive/C/cygwin/bin/date =
+%G%m%d).zip pedump.sql
/cygdrive/C/cygwin/bin/rm pedump.sql

You will need to change the things in <> to match your settings.

I am actually running bash from cygwin just so I can create a file name =
with the date embedded in it. I could not find a simple way to do that =
in Windows.

The important bit is running mysqldump.

mysqldump.exe -a -h --opt -u -p -P3306 =
-rpedump.sql

Pkzip just makes the dump file much smaller so that I can keep several =
backups.=20

John B.

-----Original Message-----
From: Mat=EDas Castilla [mailto:matias.castilla@hospitalitaliano.org.ar] =

Sent: Thursday, 6 October 2005 5:19 AM
To: MySQL-Win32
Subject: backup

Do you know where could I find info about mysqlbackup script to run it =
in a
Win2000 server?
mat=EDas



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

Re: backup

You can use %date% to retrieve the date so "dump_%date%.sql" would yield
today dump_2005-10-05.sql

One caveat, make sure you change your short date format to yyyy-MM-dd to
make this work.

Marcel

jbonnett@sola.com.au wrote:

>I backup a MySQL database like this.
>
>I run a Windows batch file that contains
>
>C:\cygwin\bin\bash expdump.sh
>
>The file expdump.sh contains
>
>/cygdrive/C/Program\ Files/MySQL/MySQL\ Server\ 5.0/bin/mysqldump.exe -a -h --opt -u -p -P3306 -rpedump.sql
>/cygdrive/C/Util/pkzip -a expdump$(/cygdrive/C/cygwin/bin/date +%G%m%d).zip pedump.sql
>/cygdrive/C/cygwin/bin/rm pedump.sql
>
>You will need to change the things in <> to match your settings.
>
>I am actually running bash from cygwin just so I can create a file name with the date embedded in it. I could not find a simple way to do that in Windows.
>
>The important bit is running mysqldump.
>
>mysqldump.exe -a -h --opt -u -p -P3306 -rpedump.sql
>
>Pkzip just makes the dump file much smaller so that I can keep several backups.
>
>John B.
>
>-----Original Message-----
>From: Matías Castilla [mailto:matias.castilla@hospitalitaliano.org.ar]
>Sent: Thursday, 6 October 2005 5:19 AM
>To: MySQL-Win32
>Subject: backup
>
>Do you know where could I find info about mysqlbackup script to run it in a
>Win2000 server?
>matías
>
>
>
>
>

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org