5.1. Transferring a local installation to the Web

You may prefer to test PHP-Nuke on your local box and acquaint with its features at your own pace, without the need to be constantly online. In this case, when you are done with your evaluation, you will face the problem of transferring your local installation to your webspace. A fresh installation on the Web may not be very attractive an option to you, if you did some more or less heavy customization of the code or preferences.

For the files, simply upload the content of the html folder to your document root, or wherever you want it to appear under that. For the database, use mysqldump or phpMyAdmin (see Section 3.4) to do a backup of the database and import the data into the MySQL of your web presence.

To do a backup from the command line using mysqldump, do:

mysqldump -h dbhost -u dbuname -p dbname > dbbackup.sql

where dbhost, dbuname and dbname are exactly what you entered in config.php (see Section 3.7) for these variables. To import the data using mysql from the command line, do:

mysql -h dbhost -u dbuname -p dbname < dbbackup.sql

If you change your local files and/or tables regularly, you may choose to transfer only the files/tables that changed. In this case, you should drop the affected tables before you reimport them. phpMyAdmin offers a convenient interface for this (see Section 3.4.2 and Section 26.2.1).

It is a good idea to announce these measures to your community, to avoid frustration among your users.