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. Firs
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 su
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.
> 1
Now I've read all the posts about database backup..
I'm currently building a www-site (an internet bookstore which is going to
be fairly large, one of the biggest in my country. This has been a pet
project for me for the last 8 months, otherwise I would have to watch the
company board waste loads
print "\n";
print "\n";
print "\n";
$output->done;
-Original Message-
From: Eberhard W Lisse [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 3:07 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTE
> 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
shoul
>> 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 hou
TECTED]>; [EMAIL PROTECTED]
> > <[EMAIL PROTECTED]>
> > Date: Tuesday, April 02, 2002 4:25 PM
> > Subject: Re: backup databases
> >
> >
> > >
> > >On Tue, 2 Apr 2002, Mark Stringham wrote:
> > >>
> > >> What would the
Broom <[EMAIL PROTECTED]>; [EMAIL PROTECTED]
> <[EMAIL 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
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
Subje
If your interested in knowing what this software package is, e-mail me and
> I'll look and get the name (and URL) to you.
> -RG
>
>
> >
> > Mark
> > -Original Message-
> > From: Rodney Broom <[EMAIL PROTECTED]>
> > To: [EMAIL PROTECTED] &
ED]>
> 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 script for doing the date thing with the
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
02, David McInnis wrote:
> Date: Tue, 2 Apr 2002 10: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
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 base
ay, April 02, 2002 10:53 AM
To: 'Jonathan Hilgeman'; [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 Message-
From: Jonathan Hilgeman
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
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:
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
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
>
20 matches
Mail list logo
