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]