4
how about telling him to edit the config file :)
the easy way i do it and it works ,
copy all the files from ur old host to ur pc
then upload these files to ur new host
edit the config.php
edit the database name,mysql usernam,mysql password. it should be of the new host ur shifting too.
then make a MySQL dump from ur oldhosts phpmyadmin,
like Mithrandir said
select all tables ,structure, data and "DROP IF EXIST"
use gzip compression if the db is big, and click save as, and press go . a popup will come for u to save the backup on ur pc. save it,
then go to ur new host phpmyadmin,select the database u made for ur xoopssite,and just upload the db in sql