moving mybb to new host

[michaelh]

Can you verify if you can login to phpMyAdmin with that username/password?

Yes, they are correct. Mybb is still not working however, and I am still getting the error messages as per post 3 of this thread.

To find the MyBB server address:

• Login to phpMyAdmin with your MyBB database details
  
• Find the user section on the first page you see
  
• Where iwfoc@something is, something would be your MyBB host.
  

Mike

[Kenny]

Well, interestingly enough, it appears my hostname may have been an issue - however, not the only issue it seems. After much digging, I was able to retrieve the following information from my host...

<?php
/**
* Daatabase configuration
*/

$config['dbtype'] = 'mysql';
$config['hostname'] = 'p41mysql45.secureserver.net';
$config['username'] = 'iwfoc';
$config['password'] = '********';
$config['database'] = 'iwfoc';
$config['table_prefix'] = 'mybb_';

I was very optimistic after discovering the hostname above, but alas, when I went to the page, I was greeted by the following error...

MySQL error: 1146
Table 'iwfoc.mybb_datacache' doesn't exist
Query: SELECT title,cache FROM mybb_datacache

Now I don't know for sure, as I'm retarded, but I'm inclined to think that the prefix "iwfoc.mybb_..." may be the problem?

I seem to recall this issue from another thread, however, I don't recall the solution. I'm also not exactly sure this is the problem. Any advice??

[nekng]

I was very optimistic after discovering the hostname above, but alas, when I went to the page, I was greeted by the following error...

MySQL error: 1146
Table 'iwfoc.mybb_datacache' doesn't exist
Query: SELECT title,cache FROM mybb_datacache

Now I don't know for sure, as I'm retarded, but I'm inclined to think that the prefix "iwfoc.mybb_..." may be the problem?

I seem to recall this issue from another thread, however, I don't recall the solution. I'm also not exactly sure this is the problem. Any advice??

are you sure that you imported your old database correctly?

[Kenny]

Well, I had the database on my old server backed up by tech support on my old host, and I had it imported to the new database by tech support on my new host. All I did was to copy, paste and upload the .sql file to my new hosts server. And I seem to be able to see the the mybb files on the new hosts server in my new database.

[nekng]

Well, I had the database on my old server backed up by tech support on my old host, and I had it imported to the new database by tech support on my new host. All I did was to copy, paste and upload the .sql file to my new hosts server. And I seem to be able to see the the mybb files on the new hosts server in my new database.

if you go to phpmyadmin, and go to your mybb database, is there a table in it that is called 'mybb_datacache'?

[Kenny]

ok, this has been a merry go round of Biblical proportions. nekng, your question prompted me to check the tables on my new database, and indeed it turned out that some were missing, so we imported again and now all the tables are there, and we're off and running! Mybb has successfully (I use the term loosely) fired up at my new host, which is very cool, thanks all for your assistance to get to this point at least.

However, there are still issues. Specifically, certain links still want to redirect me back to the version of mybb on my old server. For example, User CP, Admin CP, the Log in and Log out links, the forum name link (where it says "MyBB Community Forums" on your mybb) to name a few. Is there a simple way to correct all these broken links?

Oh, and there is this wierd text: "Â Â " scattered here and there throughout mybb at the new location. Any easy remedy to this?

Any help appreciated.
Kenny

[destroyer]

Login onto your admin cp then go to:

Board settings > change > general configuration and change forum URL and such (cookie settings too) accordingly.

[Kenny]

Thanks destroyer, that did fix those link problems.

Now, as for this weird text "Â Â " which I'm finding scattered throughout posts and even forum descriptions (see here look at the description text for the forum "The Boardroom"). This weird text is scattered throughout. Anyone have any ideas about this?

[destroyer]

There is nothing what you can do about it. You'll have that problem whenever you import a back-up.

[Jag100]

Thanks destroyer, that did fix those link problems.

Now, as for this weird text "Â Â " which I'm finding scattered throughout posts and even forum descriptions (see here look at the description text for the forum "The Boardroom"). This weird text is scattered throughout. Anyone have any ideas about this?

They are easy to remove and by the looks of it can be removed from them templates. Just go into the templates section and remove any "Â Â" you got in the template and save it