Monday, August 3, 2009

Do I need MySQL if hosting company has it?

I am teaching myself MySQL %26amp; PHP but the one thing that isn%26#039;t clear is this: If my web hosting company offers MySQL, do I still need to download it onto my computer?



Reading the paragraph one way makes it seem like I don%26#039;t since the hosting company offers it, but then read it another way and it sounds like I do need to in order to build the database. Once built, I can then then transfer it to the hosting company.



Can anyone clear this up?



Do I need MySQL if hosting company has it?





As long as your hosting company has some sort of interface that allows you to run SQL queries against the database you are set. Something along the lines of phpmyadmin or the like. Hosting compnaies such as Globat, 1and1, and lunarpages all have an interface into the database. This will allow you to do whatever you need to on the hosted database without having to set up a local database. It%26#039;s always simpler to have a single database solution rather than multiples, since with multiples you have to be sure that versions stay synced, etc.



Hope this helps!



Do I need MySQL if hosting company has it?



yes, i believe so. or pervasive sql. If it%26#039;s run on a server somewhere, the client computer must also have it%26#039;s own sql services running!



Other Replys:I am sure your hosting company has tools to build the database there but



it is probably much easier and faster to build the structure on your local computer and upload it there...



Other Replys:Hi,



If you are planning to write and develop the SQL and PHP, you%26#039;ll need somewhere to test it before publishing it to your hosting company. Install it locally and you%26#039;ll have that ability.



You may want to check with your hosting company, some of them give you access to their SQL databases for dev %26amp; testing via something like telnet.



Good luck!



http:digitalpix.ca



Other Replys:no, you dont have to install it on your local PC.....



the hosting company should offer some sort of management for MySQL, such as PHPMyAdmin or Xpanel.



You can run queries and dump files from there.

No comments:

Post a Comment