Webmaster Forum Rules | Posting Guide | Contact Us | Testimonials | Contributing Geek Program | Advertise on Geek/Talk
Welcome to the GeekTalk Webmaster Discussion Forums from GeekVillage.com

Click Here To Register. It's Free!

Go Back   geek/talk: Signature-free discourse for serious web publishers > YOUR CREATION: Building & Maintaining A Web Site > Web Development - Programming / Coding
User Name
Register FAQ Calendar Search Today's Posts Mark Forums Read

Thread Tools Display Modes
Old 10-19-2001, 08:11 AM   #1
Registered User
masm50's Avatar
Join Date: May 2001
Location: UK
Posts: 822
Default Uploading database (MySQL), and User Comments

Hi all,

I have started on the long road (or not quite so long as I'm beginning to find) to building a dynamic website with MySQL and PHP.

However, I am creating my database on my windows 98 PC, with the aim to later move it to the web, when it is finished.
To put this database on the internet (with my host supporting both MySQL and PHP), would I have to create the whole database again from scratch, or can I simply upload it?

Also, on a completely different topic:
Are there any PHP scripts around that let you add user comments to your pages, where the users can also give ratings (As used by Zdnet, but I would like something much more simple).

Thanks for any/all help,

masm50 is offline   Reply With Quote
Old 10-19-2001, 09:53 AM   #2
Senior Member
Chet's Avatar
Join Date: Mar 1999
Location: Michigan
Posts: 445

As long as you create the table the exact same way you will use it when you put it on the internet there should be no problem just uploading. You will have to change the DB password and connection info accordingly to what your host gives you for it.

Here is a great site that has a ton of great PHP scripts:
- Chet
Chet is offline   Reply With Quote
Old 10-22-2001, 03:45 AM   #3
Registered User
Join Date: Aug 1999
Posts: 40

I had bad experiences with just copying the database file.
For some reason, evrything got messed up and mysql crashed.

Just make a dump of your database with mysqldump. Mysqldump creates a flat text file with all the sql statements necessary to build up the tables (+ the data). Execute that file on your new host and you have an exact copy of the database.
woutah is offline   Reply With Quote


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Exploits circulating for MySQL flaws Larwee Web Design and Webmaster Issues 0 03-11-2005 02:47 PM
Mysql database Import Gracklor Web Development - Programming / Coding 4 11-19-2002 12:56 AM
Dynamic User authentication and cookies masm50 Web Development - Programming / Coding 2 10-25-2001 05:01 AM
Website/Domains/Proprietary Technology For Sale LaNMaN Archives of old posts from Let's Barter/Trade, Buy, & Sell 1 04-13-2001 07:39 PM
what you think of UltraBoard? notibrian Web Design and Webmaster Issues 15 02-23-2001 11:02 AM

Please support our advertisers. They ensure our survival.

All times are GMT -5. The time now is 10:40 PM.

GeekVillage.com is copyright © 1998-2015 Curiosity Cave - Science gifts for clever kids. All rights reserved.
Powered by vBulletin® Version 3.7.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.