Transferring web hosts - php/mysql application

I have an application that is written in php/mysql on a Linux platform and
need to transfer hosts. This is a session based application and I don't
know a lot about php/Linux/mysql, but can get by. I know windows/asp, etc.
much more extensively. So, can I just move the whole thing over to a
Windows server, upload the mysql backup database and change the settings for
the db connection and have it work? Is there anything that would prevent
this from transitioning smoothly? If so, if I stayed with a Linux platform,
would the transition be this easy or would I have coding changes with this
as well.

I need to tell the new host which platform today and I would rather use
windows, but if there are going to be too many coding changes on Windows,
then I'll leave it on Linux, but if there is just as much work on Linux,
then I prefer to stick with Windows.

Thanks!

Hello Abby,

The only thing that requires thinking about transfering a php/mysql
application from host to host are os specific calls.

If your application simply has sessions and uses mysql as a back end
database then the pain of transfer will be very small.

1, export your MySQL database
2, create mysql database user (or have one created for your account)
with sufficient access to create a database. if not get the server owner
to create one for you and allow you full access to it.
3, create a mysql database.
4, import your exported database.
5, update your database references in your application script(s)
ie: find and replace "olddbname" with "newdbname"
replace "olddbuser" with "newdbuser'
replace "olddbpassword" with "newdbpassword"
if application is designed correctly you should only need to change these
value in one place.
6, server owner who installed PHP should already have directories with the
correct permissions to create file based sessions.
7, test your application

Joseph Melnick
http://www.jphp.com
jmelnick@jphp.com


"Abby" <els817@yahoo.com> wrote in message
news:SwFke.24109$CR5.109@bignews1.bellsouth.net...
>I have an application that is written in php/mysql on a Linux platform and
>need to transfer hosts. This is a session based application and I don't
>know a lot about php/Linux/mysql, but can get by. I know windows/asp, etc.
>much more extensively. So, can I just move the whole thing over to a
>Windows server, upload the mysql backup database and change the settings
>for the db connection and have it work? Is there anything that would
>prevent this from transitioning smoothly? If so, if I stayed with a Linux
>platform, would the transition be this easy or would I have coding changes
>with this as well.
>
> I need to tell the new host which platform today and I would rather use
> windows, but if there are going to be too many coding changes on Windows,
> then I'll leave it on Linux, but if there is just as much work on Linux,
> then I prefer to stick with Windows.
>
> Thanks!
>