I'm hoping someone on the list has some experience with the tool (specifically, restoring a backup), as I'm stumped.
First, "--apply-log" seems to only work on the host that ibbackup is lode-locked to. This doesn't make sense. Running the tool dumpes out some text, and part of that text is, "(--restore works in any computer regardless of the hostname)" The manual says, "Therefore, the option --apply-log was added as a synonym for --restore in the version 1.40 of ibbackup, and the option name --restore will become deprecated." So "restore" == "apply-log", but one works on any computer, and the other only works on the computer that it's node locked to. Am I missing something obvious? And what happens after version 1.4? No one is able to apply the binary log file if they need to test the backup on a different server? Second, the manual has a bunch of inconsistencies w/regards to the "my.cnf" file you are supposed to use to apply the log. Section 3 says, We run ibbackup to roll forward the data files so that they correspond to the same log sequence number: $ ibbackup --apply-log /home/pekka/.backup-my.cnf Note the usage of the backup-my.cnf file; this is the file that ibbackup uses to figure out how to actually perform the backup, as opposed to the my.cnf file that is used to actually configure the MySQL server. but Section 5.3 says, "innobackup --apply-log /home/pekka/.my.cnf /home/pekka/script/backups/2004-02-03_13-27-09" Notice that the my.cnf file appears to be the normal config file for mysqld (farther down the page, you find out that the file is infact a copy of the my.cnf file). There is the backup-my.cnf file in the directory with the data files, and it's not used. The above line uses the PERL interface, and thus the ibbackup->innobackup. Which .cnf file is supposed to be used? The Server config file (my.cnf) or the ibbackup config file (you can name it whatever you want)? Note that both seem to do exactly the same thing; I guess the issue here is more clarity than anything else. Finally, When I run --restore (apply-log doesn't work, remember?) I get, 040512 21:38:12 ibbackup: ibbackup_logfile's creation parameters: ibbackup: start lsn 5 1804179456, end lsn 5 1804179476, ibbackup: start checkpoint 5 1804179476 ibbackup: Error: backed up log file segment has a wrong magic n:o 542632761. ibbackup: Run 'ibbackup --help' for help. There is no troubleshooting section in the manual to explain the error, and ibbackup --help - it's focus is on the backup, not the restore. Googling on the message returns no pages. Unfort, support for the tool costs much more than the tool itself, and is basically 10 emails a year. Can anyone provide some insight? The whole apply-log thing is confusing - should it be done immediately after a backup? Or is it only done if you need to use the backup? Thx, David -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
