Updating DB: Local vs. hosting
Posted: 16. July 2006 01:13
I am a new web developer, so please excuse me if I don't use the right lingo. I've created a dynamic site (locally using Apache/MySQL/PHP) and now I want to host/publish so that it is viewable to the public.
I've created a local database using mySQL. I've created an insert page so that I can add information into the database. Essentially this is a web front-end page, which makes it easier for me to insert information rather than inserting directly into the database. I am concerned about two things – (1) security, and (2) I want the online database to match my local database (my confidence level of online hacking scares me and I want a backup of my data in case this happens). So I am convincing myself that the best way to deal with this is to update my database locally, and then using FTP to upload the information to my hosting provider once a week. However, I have another concern about this – time it takes to upload the local database every week! The database is relatively small now, but it will grow in size in the coming months and years.
Am I being silly about this method/reasoning?
Is it safe to upload my "Insert page" (user authentication is in place) and just insert the information from the hosting site? Then how could I make a copy of the database from time to time from the host onto my local computer?
I've created a local database using mySQL. I've created an insert page so that I can add information into the database. Essentially this is a web front-end page, which makes it easier for me to insert information rather than inserting directly into the database. I am concerned about two things – (1) security, and (2) I want the online database to match my local database (my confidence level of online hacking scares me and I want a backup of my data in case this happens). So I am convincing myself that the best way to deal with this is to update my database locally, and then using FTP to upload the information to my hosting provider once a week. However, I have another concern about this – time it takes to upload the local database every week! The database is relatively small now, but it will grow in size in the coming months and years.
Am I being silly about this method/reasoning?
Is it safe to upload my "Insert page" (user authentication is in place) and just insert the information from the hosting site? Then how could I make a copy of the database from time to time from the host onto my local computer?