> -----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]

Reply via email to