Hello, I am trying to migrate my XOOPS installation from one server to another. I have successfully copied all files, including the DB. All necessary services are set up on the new system, and via the cmd line I can get into my MySQL DB with no issues. When I try to go to XOOPS via HTTP, I get:

~~
This page cannot be displayed due to an internal error.

You can provide the following information to the administrators of this site to help them solve the problem:

Error: Unable to connect to database
~~

My MySQL log doesn't even log a failure, so it seems like XOOPS isn't even trying to access the DB (at least, not on this host). I have modified what I thought were the necessary settings in mainfile.php to be correct for this new host, anyone have any ideas?

Thanks!

Hi,
Make sure you replace the XOOPS path, MySQL user , password and host by the new servers infos in your config file. It should work.

Good luck

I finally got it working. I had several issues to work out, including:

- setting the proper socket filename in my.cnf
- doing an actual mysqldump and restore instead of just copying the files
- ensuring all the proper rights were granted within mysql

The bottom line is it wasn't seamless going from Debian to RH like I hoped it would have been, because:

1) the MySQL versions were SLIGHTLY different
2) Debian uses several different defaults than RH does with regards to MySQL (like socket location).

Anyways, thanks for the reply!