hello,

(in reference to contents on: https://xoops.org/modules/smartfaq/faq.php?faqid=150 )

a little question: I'm moving the contents of my site from one server to another, including all XOOPS data, MySQL database, etc.

There are a few questions:

1. As the linked page states: Note:Some modules safe certain cache files in a hidden or locked mode, so the FTP application either does not see the file or can not download it. Make sure you test your backup and restore procedure at least once so you do not get surprises when you restore a real backup. .

I have pretty much stuck to using only the modules a basic upload of XOOPS gave me. (News, forums, etc...) Are there any invisible or locked files to worry about? (This was back with XOOPS version 2.0.5, it was uploaded in November 2003.) I'm dragging the whole thing over by FTP (Fetch, Mac OS).

2. The new server has configured a different database name for me, and they say it cannot be changed. Suppose my current database name is database2, and they have set it up so that the new database name is database_db. Do I just need to make a quick fix to mainfile.php?

Thanks for any help.

1. no
2. yes

Hi again,
On the same page it says:
Restore your SQL database
In the new site you will need to have access to your mySQL via the "PHPMyAdmin" application again.
Upload the database by opening the "Run SQL query" window. Select the "database backup" zip file and run the query. The database will be created on the new site.
Now you have to create the same MySQL database user as in the old site and give the correct access rights to the user.

I am confused about this: Now you have to create the same MySQL database user as in the old site and give the correct access rights to the user.
1. Is this user already in the users database (MySQL)? (assuming I exported it correctly)
2. If not, how do I go about creating this user? Is it as simple as signing up for a new account on the new site?

Thanks again for any help.

For a little more clarification see this Faq Page or alternately my full Article on the subject.