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/