MyBB Community Forums

Full Version: host & domain change; sql migration issue
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hello everyone

My first post on this forum. Sorry for my english (in advance).

I have installed my MyBB forum few years ago using dedicated host and domain. After that time I decided to move my forum from my previous (still present) host to another. Here comes my issue: don`t know how to do it properly.
Some detailed informations here:
previous host & domain: www.myforumurl.pl
target: www.newsite.pl/under/forum

What I did:
1. backed up my db to single, appx. 10 mb file .sql
2. moved whole forum directory from previous host to new one
3. made new db, cleaned it; uploaded old stored db structure, tables and content via phpmyadmin (tried also bigdump)
4. edited config & settings php
5. updated mybb_settings table via phpmyadmin on new host.

Nothing happened!

My questions are as follow:
1. due to change of folders structrure how should my settings.php look like:

$settings['bburl'] = "http://www.newsite.pl/under/forum";
$settings['cookiedomain'] = ".newsite.pl/under/forum";
$settings['homeurl'] = "http://www.newsite.pl/under/forum";
$settings['cookiepath'] = "./under/forum";

Just do me a favour and check the syntax please (paths and url syntax).

2. my second question is about updating mybb_settings table (is this action mandatory?)

I have found two ways of doing it:

First one:
UPDATE mybb_settings SET value = 'http://www.newsite.pl/under/forum' WHERE mybb_settings.name = 'bburl';
UPDATE mybb_settings SET value = '.newsite.pl/under/forum' WHERE mybb_settings.name = 'cookiedomain';
UPDATE mybb_settings SET value = './under/forum' WHERE mybb_settings.name = 'cookiepath';

Second one:
UPDATE mybb_settings SET value = 'http://www.newsite.pl/under/forum' WHERE mybb_settings.sid = '30';
UPDATE mybb_settings SET value = '.newsite.pl/under/forum' WHERE mybb_settings.sid = '37';
UPDATE mybb_settings SET value = './under/forum' WHERE mybb_settings.sid = '38';

As above, check my syntax please.

As I said before, no matter what I did - nothing has happened, except new forum installment. I desperately need to change my host AND maintain & continue old forum under new host & domain.

_______

I apologize for my english. Hope you can understand me.

Regards.

Martin
Please update the settings in your ACP and not via the database.
Note: Your cookie domain is not correct. And I'm not sure a cookie path can start with a dot.
Still nothing. No matter wha I do, there is just fresh installment of MyBB.
What`s the reason of inability to access OLD, imported database on my new forum?
- is it because of wrong cache / path stored in settings.php and / or the database itself?
- or there is some SPECIAL way to import OLD database into new one (instead of php my admin / bigdump)?

Please help me, I`m tired of trying for the last few days (tried everything, read EVERY forum dedicated to MyBB script - still nothing).

Regards.

...and thank you.