General question...

[Jim Morris]

I am brand new to coding and MySQL. Here's my question in a nutshell: If I am paying an outside company to host my site, and I build my MySQL database for my site on their server, will I be able to use that same information and put it in a database on my computer here at my home-office, and use it as my primary database for my company? Is My SQL used for web only, or can it be used as a main database for companies and such. Also, I have to use PHPMyAdmin as the interface on their server. If I can put MySQL on my computer here, what would I use for an interface.

Again, I'm new to this and am a little confused on how companies use the same database's information for both the web and locally using MySQL.

Thanks,
Jim:confused:

[Kiwi]

You have a lot of options. Firstly, mysql can run locally on windows: that's no problem at all.

You can use phpmyadmin as the interface, but it's not really a sensible idea (its a dbm system, you really want database applications; it might be useful to have, but not as a primary means of accessing your data).

A lot of the detailed answers depend on exactly what you want the database to do -- ie the applications that you will require on top of it. These applications can be built in anything from php to C++. There are application packages out there that will do some things that you need -- it depends on the purpose of the database.

There is no technical reason why you couldn't use the remote version of mySql as your office database. However, I would see it as a serious data security/integrity risk (if the data's important, then you really want it pretty well under your control).

If you want to use php for your database applications, then you need a server to run php from. This can also be done on your local machine (easily if you don't want to access the data from elsewhere; it's a little more difficult if you want to set-up a secure and reliable remote server).

[wap3]

Hey there Jim,

Well it is possible to set-up phpmyadmin on your own computer. You can download a copy of phpdev which is a bundle including mysql, php and apache web server. (go to www.firepages.com.au)

If you download this to your machine you could use phpmyadmin to add, delete, amend etc your database. Then when you are ready to update your site simply dump the structure and data and give it to your host who should be happy to do the rest for you. (i.e. update the exisisting one)

Hope that helps you.

If you have any more questions regarding this or phpdev then post them here I am sure someone will know.

p.s. the moderator over in the php forum 'firepages' has alot to do with phpdev so your questions will most likely be answered.

Oh and by the way welcome to Coding Forums.

:thumbsup:


Looks like kiwi beat me to it

umm yer Kiwi maybe right there in saying that it depends on what you want to do. But as a very simple solution for just adding to your database then uploading the revised version to your site I would say you would be ok.

[Jim Morris]

Thanks for the input. Also, if the site (on their server) has a shopping cart, and the info is going into the db on their server, how would I get that same info into my db here at home. Is it just drop and drag, or do I have to type it all in? General I know, but confusing to me.

Thanks again,
Jim