GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

backup error when I use another server

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • backup error when I use another server

    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/...ng-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

  • #2
    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/per...1039422#stream

    Comment


    • #3
      I was also wondering if I can use this with my other hosting.​
      Last edited by scott.nemes; 07-14-2014, 12:42 PM. Reason: Removed spam links

      Comment

      Working...
      X