> -----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]> 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 -ppassword | mysql --compress -h 10.10.0.1 - > uroot > > -ppassword DB1 > /DATA/DB1backup.sql > > > > I see a /DATA/DB1backup.sql file created on the source server with 0 > size, > > but nothing on the destination server. > > > > What am I screwing up here? > > Your command is actually telling mysql on 10.01.0.1 to execute the > dumped output. It is doing so without creating any ouput, but the > > is creating an output file anyway. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED]
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? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]