Jump to content


Photo

Migrating to Live Server


  • Please log in to reply
1 reply to this topic

#1 dreamzdb

dreamzdb
  • Members
  • Pip
  • Newbie
  • 1 posts

Posted 20 September 2005 - 04:25 PM

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

#2 bombardos

bombardos
  • Members
  • Pip
  • Newbie
  • 7 posts

Posted 20 September 2005 - 10:59 PM

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.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users