7 messages in com.mysql.lists.win32RE: backup| From | Sent On | Attachments |
|---|---|---|
| Matías Castilla | 05 Oct 2005 12:48 | |
| Jorge Bastos | 05 Oct 2005 14:01 | |
| Matías Castilla | 05 Oct 2005 14:05 | |
| jbon...@sola.com.au | 05 Oct 2005 16:45 | |
| Marcel Forget | 05 Oct 2005 17:13 | |
| Jason Dimberg | 06 Oct 2005 21:16 | |
| Matías Castilla | 07 Oct 2005 08:15 |
| Subject: | RE: backup |
|---|---|
| From: | jbon...@sola.com.au (jbon...@sola.com.au) |
| Date: | 10/05/2005 04:45:25 PM |
| List: | com.mysql.lists.win32 |
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<host> --opt -u<user> -p<password> -P3306 -rpedump.sql <database>
/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<host> --opt -u<user> -p<password> -P3306 -rpedump.sql
<database>
Pkzip just makes the dump file much smaller so that I can keep several backups.
John B.
-----Original Message----- From: Matías Castilla [mailto:mati...@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