Not the answer you need?
Register and ask your own question!

backup error when I use another server

chenmingchenming EntrantCurrent User Role Beginner
hi guys:
I was using the innobackupex in the server which is mysql-server installed ,it is all ok.
the command is :innobackupex -host 127.0.0.1 -port 3306 --user=root --password=xxxxxx /tmp/backupmysql

but when I run this command in another server,it went wrong.
the command is:innobackupex -host 172.16.17.5 -port 3306 --user=root --password=xxxxxx /tmp/backupmysql

and the screen output is:
xtrabackup version 2.0.8 for Percona Server 5.1.59 unknown-linux-gnu (x86_64) (revision id: 587)
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /var/lib/mysql
xtrabackup: Target instance is assumed as followings.
xtrabackup: innodb_data_home_dir = ./
xtrabackup: innodb_data_file_path = ibdata1:10M:autoextend
xtrabackup: innodb_log_group_home_dir = ./
xtrabackup: innodb_log_files_in_group = 2
xtrabackup: innodb_log_file_size = 5242880
InnoDB: No valid checkpoint found.
InnoDB: If this error appears when you are creating an InnoDB database,
InnoDB: the problem may be that during an earlier attempt you managed
InnoDB: to create the InnoDB data files, but log file creation failed.
InnoDB: If that is the case, please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/error-creating-innodb.html
innobackupex: Error: ibbackup child process has died at /usr/bin/innobackupex line 386.

I think the problem is not with innodb ,because it runs well in the mysql-server

my os version is CentOS release 6.5 (Final)
mysql-server version is :/usr/libexec/mysqld Ver 5.1.73 for redhat-linux-gnu on x86_64 (Source distribution)
xtrabackup version 2.0.8 for Percona Server 5.1.59 unknown-linux-gnu (x86_64) (revision id: 587)

any idea? thank you

Comments

  • psongpsong Contributor Inactive User Role Beginner
    Chenming,

    With Percona Xtrabackup, you can stream the backup to another server, but you can't backup a remote server. The innobackupex and/or xtrabackup need to be invoked on the server to be backed up. The program reads the configuration file /etc/my.cnf or --defaults-file if specified to get server options, like datadir etc. And the program copies the database files to a backup directory that you specify or to a stream.

    You can read the Howto here to see examples of how to stream to a remote server:
    http://www.percona.com/docs/wiki/percona-xtrabackup:xtrabackup_howto?rev=1271039422#stream
  • mariashinamariashina Entrant Inactive User Role Beginner
    I was also wondering if I can use this with my other hosting.​
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.