RE: backup InnoDB db to another server

2007-11-30 Thread Jeff Mckeon
> -Original Message- > From: David Campbell [mailto:[EMAIL PROTECTED] > Sent: Friday, November 30, 2007 11:29 AM > To: mysql@lists.mysql.com > Subject: Re: backup InnoDB db to another server > > Jørn Dahl-Stamnes wrote: > > On Friday 30 November 2007 17:12, Jeff Mckeon wrote: > >> Ok, so w

Re: multiple instances on same server

2007-11-30 Thread Atle Veka
I've found that if you take your time properly configuring, that mysqld_multi works great with managing multiple instances. There is supposedly a new way that has replaced mysqld_multi, however I am not familiar with it. Our most common use of running 2 or more instances on the same server is

multiple instances on same server

2007-11-30 Thread Sid Lane
this is more of a best practices question than a techical one but when/why has anyone run multiple mysql instances on the same server in production? I have a ring replicated pair of mysql servers with ~12 logical databases, each associated with a different application/set of functionality on our s

RE: Update Join with Aliases

2007-11-30 Thread Jerry Schwartz
You are joining ambien_nev.Sections to itself, but the join condition natural_db.Sections.section_id = ambien_nev.Sections.section_id references a data base that isn't in the join. I think that might be the problem. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmi

Update Join with Aliases

2007-11-30 Thread Elissa Joan
Hello. I am having a time trying to get this to work. I hope someone can help me wit the syntax! Here is the original query: UPDATE ambien_nev.Sections INNER JOIN ambien_nev.Sections ON natural_db.Sections.section_id = ambien_nev.Sections.section_id SET ambien_nev.Sections.feature1 = natu

Re: backup InnoDB db to another server

2007-11-30 Thread David Campbell
Jørn Dahl-Stamnes wrote: On Friday 30 November 2007 17:12, Jeff Mckeon wrote: Ok, so what would be the command to get a mysqldump of DB1 from 10.10.0.1 into file DB1backup.sql on 10.10.0.2? What about running mysqldump on 10.10.0.2? or scp dump.sql [EMAIL PROTECTED]:. Onliner mysqldump

RE: backup InnoDB db to another server

2007-11-30 Thread Jeff Mckeon
> -Original Message- > From: Jørn Dahl-Stamnes [mailto:[EMAIL PROTECTED] > Sent: Friday, November 30, 2007 11:16 AM > To: mysql@lists.mysql.com > Subject: Re: backup InnoDB db to another server > > On Friday 30 November 2007 17:12, Jeff Mckeon wrote: > > Ok, so what would be the command to

Re: backup InnoDB db to another server

2007-11-30 Thread Jørn Dahl-Stamnes
On Friday 30 November 2007 17:12, Jeff Mckeon wrote: > Ok, so what would be the command to get a mysqldump of DB1 from 10.10.0.1 > into file DB1backup.sql on 10.10.0.2? What about running mysqldump on 10.10.0.2? or mysqldump DB1 -uroot -ppassword > dump.sql scp dump.sql [EMAIL PROTECTED]:. --

RE: backup InnoDB db to another server

2007-11-30 Thread Jeff Mckeon
> -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Baron Schwartz > Sent: Friday, November 30, 2007 11:06 AM > To: Jeff Mckeon > Cc: mysql list > Subject: Re: backup InnoDB db to another server > > On Nov 30, 2007 10:55 AM, Jeff Mckeon <[EMAIL PROTECTED

Re: backup InnoDB db to another server

2007-11-30 Thread Baron Schwartz
On Nov 30, 2007 10:55 AM, Jeff Mckeon <[EMAIL PROTECTED]> wrote: > I'm trying to use mysqldump to backup an innoDB based db from one server to > an sql file on another. It doesn't seem to be working however... > > Here is the command I'm using on the source server > > mysqldump DB1 -uroot -ppasswo

backup InnoDB db to another server

2007-11-30 Thread Jeff Mckeon
I'm trying to use mysqldump to backup an innoDB based db from one server to an sql file on another. It doesn't seem to be working however... Here is the command I'm using on the source server mysqldump DB1 -uroot -ppassword | mysql --compress -h 10.10.0.1 -uroot -ppassword DB1 > /DATA/DB1backup.