Jeff: Mysqldump don't back up your index, that's your data only.
Osvaldo Sommer -----Mensaje original----- De: Jeff Mckeon [mailto:[EMAIL PROTECTED] Enviado el: Viernes, 30 de Noviembre de 2007 03:24 p.m. Para: 'David Campbell'; mysql@lists.mysql.com Asunto: RE: backup InnoDB db to another server > -----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] -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.503 / Virus Database: 269.16.10/1160 - Release Date: 29/11/2007 08:32 p.m. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
