Location of MySQL data directory inside Dropbox / Google Drive folder

Posted on 2013-09-04
Medium Priority
Last Modified: 2014-11-12
I am setting-up a new MySQL database on a new machine, and I was considering to change the default data-directory to a new folder, specifically, inside my Dropbox folder.  In actual fact, my Dropbox folder is inside my Google Drive folder, and I was wondering if there is any downside to setting the MySQL data directory inside these folders.

Is this something that will provide me with added levels of backup protection?  Or are there risks and downsides that I am not appreciating?  

Question by:DanielAttard
LVL 24

Accepted Solution

johanntagle earned 1000 total points
ID: 39465913
You have to consider that Dropbox and Google Drive will sync regularly whenever something is changed in the files inside the directory.  This will cause a lot of traffic whenever there are changes to your data.  If that's not an issue then it might be worth a try.

Personally I would rather have the Dropbox directory be the location I put my backups to.

Author Comment

ID: 39465956
Thanks for the ideas @johanntagle.  I guess it makes sense to use Dropbox as the location to put the backups rather than the primary data.
LVL 54

Assisted Solution

by:Scott Fell, EE MVE
Scott Fell,  EE MVE earned 1000 total points
ID: 39466328
Theoretically you could but it is not a good idea other then using it locally for development.  Dropbox is a front end for amazon simple storage.  And looking at Amazon's faq, http://aws.amazon.com/s3/faqs/#Can_I_host_my_static_website_on_Amazon_S3 they say hosting static files is ok but not for dynamic.  

Web and data servers are designed to manage the type of traffic and security required to host a dynamic site or database.  I agree this would not be a good idea.  However, using cloud services for hosting your db that are meant for a db are probably better idea today then traditional shared hosting.  


Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

If you try to migrate from Elastix to Issabel, you will face a lot of issues. These problems are inevitable but fortunately, you can fix them. In the guide below, I will explain how I performed the migration while keeping all data and successfully t…
Before you approach an Ionic Mobile App development company for developing mobile apps using the ionic framework, you must know why you should choose the framework. Let's try to understand that through this article.
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

621 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