Server Change, A few problems.

[Einzel]

Ok, I will try to make this as simple as possible.

1. Globalgold was hosting my forum, version 3.8.2, I migrated to MDDhosting.

2. Globalgold set everything up, originally, I just FTP'd the files locally and uploaded them
to MDD.

3. I edited the Config file to reflect the new MySQL database, username and password.

4. The forum is up and working.

Now, to the problems.

1. With Global I had the forum located in the root directory, not "/forum", etc. I changed this in the config as well.

2. I cannot log in to my admin account so I can change/update the website info, etc.

3. I thought I could rest the password but that link takes me to an empty page and says the file is missing. It
is not missing. I believe it has something to do with #1.

So, I need to know how to get back into my admin account to see if I can get back in control.

I knew their would be small issues as this wasn't a 1:1 copy and paste, due to the slight differences but it appeared
easier than doing a clean install and then backup.

Any help is appreciated.

[Trevor Hannant]

What you should have done was to update the Forum URL in AdminCP before taking the db backup and moving it over. In order to correct this now, try running the following on the new database:

***MAKE SURE YOU HAVE A FULL BACKUP PRIOR TO RUNNING THIS***

UPDATE PREFIXsetting SET value = 'http://www.newurl.com' WHERE varname = 'bburl';
UPDATE PREFIXdatastore SET data = REPLACE(data, 's:5:"bburl";s:23:"http://www.oldurl.com";', 's:5:"bburl";s:29:"http://www.newurl.com";') WHERE title = 'options';

Change 'oldurl' and 'newurl' to the correct URLs for the query and replace 'PREFIX' with any prefix your tables may have or remove if none.