Vbulletin Database transfer help
 

Hello,

I recently transferred to a new hosting company, and I have decided to install a fresh install of vbulletin. I installed the same plugins / mods as I had on my other one. I dumped the SQL file from the old DB and executed it into the new DB with no errors. When I go to my website none of the forums, users, etc. was restored but everything is in the database. It still only said 1 user registered which was "Administrator". I decided to search for Administrator in the user table and there was no match. I have spent countless hours trying to figure out what the problem is here and I cannot seem to get it. If anyone could help me out I would appreciate it greatly. Thanks in advance.


http://pictify.me/info/5438 (Admin account)

http://pictify.me/info/5439 (Search query for it in user table)


Thank you.

Seems like it can't be using the restored database. Did you use the same database name and table prefix on the new site? I guess if you have phpMyAdmin or something like that it would be obvious, you'd have 2 databases or else you'd have two of every table.

I am using the same table prefix, but not database name. I will try that and get back to you, thanks for the reply.

edit : turns out my webhost doesn't allow me to change database prefix names so i will have to talk to them, because then the database names will always remain different

Well, I don't want to mislead you - as far as I know the database name can be whatever you want, but it has to match what's in the config.php. I guess I was thinking that if you were still seeing only the one user, maybe you need to change the database name in the config.php.

Some servers like whm/cpanel are going to be tagged with a prefix for the account name, thats not changeable by the end user.

accountname_thiscanbewhatyouwant

The prefix in config.php doesnt apply to the above, it only applies the to table prefix names in the database itself.

the config.php file has all of the correct information