Xtrabackup tries to replace existing MySQL server

We need to use the innobackupex.sh on our FreeBSD 8.2 server to backup our MySQL databases. Apparently, we need to install Xtrabackup from ports. But I noticed that xtrabackup port tries to install a fresh mysql-5.1.59 on our production server, which already has a functional MySQL server 5.1.57 on it. This is not something we'll prefer as the system hosts e-commerce sites, etc. Isn't there any way to have innobackupex.sh script on the system and use it without installaing Xtrabackup? Or do we have to uninstall our existing MySQL server and let Xtrabackup bring its mysql-server version as it desires?
LVL 1
sbayrakAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

johanntagleCommented:
Maybe you can just use the binaries instead?  See

http://www.percona.com/downloads/XtraBackup/LATEST/binary/Linux/
0
sbayrakAuthor Commented:
innobackupex binary can be started by an innobackupex.sh as expected but it requires xtrabackup built and installed on the system in one way or another. When you call innobackupex, it complains about the executable format of the xtrabackup binary if you just placed it in /usr/local/bin.

By the way, if this would be the solution, v2.0.8 binaries should fit MySQL 5.1.x, but it didn't work. I decided to go with mysqldump --single-transaction.

Thank you anyway.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
johanntagleCommented:
Ah forgot that you are on 5.1.x.  you need an older version of xtrabackup since the more recent ones only support 5.5.x.
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

skullnobrainsCommented:
your mysql instance is probably installed manually without using ports or packages

if ou compile xtrabackup from ports, and your mysql installed it's commands and libs in a regular path, the make script should detect it and not attempt to install another version. if it does, then you need to provide the mysql libs location at compile time

not after points, you can close this question however you see fit, but i guess this should help. if not, feel free to post
0
sbayrakAuthor Commented:
MySQL was installed through FreeBSD ports. In fact, there is nothing installed manually on the server.
0
skullnobrainsCommented:
then i guess it may actually complain that a wrong version of mysql is installed and refuse to install rather than add an extra-version. since mysql is a versioned package, this may not be the case. you can specify mysql_version in your make.conf so ports will always try to install that specific one. same applies to other packages with numbers in the end such as apache and openldap.

if you want to prevent (or at least limit) this kind of things from happening, you probaby should not upgrade the port tree unless you upgrade all the installed packages at the same time. personally, i usually script installs, and perform update by deleting all packages and the ports tree and running the install scripts again.
0
sbayrakAuthor Commented:
I couldn't find a way to make it work with a fresh Xtrabackup installation that wasn't trying to update the existing MySQL pkg. I decided mysqldump --single-transaction as a soltion, because at the end the final purpose is to backup InnoDB tables without locking the database.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Unix OS

From novice to tech pro — start learning today.