I would not do that,
1. Your tables are locked during mysqldump, So if the table size if too
big then you are without DB at the time of dump on primary.
2. I guess you will be (have to if the table structure change) deleting
all the tables on the secondary server and then copying the data to the
tables which again takes a while depending on the size of the tables.
Say you setup cron every five minutes then your systems are not in real
time sync after every 5 minutes, in fact they are never in sync, which
might not be a big deal for you.
Only way to go for this is Setup replication, which takes hardly 30
minutes to do. If you can't do it then pay me $150 I will do it for you
;) Just joking.
From: [email protected]
[mailto:[email protected]] On Behalf Of Ryan Golhar
Sent: Thursday, September 04, 2008 8:13 AM
To: General Red Hat Linux discussion list
Subject: Re: mysql
# dump the database
mysqldump -u root --password=<password> --databases <list of databases
to backup> | gzip > /root/backup/mysql.sql.gz
# copy the gzip file elsewhere
scp /root/backup/mysql.sql.gz <new location>
[email protected] wrote:
> I've used dump and still do on a regular basis. Never failed me yet
> Sent via BlackBerry from T-Mobile
> -----Original Message-----
> From: "Mad Unix" <[email protected]>
> Date: Thu, 4 Sep 2008 09:29:31
> To: General Red Hat Linux discussion list<[email protected]>
> Subject: Re: mysql
> However, am thinking to do this script and run it on the colrintab
> mysqlhotcopy --allowold --flushlog -u <username>
> <dbname> /var/backups/mysql/
> /usr/bin/mysqldump -u#### -p#### --all-databases -a >
> /var/backups/mysql/$(date +%Y%m%d).sql
> tar cf - /var/backups/mysql/$(date +%Y%m%d).sql | gzip -c >
> /misc/backups/MySQL/$(date +%Y%m%d).tar.gz
> Any input about the above....
> On Wed, Sep 3, 2008 at 2:43 PM, mark <[email protected]> wrote:
>> Mad Unix wrote:
>>> I need a script to take Multiple MySql DataBase Backup export Script
>>> Linux then import them to other server
>>> to make them symmetric !
>> export's a std. feature. The real question is hot or cold b/u?
>> redhat-list mailing list
>> unsubscribe mailto:[email protected]?subject=unsubscribe
redhat-list mailing list
unsubscribe mailto:[email protected]?subject=unsubscribe