> -----Original Message----- > From: Osvaldo Sommer [mailto:[EMAIL PROTECTED] > Sent: Saturday, December 01, 2007 8:23 AM > To: 'Jeff Mckeon'; 'David Campbell'; mysql@lists.mysql.com > Subject: RE: backup InnoDB db to another server > > Jeff: > > Mysqldump don't back up your index, that's your data only. > > Osvaldo Sommer >
Actually I think it's more than that. We have cleaning scripts put place to delete records older than 3 months from certain tables. I think the users have been running these without optimizing the tables afterwards and therefore never reclaiming the space the created with the deletes. These "tablename_Old" tables were huge. On the main systems I did a mysqldump of just these tables, then dropped the originals from the db and restored them. The entire db size went from 65G to 20G. The database was already screwed up and I have another master running for our applications so there was no risk if I screwed something up. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
