general question about uploading web apps

[hconnorjr]

i have my site completed and it works on the testing server without a glitch. i've uploaded static sites before without a hitch, but i'm not so certain about web apps. seems when you upload the site with dw, it uploads the html and php . . . but then there are the tables from the db. uploading them and getting them to hook up all over again . . . how do you do that? can someone review the steps please. thanks.

[Newsgroup_User]

the easiest way is exporting the db using a tool like phpMyAdmin and
importing it on the server. of course, you'll need the tool in both servers

hconnorjr wrote:
> i have my site completed and it works on the testing server without a glitch.
> i've uploaded static sites before without a hitch, but i'm not so certain about
> web apps. seems when you upload the site with dw, it uploads the html and php .
> . . but then there are the tables from the db. uploading them and getting them
> to hook up all over again . . . how do you do that? can someone review the
> steps please. thanks.
>

[hconnorjr]

so the steps go something like this:
1. find db to upload from testing server
2. go to new server. find the directory that is used for databases (presumably one that the admin has already set up for apache/php to look for db tables. make a db of the same name as in your testing server.
3. use phpMyadmin on the testing server and make backup of your db. since its new for the production server use the default values. in this step the db can also be backed up by tables if its large and upload time might be an issue.
4. go the the new server. with the phpMyadmin on that server, name a database with the same name as the one on the testing server. use IMPORT. go to the browse button and find the db on your testing server and IMPORT it.

small question: i can see the files on the remote server from dw when its properly set up, but does phpMyadmin allow me to see files on my testing server without some configuration?

[Newsgroup_User]

something like this:

1. check your remote server has phpMyAdmin installed and the URL to
access it (phpMyAdmin is a web app written in PHP and you access it
through a browser)

2. download and install phpMyAdmin locally

3. run phpMyAdmin, usually http://localhost/phpMyAdmin, but the url will
vary depending the installation and your development platform.
export your local DB; phpMyAdmin will create a file named by default
"localhost.sql". depending your browser configuratioon you can change
the file name/choose where to save

4. run phpMyAdmin in the remote server and import your DB just choosing
the file in step 3

later you can export/import tables instead the full DB. if you're
reimporting the DB remember to check the "Add DROP DATABASE" checkbox
when exporting

you can't see any files in the server with phpMyAdmin, it's only a
visual interface to the MySQL server. keep using DW to
create/modify/upload html, js and php files

hconnorjr wrote:
> so the steps go something like this:
> 1. find db to upload from testing server
> 2. go to new server. find the directory that is used for databases (presumably
> one that the admin has already set up for apache/php to look for db tables.
> make a db of the same name as in your testing server.
> 3. use phpMyadmin on the testing server and make backup of your db. since its
> new for the production server use the default values. in this step the db can
> also be backed up by tables if its large and upload time might be an issue.
> 4. go the the new server. with the phpMyadmin on that server, name a database
> with the same name as the one on the testing server. use IMPORT. go to the
> browse button and find the db on your testing server and IMPORT it.
>
> small question: i can see the files on the remote server from dw when its
> properly set up, but does phpMyadmin allow me to see files on my testing server
> without some configuration?
>