# innobackupex

**URL:** <https://forums.percona.com/t/innobackupex/2302>\
**Category:** Percona XtraBackup\
**Created:** [October 15, 2012, 10:27am UTC](https://forums.percona.com/t/innobackupex/2302 "2012-10-15T10:27:32Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![gozigomilis](https://avatars.discourse-cdn.com/v4/letter/g/848f3c/32.png) [@gozigomilis](https://forums.percona.com/u/gozigomilis)\
**Post date:** [October 15, 2012, 10:27am UTC](https://forums.percona.com/t/innobackupex/2302/1 "2012-10-15T10:27:32Z")

</div>

Dear all,

I have server A and B .  
server A I install “Percona-Server 55-5.5.27”.

I want to full backup database on server B (/var/lib/mysql) with command this below

/usr/bin/innobackupex --parallel=4 --host=${IP\_SERVER\_B} --user=dbuser–password=dbpassword–no-timestamp /home/percona/innobackup/2012-10-15

After full backup is finish, I check dir “/home/percona/innobackup/2012-10-15” is not backup dir /var/lib/mysql on server B. But it’s backup /var/lib/mysql on server A.

why this could happen, but I’ve replaced --host=${IP\_SERVER\_B} by ip address server B

Thank You

Moses

---

<div class="post-metadata">

**Author:** ![niljoshi](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/niljoshi/32/16889_2.png) [@niljoshi](https://forums.percona.com/u/niljoshi)\
**Post date:** [October 16, 2012, 1:43am UTC](https://forums.percona.com/t/innobackupex/2302/2 "2012-10-16T01:43:42Z")

</div>

Hi Moses,

What you are trying to do, won’t work with --host option. For your purpose, I guess you should use streaming backup. As per your scenario, if you want to take backup of B server and transfer it to A server, you should run backup command on B server with --stream/xbstream option to transfer it to A server. (rather then running backup on A server)

You can get more information here.  
[http://www.percona.com/doc/percona-xtrabackup/howtos/recipes](http://www.percona.com/doc/percona-xtrabackup/howtos/recipes) \_ibkx\_stream.html

---

<div class="post-metadata">

**Author:** ![gozigomilis](https://avatars.discourse-cdn.com/v4/letter/g/848f3c/32.png) [@gozigomilis](https://forums.percona.com/u/gozigomilis)\
**Post date:** [October 17, 2012, 11:10am UTC](https://forums.percona.com/t/innobackupex/2302/3 "2012-10-17T11:10:58Z")

</div>

Hi niljoshi,

IP SERVER A : 192.168.0.121

IP SERVER B : 192.168.0.140

I Run command on server B

[root@alfamart ~]# innobackupex --host=localhost --user=myuser --password=mypassword --stream=tar ./ | ssh -q [root&#64;192.168.0.121](mailto:root&#64;192.168.0.121) “cat - \> /tmp/test/backup.tar”

My Questios is :

1. Whether during the backup process will use temporary storage on server B?
2. If i check ,the command above is full backup. if the above command already include function “apply-log”?

Thank You

---

<div class="post-metadata">

**Author:** ![gozigomilis](https://avatars.discourse-cdn.com/v4/letter/g/848f3c/32.png) [@gozigomilis](https://forums.percona.com/u/gozigomilis)\
**Post date:** [March 24, 2013, 2:46pm UTC](https://forums.percona.com/t/innobackupex/2302/4 "2013-03-24T14:46:51Z")

</div>

Dear Team Percona,

I try to install percona on centos 6.3 (64 bit)

[root@wom-moses mysql]# rpm -aq | grep Percona-\*  
Percona-Server-server-55-5.5.30-rel30.1.465.rhel6.x86\_64  
Percona-Server-client-55-5.5.30-rel30.1.465.rhel6.x86\_64  
Percona-Server-shared-compat-5.5.30-rel30.1.465.rhel6.x86\_64  
Percona-Server-devel-55-5.5.30-rel30.1.465.rhel6.x86\_64  
Percona-Server-shared-55-5.5.30-rel30.1.465.rhel6.x86\_64  
Percona-Server-test-55-5.5.30-rel30.1.465.rhel6.x86\_64

I didn’t find default configuration on /etc/my.cnf but after i start service mysql can running well

[root@wom-moses mysql]# /etc/init.d/mysql start  
Starting MySQL (Percona Server)… SUCCESS!

I try to generate conguration my.cnf using wizard and copy to dir /etc/my.cnf. After i restart the service mysql, i found error like this bellow

[root@wom-moses mysql]# /etc/init.d/mysql start  
Starting MySQL (Percona Server)… ERROR! The server quit without updating PID file (/var/lib/mysql/wom-moses.pid).

How to solve this problem?

I put my.cnf on attachment generate from wizard web percona.  
Thanks
