> -----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 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 DB1 -uroot -ppassword > dump.sql | ssh 10.10.0.2 "cat > > dump.sql" > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED]
The Mysqldump has finished but I've only got a 10gig .sql file. The db is about 65gig in raw size. Does this sound right? Is there a filesize limit for mysqldump .sql files? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]