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
Dear All,
I wish to backup all databases to my server(192.168.1.1) from my host(192.
168.1.5) with (mysqldump),how can we possible,plz tell me command or Script
with brief description.
Thanks in advance
aaziz
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
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
based on date. You can also have the data emailed if
so desired.
http://worldcommunity.com/opensource/
Mike
-Original Message-
From: Kory Wheatley [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 02, 2002 1:27 PM
To: [EMAIL PROTECTED]
Subject: backup databases
What is the best method to
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
L PROTECTED]]
Sent: Tuesday, April 02, 2002 10:27 AM
To: [EMAIL PROTECTED]
Subject: backup databases
What is the best method to backup all your MYSQL DATBASES with not a lot
of down time. I have read about using "mysqlhotcopy" and "mysqldump"
are these the best methods. Also
Sent: Tuesday, April 02, 2002 10:27 AM
To: [EMAIL PROTECTED]
Subject: backup databases
What is the best method to backup all your MYSQL DATBASES with not a lot
of down time. I have read about using "mysqlhotcopy" and "mysqldump"
are these the best methods. Also what proce
700
> From: Kory Wheatley <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: backup databases
>
> What is the best method to backup all your MYSQL DATBASES with not a lot
> of down time. I have read about using "mysqlhotcopy" and "mysqldump"
>
What is the best method to backup all your MYSQL DATBASES with not a lot
of down time. I have read about using "mysqlhotcopy" and "mysqldump"
are these the best methods. Also what procedure is followed in backing
up the databases. I'm basically looking for the must accurate and
reliable way of
22 matches
Mail list logo
