8
I am getting these instructions from my hosting company, but they don't seem to work:
It is possible to modify the current installation to work on this server without resinstalling. You simply have to check the config files that were created during the initial install to reflect the new username.
To reinstall, you would do the following:
-backup your database so you don't lose data, this can be done with cpanel->backups, click on the database name to download it
-remove XOOPS installation
-reinstall using Fantastico (or manual, although Fantastico is easier)
-reupload your database, you may have to manually add the database entries to your new database using these steps :
(1) Create a MySQL database in cpanel (this is already done by xoops, skip)
(2) Login to phpmyadmin (bottom cpanel MySQL page)
(3) Once in phpmyadmin, click on the database
(4) Click on SQL (top menu)
(5) Open your MySQL database file with notepad (the backup you downloaded to your local machine)
(6) copy a 1mb or smaller peice of the database
(7) paste what you copied in the sql dump text field
(8) repeat process, breaking database into small peices, pasting one peice at a time, starting each peice on a new line.
This is how to popular a large MySQL database.
