Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Zmanda increment backup

Posted on 2014-04-09
6
Medium Priority
?
401 Views
Last Modified: 2014-04-14
Hi Expert,

How to take mysql incremental backup in zmanda community edition.

I've configure mysql-crm.conf:
backup-level=1
backup-mode=logical
retention-policy=10D
compress=1
databases="MySql"
username="root"
password="**********"

Thanks & Regards,
Xerox
0
Comment
Question by:xeroxzerox
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 13

Accepted Solution

by:
Sandy earned 1500 total points
ID: 39990981
You can refer below link for Zamanda Backup for SQL.

http://www.howtoforge.com/point_in_time_restoration_mysql_zrm

TY/SA
0
 
LVL 6

Author Comment

by:xeroxzerox
ID: 39993357
Hi,
i've run this command manually
#mysql-zrm-scheduler --now --backup-set backup --backup-level 1

But i've got some error like:
src = /var/lib/mysql/log-bin.000001
k = /var/lib/mysql-zrm/backup/20140411100948/log-bin.000001
cp: cannot stat `/var/lib/mysql/log-bin.000001': No such file or directory
backup:backup:ERROR: Copy from /var/lib/mysql/log-bin.000001 to /var/lib/mysql-zrm/backup/20140411100948 failed
backup:backup:ERROR: Could not copy bin log file /var/lib/mysql-zrm/backup/20140411100948/log-bin.000001

backup-status=Backup done but with errors

what can i do in this situation.

Thanks & Regards,
xerox
0
 
LVL 13

Expert Comment

by:Sandy
ID: 39994017
Change the src parameter as per your file location.

TY/SA
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
LVL 6

Author Comment

by:xeroxzerox
ID: 39994742
i'm unable to understand..Can you please explain me briefly..
where i shall be change src parameters

thanks..
0
 
LVL 13

Expert Comment

by:Sandy
ID: 39994763
src = /var/lib/mysql/log-bin.000001
k = /var/lib/mysql-zrm/backup/20140411100948/log-bin.000001
cp: cannot stat `/var/lib/mysql/log-bin.000001': No such file or directory
backup:backup:ERROR: Copy from /var/lib/mysql/log-bin.000001 to /var
0
 
LVL 6

Author Closing Comment

by:xeroxzerox
ID: 40000804
issue in sql log...i've change the path in my.cnf file in sql and issue resolved.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you have a server on collocation with the super-fast CPU, that doesn't mean that you get it running at full power. Here is a preamble. When doing inventory of Linux servers, that I'm administering, I've found that some of them are running on l…
Google Drive is extremely cheap offsite storage, and it's even possible to get extra storage for free for two years.  You can use the free account 15GB, and if you have an Android device..when you install Google Drive for the first time it will give…
Learn how to find files with the shell using the find and locate commands. Use locate to find a needle in a haystack.: With locate, check if the file still exists.: Use find to get the actual location of the file.:
Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…
Suggested Courses

610 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question