Moving Servers, in DIRE need of help!

G

ghfever

New Member
Hey everyone,

Okay this is kind of confusing to explain, but here it goes -

I currently run a big brother forum via vBulletin and a MySQL Database. Due to the increase in members and posts, the forum started to get laggy. I called my host and they said I'd need to upgrade FROM shared hosting, TO a Virtual Dedicated Server.

So. I did. I backed up the Wiki SQL, Wordpress SQL and vBulletin SQL. When I setup hosting through the VDS, I started with the restore on the Wordpress. That worked fine. Wiki was next, restored the SQL, that worked fine. The vBulletin finally, and we'd be all set! But of course, not.

For some reason I get error after error when I try to upload a backup of the SQL Server for the vBulletin Forum, even though I'm doing the exact same thing I did for the other two. Can ANYONE think of any reason it would be doing this?!

Thanks so much!

- Danny
 
Here are a few of the error messages -

Code: 
ErrorSQL query: 
/*!40000 ALTER TABLE `attachment` ENABLE KEYS */;


MySQL said: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ';
CREATE TABLE `attachmentpermission` (
  `attachmentpermissionid` int(10) uns' at line 4

AND...

Code: 
SQL query: 
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

/*!40101 SET NAMES utf8 */;

--
-- Database: `bbfans2`
--
CREATE DATABASE `bbfans2` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;


MySQL said: #1007 - Can't create database 'bbfans2'; database exists
 
dark_hunter said:
I would install with new database, then drop tables in database and import the backup sql file database into it.
Click to expand...

NICE! This worked. The new server's database has all the information from the old one now!

But, we're still having major problems. http://big-brother-fan.com/forum/ won't load now, it's just a white screen, and when I go to the admincp, I can see the login screen - but when I login it just brings me to another white page.

If we can get past the white, I think all the information is there!
 
Okay wait wait!

Now I can login, see the forum, see the posts and everything!

Only problem now is, I'm the only user that came over and all 8000+ posts aren't actually there. Just under each subforum, the latest thread shows up, but when you click it - it says invalid thread.

And I had a user try and login and they can't. It gives them invalid user/pass. So I'm assuming that the information was brought over from the database but not the threads/users. Which table stores those two things? Help!
 
You must log in or register to reply here.
Back
Top