Find Jobs
Hire Freelancers

Remote backup of Mysql and files on ubuntu server

$250-750 USD

In Progress
Posted over 11 years ago

$250-750 USD

Paid on delivery
I want to have all the mango files which are in /ma backed up to a remote server and also have a mysql database backed up. Mango collects data from sensors and devices and stores it in a derby or mysql database. I’d like to be able to back up the derby database but I don’t know if it is possible because derby can only handle one connection at a time and we can’ t not shut down the other connections to do the backups. For this reason I will probably stick with Mysql unless you have a solution for derby. So I want to backup the mysql database to a remote backup service like [login to view URL] or maybe something else. The main thing is that the DB backup needs to be incremental so that we don’t end up doing large data transfers every day. The database could get to be over 1 gigabyte so it has to be incremental. The other important part is that I want to have some kind of notification if a backup fails and/or a log of when backups happen. This would be deployed on the Mango / Ubuntu server that will be plugged into our VPN routers so not sure if the traffic will go through the vpn or not. Let me know if this is something you can help with.
Project ID: 3981479

About the project

20 proposals
Remote project
Active 11 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hello we will use the mysql script or webbased gui to create mysql incremental dumps and will be using rsync to sync the data of mango server and mysql to the server a cron job will be set to carry out the tasks and we will have email notifications about the process log Thanks Sana
$340 USD in 14 days
4.8 (11 reviews)
4.9
4.9
20 freelancers are bidding on average $361 USD for this job
User Avatar
Hi, If the database is highly used and has a lot of changes you won't be able to have incremental backups. The best way of backups would be to use mysql replication. I can set up a mysql master/slave setup as well as a script that will perform daily dumps of the databases. Please let me know if you are interested Thanks
$250 USD in 3 days
5.0 (384 reviews)
6.9
6.9
User Avatar
please check PM for details
$400 USD in 2 days
5.0 (81 reviews)
6.8
6.8
User Avatar
lets complete this project
$250 USD in 1 day
4.9 (142 reviews)
6.6
6.6
User Avatar
hi, please check my proposal in the private message.
$450 USD in 3 days
4.9 (5 reviews)
6.5
6.5
User Avatar
Thanks for inviting us to bid on this project. We have a team of highly qualified and creative professionals. Give us a chance to show our talents and we assure you quality.
$300 USD in 2 days
4.5 (22 reviews)
6.4
6.4
User Avatar
Joel, Inquiry through PM (There's a few things we'll need to know in order to proceed.)
$500 USD in 14 days
5.0 (34 reviews)
5.7
5.7
User Avatar
ready when you are - Check reviews
$350 USD in 2 days
4.9 (11 reviews)
5.7
5.7
User Avatar
I can help you with this
$250 USD in 1 day
4.9 (33 reviews)
4.7
4.7
User Avatar
For sure I can help you to find out best solution that will fit your needs. There are many ways to achieve your goals, I'll send you more information privately so we could think about optimal.
$750 USD in 4 days
5.0 (12 reviews)
4.3
4.3
User Avatar
i'm ready to help you with mysql and apache derby backup, more information if needed on pmb.
$300 USD in 3 days
5.0 (5 reviews)
4.0
4.0
User Avatar
I'm ready....
$250 USD in 3 days
4.7 (7 reviews)
3.8
3.8
User Avatar
we can get this for you..!
$300 USD in 5 days
4.8 (11 reviews)
3.7
3.7
User Avatar
As izghitu said incremental backups are best done with MySQL replication. But you can do full backups too, 1GB of data is not much. The files can be backed up incrementally with rsync or dump. The notification can be by email with the output from the cron job, that's trivial to set up.
$250 USD in 3 days
5.0 (2 reviews)
3.6
3.6
User Avatar
Name: Gritsenko Stanislav About Me: I am a 4+ years experienced linux server administrator. I am now looking forward to get a reputable full time technical support position, or a part-time server setup and security expert position. Education: Degree in Computer Science and Engineering with first class. Bachelor Of Computer Application & Master in network protocol design from PDTU, Mariupol,Ukraine. Expertise and Skills: Expert in cPanel servers, Familiar with Plesk, Enzim and servers without control panels. * Excellent knowledge for load balancing & clusters setup. * Experienced with ESX(i) Environment. * Passionate about advanced linux IP firewalling and security. More Information: I have attached my CV with this email. So please check & consider. Thanks Gritsenko Stanislav
$250 USD in 1 day
4.8 (7 reviews)
3.5
3.5
User Avatar
Hello i can do it easily.
$250 USD in 1 day
4.9 (2 reviews)
2.3
2.3
User Avatar
I have implemented a very similar project with you's. I used the rsync to accomplish the incremental backup and dally snapshot. Hope I can help you to complete your task.
$250 USD in 2 days
5.0 (1 review)
1.9
1.9
User Avatar
Hi, I can help you. Please check my PM
$350 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
We would be able to help you with this job. Please view PMB for details.
$600 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, please go through the PM.
$300 USD in 2 days
0.0 (0 reviews)
1.8
1.8
User Avatar
Custom software development: w w w . The Administrator removed this message for containing contact details which breaches our Terms of Service . i o
$750 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Lafayette, United States
5.0
17
Payment method verified
Member since Aug 17, 2008

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.