Click to See Complete Forum and Search --> : Upload a mySql data base to a server, possible?


ozpo1
10-10-2007, 04:35 PM
Hi,
Is it possible to upload a mysql data base to a storage server and then calling it from my website which is on a different server?

I'm thinking of simply buying some mega space (like Amazon s3) and then using it to save a database with videos and make some sense with the hosting costs.

Any help will be much appriciated,
Oz

mattyblah
10-11-2007, 02:39 AM
optimal performance requires the database files to reside on the same server as the sql server instance.

Simon Moon
10-18-2007, 10:12 PM
You are better off loading the videos as files somewhere and then store links to those in your database.

The exact thing you propose is as far as i know not really possible in the way you think. The database could use files offsite even, but it would not be only slow...

The data would be transfered from the external storage to your server and then to the client, so you have twice the traffic on the local node. So it would do the opposite of what you want.