mysql

[Jai Rangi]

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. 

-Jai



-----Original Message-----
From: redhat-list-bounces at redhat.com
[mailto:redhat-list-bounces at redhat.com] 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>


chaim.rieger at gmail.com 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" <madunix at gmail.com>
> 
> Date: Thu, 4 Sep 2008 09:29:31 
> To: General Red Hat Linux discussion list<redhat-list at redhat.com>
> Subject: Re: mysql
> 
> 
> However, am thinking to do this script and run it on the colrintab
> 
> mysqlhotcopy --allowold --flushlog -u <username>
--password=<password>
> <dbname> /var/backups/mysql/
> 
> or
> 
> /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....
> 
> Thanks
> 
> 
> On Wed, Sep 3, 2008 at 2:43 PM, mark <m.roth2006 at rcn.com> wrote:
> 
>> Mad Unix wrote:
>>> I need a script to take Multiple MySql DataBase Backup export Script
for
>>> 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?
>>
>>        mark
>>
>> --
>> redhat-list mailing list
>> unsubscribe mailto:redhat-list-request at redhat.com?subject=unsubscribe
>> https://www.redhat.com/mailman/listinfo/redhat-list
>>
> 
> 
>