2
Use the search Luke
or this:Backing up your databaseUse a tool like phpmyadmin to create an SQL dump file, including all data, from your database. Save this file locally.
Setting up the new databaseOn your new site location, use phpmyadmin to import the database dump file into the new database.
Setting up your new siteCopy ALL the files from your computer to the new site. Make sure you chmod the cache/, templates_c/ and uploads/ folders to 777, and all the files within to 666, and edit your mainfile.php to fit the new database server/database username/database name/database password, and the new physical path and XOOPS URL. Save the mainfile.php, and upload to the new server location. Chmod it to 444.