Taking my PHP/MySQL site online - how?

[RogierBos]

Hi,

Once I have developed a site on my local PC in DW, utilizing PHP and MySQL Administrator, how do I make it work online?

Obviously I need to use the built-in FPT function in DW - but how do I transfer the database files to the server?

I have searched for an anser to this question for a long time - but all the tutorials I find (and I have found a number!) help me develop my site locally - and then say nothing about taking it online.
I have developed a number of sites using ASP/Access. When I take such a site online, I need to change the connection-string. Is the process the same for PHP/MySQL sites? If yes, what change do I need to make? And what database-file do I upload to the server, and where do I put it?

Here is where I want to get: I want to have my site locally, so that I can make any changes to it when necessary - and then upload it so that it now uses the online database. ASP/Access allowed me to have both locally, so that I could make any changes. Downside is of course you have two versions of the database, one local, one remote.

My host uses PHPMyAdmin. I see I can download a version of this and use it locally. Should I do that and use that? Does it do the same as PHP Administrator?

As you can see I have many questions. I think I am missing a few key-thoughts that will help me understand PHP and MySQL and make go "oh, now I get it!'

Please feel free to point me to tutorials that you believe I will find helpful.

Thanks for your help in advance!

Rogier

[Newsgroup_User]

RogierBos wrote:
> Obviously I need to use the built-in FPT function in DW - but how do I
> transfer the database files to the server?

Use the Export tab of a local version of phpMyAdmin to save the contents
to a SQL file. Then use the Import tab of your remote server's version
of phpMyAdmin to navigate to the SQL file, and import it (maximum upload
is 2MB).

> I have developed a number of sites using ASP/Access. When I take such a site
> online, I need to change the connection-string. Is the process the same for
> PHP/MySQL sites?

In most cases, the connection details are the same as for your local
setup, assuming you used the same MySQL user account details.

> And what database-file
> do I upload to the server, and where do I put it?

You don't. MySQL is not like Access. You export the data from one DB and
import it into the other.

> Here is where I want to get: I want to have my site locally, so that I can
> make any changes to it when necessary - and then upload it so that it now uses
> the online database. ASP/Access allowed me to have both locally, so that I
> could make any changes. Downside is of course you have two versions of the
> database, one local, one remote.

Forget that way of working. Upload your admin pages to the remote
server, and administer the DB there. Make a backup of the online DB from
time to time.

> My host uses PHPMyAdmin. I see I can download a version of this and use it
> locally. Should I do that and use that? Does it do the same as PHP
> Administrator?

I don't know PHP Administrator, but phpMyAdmin is a very useful free tool.

--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/

[Newsgroup_User]

RogierBos wrote:
> Hi,
>
> Once I have developed a site on my local PC in DW, utilizing PHP and MySQL
> Administrator, how do I make it work online?
>
> Obviously I need to use the built-in FPT function in DW - but how do I
> transfer the database files to the server?
>
> I have searched for an anser to this question for a long time - but all the
> tutorials I find (and I have found a number!) help me develop my site locally -
> and then say nothing about taking it online.
> I have developed a number of sites using ASP/Access. When I take such a site
> online, I need to change the connection-string. Is the process the same for
> PHP/MySQL sites? If yes, what change do I need to make? And what database-file
> do I upload to the server, and where do I put it?
>
> Here is where I want to get: I want to have my site locally, so that I can
> make any changes to it when necessary - and then upload it so that it now uses
> the online database. ASP/Access allowed me to have both locally, so that I
> could make any changes. Downside is of course you have two versions of the
> database, one local, one remote.
>
> My host uses PHPMyAdmin. I see I can download a version of this and use it
> locally. Should I do that and use that? Does it do the same as PHP
> Administrator?
>
> As you can see I have many questions. I think I am missing a few key-thoughts
> that will help me understand PHP and MySQL and make go "oh, now I get it!'
>
> Please feel free to point me to tutorials that you believe I will find helpful.
>
> Thanks for your help in advance!
>
> Rogier
>

Sounds like you need to export your database and then import it into
your production server. Then upload the website, adjust the connection
string so that its pointing to the correct server with the correct
credentials and away you go.

Steve

[RogierBos]

Steve and David,

Thanks to both of you for your help. I am slowly coming to grips with developing a web application using PHP and MySQL. Your input was very helpful!

Rogier

[RogierBos]

Steve and David,

Thanks to both of you for your help. I am slowly coming to grips with developing a web application using PHP and MySQL. Your input was very helpful!

Rogier