How to install mysqlbackup?

Asked 29/8, 2015 at 20:36 Answered 16/8, 2016 at 14:7

mysql database-administration mysql-backup

I would like to use mysqlbackup to do incremental backups. However I can't figure out how to install it.

I have mysql-server installed. The documentation (http://dev.mysql.com/doc/mysql-enterprise-backup/3.7/en/mysqlbackup.incremental.html) seems to suggest it should already be installed but it's not. I'm running mysql on ubuntu.

Becki answered 29/8, 2015 at 20:36 Comment(2)

mysqlbackup documentation you already have and i did not implement it yet, but if you want to get full as well incremental backup in mysql then there are other ways also like one is by mysqldump and binary logs combination and another one is by percona utility innobackupexe both I have tested..if you interested then I can share you script/document. – Inerrant 3/9, 2015 at 6:10

I use SQLyog to perform backups of my database. It gives option for taking backup of either the "structure" or both "structure and data" as SQL dump either as a single dump or dump for each table and also "compress" the backup and use timestamp to identify it. – Ostosis 8/9, 2015 at 5:51

Mysqlbackup is part of the MySQL Enterprise Backup:

When using the MySQL Enterprise Backup product, you primarily work with the mysqlbackup command.

Enterprise Backup, on the otherhand, is part of the MySQL Enterprise Edition which is available from Oracle store.

Ryan answered 8/9, 2015 at 5:23 Comment(2)

So basically there's no way to install it without paying quite a bit money? – Becki 9/9, 2015 at 6:17

@pacman, Unfortunately I think you need to pay for it. I haven't seen anything to hint that it'd be available outside of Enterprise Edition. – Ryan 9/9, 2015 at 7:0

sudo apt-get install automysqlbackup

Coworker answered 29/8, 2015 at 20:44 Comment(7)

What version of Ubuntu are you using and what was the output you go when you ran that command? – Coworker 31/8, 2015 at 9:13

I'm running 14.04. There was nothing noteworthy about the output. It just indicated that it succeeded. – Becki 2/9, 2015 at 3:36

@RockScience - not only is it not in my path, but there is also no file anywhere on my computer with that name. – Becki 2/9, 2015 at 3:49

@Becki if it indicated that it was successful install I can indeed assure you that it was installed. Run the command "sudo automysqlbackup" and it should start up. – Coworker 2/9, 2015 at 12:23

@JohnCrawford - yes automysqlbackup is installed. I want mysqlbackup to be installed. – Becki 3/9, 2015 at 6:4

@pacman, Ah I see. Hmm, after doing a quick Google search I don't believe any such program exists. Please send me a link to this actual program or even an article talking about it. For the record, I'd strongly recommend using mysqldump in a script file and set up a cron job to run the script on a daily basis. – Coworker 3/9, 2015 at 7:4

@JohnCrawford - Here is the mysqlback link: dev.mysql.com/doc/mysql-enterprise-backup/3.10/en/… – Becki 3/9, 2015 at 7:9

If you use linux.First u can download the install soft from web. e.g. meb_xxxx.rpm. Then run the command: rpm -ivh meb_xxxx.rpm The MEB will install in the path /opt/mysql/meb_xxxx default. Then u can use the mysqlbackup commande in the ./bin/ directory.

Cathycathyleen answered 16/8, 2016 at 14:7 Comment(0)

-3

You're in luck, someone recently wrote a comprehensive writeup of how to install automysqlbackup on Ubuntu.

https://gist.github.com/janikvonrotz/9488132

They use a different approach to installing it - not using apt-get, but downloading the source and running the install shell script. I hope this works for you, good luck!

Robber answered 8/9, 2015 at 4:41 Comment(0)

Recommended topics

Hot tags