14
MY site is still down after 7 days!!
FastHosts my hosting provider know taht the problem appears to be their server but aren't finding a solution as yet.
I've therefore had to do what I can at my end to ensure a) I have compelete backups and b) see if i can get xampplite running on my local machine to prove i haven't lost my entire XOOPS site 5 years in the building.
I'll document the main steps incase they help anyone and in the hope you can get me past the latest hurdel.
1) I needed to get the latest dump of my sql database to esnure i hadn't lost the database in this fiasco. I do not have php running so could not use this route to get a backup. Finally I found MySQL Administrator a windows software program that would download the database for me. This gave me a 40meg file.
2) I installed xampplite to create a test server on my windows vista home premium system. This worked ok. (gives you php and sql etc test server)
3) You cannot upload sql dumps which are larger than 16 meg in phpmyadmin (a problem I'd encountered before) BIG shout out to
http://www.rusiczki.net/2007/01/24/sql-dump-file-splitter/ who found a little app which will split an sql dump you have previously backedup. (Everyone seems to suggest using bigdump.php but this only works on the server not with an existing sql backup dump or when php is not working). This split my database into four files (1xtables and 3xdata) which allowed me to load it on to my localhost server in parts small enough for myphpadmin to cope with.
4) my problem now is that I'm getting....
Quote:
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'
This error. I guessed this is because somehow no user has been setup for the database. XOOPS manifile.php has my password and username used for the database before. The host is set to 'localhost' but the connection is failing.
In xampplite/phpmyadmin/ i have tried to edit config.inc.php which i think may be where this user data should be held?
Quote:
/* User for advanced features */
$cfg['Servers'][$i]['controluser'] = 'user';
$cfg['Servers'][$i]['controlpass'] = 'password';
I'm not sure if this is where the database user should be managed? or indeed if the db user is actually the problem here.
**fixed** changed the mainfile.php user name to root (the user already shown in MYSQLADMIN for the test server and .... my site popped back up on the test server. THANK GOD!! Now I at least i know i have a fully working site and can change hosts if i need to.
Andrew
Any ideas?