| Re: Migrating xoops to new server - database connection prob |
| by XXeR_ on 2007/8/1 19:55:02 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! |
| Re: Migrating xoops to new server - database connection prob |
| by spacejoee on 2007/8/1 18:14:21 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 |
| Migrating xoops to new server - database connection prob |
| by XXeR_ on 2007/8/1 16:19:21 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! |
Search
Recent Posts
Who's Online
Donat-O-Meter
| Stats | |
| Goal: | $15.00 |
| Due Date: | Jul 31 |
| Gross Amount: | $0.00 |
| Net Balance: | $0.00 |
| Left to go: | $15.00 |
|
|