Jump to content

Migrating to Live Server


Recommended Posts

I followed a dreamweaver tutorial and set up a testimonials area for a website that I'm building. Everything works great on my local machine and I'm ready to upload it to a live server. I set everything up using one MySQL Database and One table. Would it be easier to just upload my php pages and make a new MySQL database on the live server w/ php admin? I know it made another php page in a "connections" folder which I'm sure I will have to put into a "connections" folder on the live server.

 

What is the easiest way to move this at to my webserver from my localhost?

 

Tom

Link to comment
Share on other sites

Would be easiest to create new tables on your server, unless you can copy paste the mysql script used to create the tables into notepad and save them as tableName.sql. Then in phpAdmin there shold be and option there (I think under SQL option) to upload your sql files which will create them for you.

 

Your host should have already given you a database to use, you would then just have to change you code in you Connections/dbconnect.php file to match the name of the database ($database_dbconnect = nameOfDatabaseOnPHPAdmin) and any other file containing a connection to the database (use Dreamweavers Find and Replace), usually the name of the $hostname in your dbconnect.php will remain as localhost. You'll know this when you log in to phpAdmin, it'll say MySQL 4.0.22 running on localhost as yourusername@localhost.

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.