Urgent help needed

[merk_aus]

Ok guys,
I will appreciate as much help as you can give - I have registered a new domain name and brought a new vbulletin license for a mates site.

He was currently using a free hoster with Invision Power Board - in doing so we did not have access to the information needed to use IMPEX - I have a .sql back up of the database and thats all I have.

I was wondering whether there was anyway to get the users/posts etc etc from this current sql backup onto a brand new hoster running vbulletin I ask this as my mates forum in 2 months has got:

Our members have made a total of 19171 posts
We have 124 registered members

And we would really like to bring them over the vbulletin and its new host. Please anyone who is able to help It is really urgent. We are running 3.6.8 and the IPB vers. 1.3 Final.

Like I said we would like to bring over, Topics, Members, Posts, Post Count if possible but to be honest as much information as possible. As I mentioned I only have a .sql backup of his current site and trying to get it onto vbulletin on a completly new host.

[bobster65]

if you have a backup of the old DB, just restore it to a seperate DB on the new host and then you can use IMPEX to migrate the data into vbulletin. Pretty simple process actually.

[Marco van Herwaarden]

As bobster replied, all you need is the database. So if you have a backup restore it into (preferably) a new database and import from there using ImpEx.

[merk_aus]

Hey guys I have done this back up but for some reason on the sites main page it shows the total post count etc etc correctly but on top of that there is nothing no actual catergories, no actual threads or posts and the member total is not showing up properly?!?

With the brand new install of vBulletin am I meant to create the forum board and stuff to include the catergory and forums that are on the other site then import?

[snakes1100]

Update the counters thru the maintence menu in the admincp, bottom of the menu.

[merk_aus]

lol i read that on the HowTo as well and completly forgot - life saver lol I told the guy check out your site etc etc and he is like yeah where is all of my posts lol

Thanks mate your a life saver

--------------- Added [DATE]1203721264[/DATE] at [TIME]1203721264[/TIME] ---------------

[merk_aus]

OK I have done everything that is listed here, done everything in the help section and stuff and I keep running into the same problem...

Once the whole database transfer is done - people log in and click on their profile or whatever and it comes up that the user is unregistered and therefore does not have a profile.

The second thing is people click view all posts by this person and it comes up that search could not find any results?!?

Can anyone help me figure these out?!? Its frustrating to be so close yet so far from having it done

[nofat.co.nz]

You know you could also try to do it just with phpmyadmin and not use impex

I had to put my site back from a SQL database backup as I got hacked and I was going to use impex - but then decided to just to do it with phpmyadmin, and it worked no worries - all the posts, users, profiles, everything, all back up

If you want to try it all you do is go to your database section, check that you have the database and user set up the same as your original database (check the prefix is the same too ) If not then set it up

Then go to phpmyadmin and click on the database name on the left ... it will bring up all the tables - scroll to the bottom - check all - then with the dropdown box just to the right select drop - this will get rid of the tables so that they don't come up as already being there when you import your old database

Next go to the top of the page and click on import - *use the browse button to select your file of your database backup from your computer - I left the Partial import button ticked for timing out and restarting incase your site is really large
- I also chose mysql 4.0 in the drop down box for SQL compatibility

Then click on go - you'll have to wait quite a while for it to all get imported (mine took like half an hour or so - then if your old database was really big it may time out - if it does just click on browse and so the same thing from the * above - it will start importing from where it left off

Anyway hope it works for you - mine worked like magic

Good luck