Newbie question: how to put a PHP site online?

Hi Rogier,

I suspect that there are many ways to do this. Here's how I do it.

First, figure out what tools your ISP provides for creating and managing
MySQL databases. You'll need to use those to create the initial database and
add a user. My ISP provides a web application named cPanel, which contains
all of the necessary tools.

Then, on your local machine, you'll need to export/backup your database
(schema and data) to a script file. You can do this with mySQLAdministrator,
or phpMyAdmin, or possibly one of several database design tools such as
xCase, DDS-Lite, etc.

Once you have a script file generated, then you'll go to your web server
tools and import/restore the script. This will recreate the schema and data.

Once the database is online, you can connect to it from your workstation
using ODBC, or access it through your php web site as normal.

HTH,

Steve


"RogierBos" <webforumsuser@macromedia.com> wrote in message
news:g58a5q$m98$1@forums.macromedia.com...
> Hello,
>
> I have built a number of sites in DW using ASP and Access. Now I'd like to
> make the transition to using MySQL and PHP (because of scalability and
> more
> affordable hosting solutions). I have checked out a bunch of tutorials
> (mostly
> from Lynda.com) and I think I am going to be OK setting up PHP, MySQL and
> Apache on my PC so as to set up a local Application Server.
>
> The information I cannot find is 'how do I transfer the site to the
> webserver
> (shared hosting)? Of course I understand about FTP - but my question is
> about
> the database files. For ASP sites I had to transfer the .mdb file to the
> server, and create a connection to it (I usually used ODBC). How is the
> connection on the shared hosting server made?
>
> Perhaps there is a tutorial about it (I thought there would be), but I
> can't
> find it. Can someone explain the process to me and/or point me in the
> right
> direction?
>
> Thanks in advance!
>
> Rogier
> Rotterdam, The Netherlands
>