Members   Search   Help    Register    Login   Home

Show: Today's Messages  :: Show Polls :: Message Navigator

InnoDB Backup [message #1427] Fri, 15 June 2007 09:56  adamb Messages: 5 Registered: June 2007 Junior Member All - I have a very large database, containing hundreds of millions of records across multiple tables in multiple databases. The DB is setup for a master/slave replication, but I would like to start doing a full weekly dump to a DVDRom or tape backup...whatever. With MyIasm tables I can just copy the binary files, but this is not the case with InnoDB, which is what I am using. the mysqldump takes forever and a day to complete, and produces an extremely large text file, I was looking for some other way, that is a. quicker, b. smaller dump files. Is this possible? Can someone recommend a method? Thanks, Adam. Report message to a moderator

	InnoDB Backup By: adamb on Fri, 15 June 2007 09:56
	Re: InnoDB Backup By: sterin on Fri, 15 June 2007 17:45
	Re: InnoDB Backup By: adamb on Mon, 18 June 2007 13:57
	Re: InnoDB Backup By: razdaman on Mon, 25 June 2007 06:16
	Re: InnoDB Backup By: adamb on Mon, 25 June 2007 08:00
	Re: InnoDB Backup By: sterin on Mon, 25 June 2007 17:19
	Re: InnoDB Backup By: adamb on Mon, 25 June 2007 17:22
	Re: InnoDB Backup By: sterin on Tue, 26 June 2007 03:30
	Re: InnoDB Backup By: adamb on Tue, 26 June 2007 08:04

Previous Topic:	PRIMARY KEY or FOREIGN KEY?
Next Topic:	char based partitioning

Goto Forum:

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [ ]