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
>
3
Replies
AdChoices