In Progress

Remote backup of Mysql and files on ubuntu server

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 [url removed, login to view] 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.

Skills: Linux, MySQL

See more: ubuntu rsync mysql database, backup files ubuntu server, vpn service linux, ubuntu service, data sensors, mysql data files, vpn service, Ubuntu, ubuntu server, remote server, remote help, mysql backup, log files, backup database, remote connection, linux vpn solution, mysql remote connection, remote connection linux, mysql database notification, ubuntu rsync, linux connections, linux mysql backup, connection mysql, ubuntu linux server, database connection mysql

About the Employer:
( 17 reviews ) Lafayette, United States

Project ID: #3981479

Awarded to:


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 More

$340 USD in 14 days
(11 Reviews)

20 freelancers are bidding on average $361 for this job


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 More

$250 USD in 3 days
(384 Reviews)

please check PM for details

$400 USD in 2 days
(81 Reviews)

lets complete this project

$250 USD in 1 day
(142 Reviews)

hi, please check my proposal in the private message.

$450 USD in 3 days
(5 Reviews)

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
(22 Reviews)

Hi I am a CISSP,RHCE,CCNA,MCSA,Linux+ and a CEH. I do have 7+ years experience in System Administration . I have experience in a high availability environment with 100+ servers and more than 500 000+ subscribers, I kno More

$280 USD in 4 days
(58 Reviews)

Joel, Inquiry through PM (There's a few things we'll need to know in order to proceed.)

$500 USD in 14 days
(34 Reviews)

ready when you are - Check reviews

$350 USD in 2 days
(11 Reviews)

I can help you with this

$250 USD in 1 day
(33 Reviews)

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
(12 Reviews)

i'm ready to help you with mysql and apache derby backup, more information if needed on pmb.

$300 USD in 3 days
(5 Reviews)

I'm ready....

$250 USD in 3 days
(7 Reviews)

we can get this for you..!

$300 USD in 5 days
(11 Reviews)

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 b More

$250 USD in 3 days
(2 Reviews)

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 exp More

$250 USD in 1 day
(7 Reviews)

Hello i can do it easily.

$250 USD in 1 day
(2 Reviews)

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
(1 Review)

Hi, please go through the PM.

$300 USD in 2 days
(0 Reviews)

We would be able to help you with this job. Please view PMB for details.

$600 USD in 3 days
(0 Reviews)

Hi, I can help you. Please check my PM

$350 USD in 2 days
(0 Reviews)