PDA

View Full Version : Vbulletin Database transfer help

Hiatus-
04-09-2013, 09:53 PM
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.
kh99
04-09-2013, 10:14 PM
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.
Hiatus-
04-10-2013, 12:03 AM
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
kh99
04-10-2013, 12:31 AM
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.
snakes1100
04-10-2013, 02:16 AM
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.
Hiatus-
04-10-2013, 02:25 AM
the config.php file has all of the correct information