Forum Moderators: open
- Will I have to leave my PC on all day to access my database?
--> If so, are there IP's such as register.com that can allow me to store and access my data using WinMySQLAdmin or mysql client?
--> What about buying my own web server? I have seen them on sale from anywhere around 750.00 to 400,000.00.
Please understand that although reducing cost is necessary, I would rather be as far from the idea of a remote server as possible. Ecspecially, if I don't have complete control or considerable ownership over the environment, just as would if I did have my own IP address, and local web server.
Thanks
I don't know where the actual database data is stored (cgi-bind, maybe?) but nobody can access it unless they can also access your MySQL access script, which should be stored outside of the web directory.
Perhaps you could also help me out with some add-on questions:
- So, I just download MySQL build my database on my own PC and wah-lah? Although, we cannot determine where the information is stored it is still accessible through a remote location?
- If so, is there a way I can backup data?
- Then I could only fathom that I would just need a server to actually host my web site, right?
To backup a db there are plenty of ways, from php admin screen (which you will get with hosting) you can dump structure and data in different formats ie zip tar or .sql type file
its not the best method to host on the web and run the db at home, keep it all in one place
Since I need a seperate user name and password for both accounts. Can I assume that the user account for MySQL is set up when I I download it to my PC? Or... Is there seperate account set up with most host servers to access thier own MySQL database?
You will also need to create a user and password for the database.
When accessing the database in your PHP script, you generally use "localhost" as the server name, and the database name, username and password you selected above.
Just to let everyone know. My initial question (although ansewered quit well) has lead lead me to other subsequent questions. I appreciate everyones response here. You ansewers have really provided a gold mine of information for me.
My best advice is to go ahead and get a hosting account that has php and MySQL capability, then start experimenting with the tools provided in the Hosting Control Panel. You can learn an awful lot by hands-on screw-ups, and believe me, you will screw up a few times until you start to understand :-)
If you get lucky, your hosting provider will also have a nifty tool called Fantastico - this will install and set up the database for quite a few of the common OpenSource tools such as blogs, content management systems, etc. These "canned" programs are great practice material, to see how the database is set up and how to define tables, do backups, etc.
.Best of luck!
Thanks and fortunately I have nothing but time to research. I have been reading so many books on MySQL and even SQL. What confuses me is that they talk about installing MySQL on my C drive, where I once presumed my data would be stored. I guess what baffled me was the complete neglect to actually mention a server or even a host. And because it is true that in order to use a database that is accessible 24/7 you need a remote server. Than "why, oh why" would they even mention downloading it onto your C drive. Ah well ... I can see what you mean about experimenting being the best route, and I will get right on that.
My website is database driven so I have a copy of the database on my local computer with the same structure. A copy of all the website pages in a folder. and PHP installed to parse the scripting. This allows me to work on the website and test it on my computer without even being connected to the internet. Then when everything checks out OK I can use my FTP program to synchronize the files in my local folder to the web server.
Hope that makes sense, It works for me!
William.
Have a look at your host to find which version of PHP and MYSQL they are running and compare it with yours. If your host is up-to-date, then it should have at least PHP4.0.
Good luck and post again to get some tips.
Where do you want to download it to? You have to DL it to your computer just like anything else and then transfer a copy to the web site.
You have to DL it to your computer just like anything else and then transfer a copy to the web site.
mysqldump --opt mydbname > mydbname.sql
scp the mydbname.sql file to your server
mysql mydbname < mydbname.sql
