innobackupex-1.5.1 making a slave from a master.. Restore not working..
iroseland
our database is complicated..
innodb_data_file_path = /xxx/data/mysql/data_files/ibdata1:313322M;/
xxx/data2/mysql/data_files/ibdata2:374738M;/xxx/data3/mysql/data_files/
ibdata3:10M:autoextend
its also, pretty big.
But, we managed to back the mess up, and that looks good..
innobackupex-1.5.1 --apply-log 2011-03-01_13-44-39
ran fine..
but, this fails bad, and makes pretty close to no sense..
[root@b1 2011-03-01_13-44-39]# innobackupex-1.5.1 --copy-back /backup/
2011-03-01_13-44-39/
InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase
Oy.
All Rights Reserved.
This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.
IMPORTANT: Please check that the copy-back run completes successfully.
At the end of a successful copy-back run innobackupex-1.5.1
prints "completed OK!".
innobackupex-1.5.1: Error: Original InnoDB data directory '' does not
exist! at /usr/bin/innobackupex-1.5.1 line 534.
any thoughts, I have been beating my head against this one all day..
iroseland
got further..
but there is a annoying problem..
the restore seems to append the path for
datadir to the front of the path for innodb_data_file_path
since we have a few paths in there, and ...
hmm... I am wondering what I could get away with on moving them around
a bit..
But, the real annoyance is that there does not seem to be a use in
appending that when I am already providing the full path in the
config innodb_data_file_path ..
Ivan
Justin Swanhart
If you have a complex datadir/set of data files, you might not want to
use --copy-back.
Just go ahead and apply the log, then remove xtrabackup_* from the
directory (after the ib_logfile?) files are created.
You can then just copy the files back into your datadir (and to other
locations if appropriate), ensure proper filesystem permissions and
then start mysql.
--Justin
> --
> You received this message because you are subscribed to the Google Groups "Percona Discussion" group.
> To post to this group, send email to percona-d...@googlegroups.com.
> To unsubscribe from this group, send email to percona-discuss...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/percona-discussion?hl=en.
>
>
--
Justin Swanhart, Principal Consultant, Percona Inc.
Bay Area, USA (PDT, GMT -7)
+1 888 401 3401 | 24x7 Help x911
Our Services:
http://www.percona.com/services/
We also offer training!
Percona offers regularly scheduled public training events and private
on-site training too.
http://www.percona.com/training/