Transfer PHP Live! to a New Server

SUMMARY

To transfer your PHP Live! system to a new server, there is basically three things that needs to be done:

1. Move your PHP Live! PHP Files
   
2. Edit the Configuration file (phplive/web/conf-init.php)
3. Export the PHP Live! Database and Import to New Database
   

INFORMATION

1. Move your PHP Live! PHP Files

Compress your entire phplive/ directory using ZIP or tar. Ftp the ZIP or tar file to the new server location and decompress.

[top]

2. Edit the Configuration file (phplive/web/conf-init.php)

On the new server, edit the phplive/web/conf-init.php file and update the variables to reflect the new server and MySQL. The variables that needs to be updated are:

$DATABASE = 'new_database_name' ;
$SQLHOST = 'new_mysql_host' ;
$SQLLOGIN = 'new_mysql_login' ;
$SQLPASS = 'new_mysql_password' ;
$DOCUMENT_ROOT = 'new_path_to_PHP_Live!_files, example: /home/mysite/www/phplive' ;
$BASE_URL = 'new URL, example: http://localhost/osicodes/phplive' ;

NOTE: On windows systems, the $DOCUMENT_ROOT should contain DOUBLE slashes to avoid error. For example, if your complete path is C:\Apache\Apache2\htdocs\osicodes\phplive, the $DOCUMENT_ROOT path should be C:\\Apache\\Apache2\\htdocs\\osicodes\\phplive

[top]

3. Export the PHP Live! Database and Import to New Database

There are couple ways of doing this:

1. If you are the server admin, you can directly access MySQL's var/ directory and tar up the entire folder of the PHP Live! database and untar it on the new server's MySQL var/ directory. Restart MySQL.

2. Using MySQL front-end tool (such as PHP MyAdmin) and export the entire database to a file, both the structure and the data. On the new server, create a new database and then import the text file containing the entire PHP Live! data. You can either use the upload file option or open the file yourself and copy/paste the entire content and put it into the SQL query window at the new database using a MySQL front-end tool.

Done! Congratulations!

[top]