This option involves two steps. First you have to
export complete data and then import it again.
You can do this more efficiently by using a sync tool
like Webyog (www.webyog.com). It will sync any two
MySQL databases with changes only done to modified
rows/columns.
YOu can probably mail their
http://dev.mysql.com/doc/mysql/en/replication.html
I would look into the replication features of MySQL. They can be used
to create a backup copy of a database. The slave database server will
only get the changes from the Master as needed.
Karam Chand wrote:
This option involves two steps.
Hello.
Something like:
mysqldump -h 192.168.1.1 -uroot -p -A backup.sql
See:
http://dev.mysql.com/doc/mysql/en/mysqldump.html
Abdul Aziz [EMAIL PROTECTED] wrote:
Dear All,
I wish to backup all databases to my server(192.168.1.1) from my host(192.
168.1.5)
From: David McInnis [EMAIL PROTECTED]
Could you share your script for doing the date thing with the rest of
us? That sounds useful.
Isn't there a perl script around for backuping?
Something like:
mysqldump DB --add-drop-table --opt \
|gzip DBdump.`date +%Y-%m-%d`.gz
should even
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 3:07 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: backup databases
From: David McInnis [EMAIL PROTECTED]
Could you share your script for doing the date thing with the rest of
us? That sounds useful.
Isn't there a perl script
We use mysqldump.
It is fast and easy. restoration is not hard.
If you want more a more percise restoration option, look at using the
change-log. It wil allow you to revert back in time to a state of the DB.
-RG
On Tue, 2 Apr 2002, Kory Wheatley wrote:
Date: Tue, 02 Apr 2002 11:26:58 -0700
I regularly back up all my databases with mysqldump:
mysqldump -uUsername -pPassword --all-databases tmp.sql tar -cf
MySQL-Backup-DATE.tar.gz -z tmp.sql rm -f tmp.sql
I use a script (to determine DATE) in conjunction with cron to back all
databases up nightly, and I also have the script
Could you share your script for doing the date thing with the rest of
us? That sounds useful.
David McInnis
-Original Message-
From: Jonathan Hilgeman [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 02, 2002 10:40 AM
To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED]
Subject: RE: backup
From: David McInnis [EMAIL PROTECTED]
Could you share your script for doing the date thing with the rest of
us? That sounds useful.
From: Jonathan Hilgeman [mailto:[EMAIL PROTECTED]]
mysqldump -uUsername -pPassword --all-databases tmp.sql tar -cf
MySQL-Backup-DATE.tar.gz -z tmp.sql
: RE: backup databases
I regularly back up all my databases with mysqldump:
mysqldump -uUsername -pPassword --all-databases tmp.sql tar -cf
MySQL-Backup-DATE.tar.gz -z tmp.sql rm -f tmp.sql
I use a script (to determine DATE) in conjunction with cron to back all
databases up nightly, and I also
We use mybackup.pl - a perl script found on sourceforge (well, not
anymore I just looked). It creates a compressed tarball of each
database, with a file for each table. The files can be used with the
mysql client without change to rebuild a table. It also can be setup to
rotate the backups
:53:27 -0800
From: David McInnis [EMAIL PROTECTED]
To: 'Jonathan Hilgeman' [EMAIL PROTECTED], [EMAIL PROTECTED],
[EMAIL PROTECTED]
Subject: RE: backup databases
Could you share your script for doing the date thing with the rest of
us? That sounds useful.
David McInnis
-Original
What would the script look like if I'm on Win2k ?
Mark
-Original Message-
From: Rodney Broom [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Tuesday, April 02, 2002 12:22 PM
Subject: Re: backup databases
From: David McInnis [EMAIL PROTECTED]
Could you share your
: Tuesday, April 02, 2002 12:22 PM
Subject: Re: backup databases
From: David McInnis [EMAIL PROTECTED]
Could you share your script for doing the date thing with the rest of
us? That sounds useful.
From: Jonathan Hilgeman [mailto:[EMAIL PROTECTED]]
mysqldump -uUsername -pPassword --all
and get the name (and URL) to you.
-RG
Mark
-Original Message-
From: Rodney Broom [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Tuesday, April 02, 2002 12:22 PM
Subject: Re: backup databases
From: David McInnis [EMAIL PROTECTED]
Could you
Could I run something similar as a BAT file?
-Original Message-
From: Russell E Glaue [EMAIL PROTECTED]
To: Mark Stringham [EMAIL PROTECTED]
Cc: Rodney Broom [EMAIL PROTECTED]; [EMAIL PROTECTED]
[EMAIL PROTECTED]
Date: Tuesday, April 02, 2002 4:25 PM
Subject: Re: backup databases
PROTECTED]
Date: Tuesday, April 02, 2002 4:25 PM
Subject: Re: backup databases
On Tue, 2 Apr 2002, Mark Stringham wrote:
What would the script look like if I'm on Win2k ?
Good luck!!
But seriously; there is a $300 software package out there (can't remember
name) that will give your
similar as a BAT file?
-Original Message-
From: Russell E Glaue [EMAIL PROTECTED]
To: Mark Stringham [EMAIL PROTECTED]
Cc: Rodney Broom [EMAIL PROTECTED]; [EMAIL PROTECTED]
[EMAIL PROTECTED]
Date: Tuesday, April 02, 2002 4:25 PM
Subject: Re: backup databases
On Tue
What would the script look like if I'm on Win2k ?
Good luck!!
Don't listen to the naysayers
@echo off
set zdate=%date%
set zdate=%zdate: =%
set zdate=%zdate:/=-%
C:\mysql\bin\mysqldump -A E:\mysqlDataBackup\%zdate%.txt
save as a .bat and put it in the scheduler. Mine runs every hour.
19 matches
Mail list logo