10

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.

pacman
  • 2,050
  • 4
  • 16
  • 17
  • 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. – Zafar Malik Sep 03 '15 at 06:10
  • 1
    I use [SQLyog](https://www.webyog.com/product/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. – Mathew Sep 08 '15 at 05:51

4 Answers4

2

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.

vhu
  • 12,244
  • 11
  • 38
  • 48
  • So basically there's no way to install it without paying quite a bit money? – pacman Sep 09 '15 at 06: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. – vhu Sep 09 '15 at 07:00
0
sudo apt-get install automysqlbackup
John Crawford
  • 9,656
  • 9
  • 31
  • 42
  • What version of Ubuntu are you using and what was the output you go when you ran that command? – John Crawford Aug 31 '15 at 09:13
  • I'm running 14.04. There was nothing noteworthy about the output. It just indicated that it succeeded. – pacman Sep 02 '15 at 03:36
  • @RockScience - not only is it not in my path, but there is also no file anywhere on my computer with that name. – pacman Sep 02 '15 at 03:49
  • @pacman 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. – John Crawford Sep 02 '15 at 12:23
  • 2
    @JohnCrawford - yes automysqlbackup is installed. I want mysqlbackup to be installed. – pacman Sep 03 '15 at 06:04
  • @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. – John Crawford Sep 03 '15 at 07:04
  • @JohnCrawford - Here is the mysqlback link: http://dev.mysql.com/doc/mysql-enterprise-backup/3.10/en/mysqlbackup.html – pacman Sep 03 '15 at 07:09
0

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.

rgi
  • 69
  • 1
  • 3
-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!

Mark Madej
  • 1,752
  • 1
  • 14
  • 19