store | blogs | forums | twitter | facebook | wiki | downloads | support portal
Atomic Secure Linux
It is currently Fri Oct 24, 2014 5:17 pm

» Feed - Atomicorp

All times are UTC - 5 hours [ DST ]




Post new topic Reply to topic  [ 5 posts ] 
Author Message
 Post subject: How To Transfer Users and Threads to a new Vbulletin Forum?
Unread postPosted: Fri Oct 23, 2009 5:03 am 
Offline
New Forum User
New Forum User

Joined: Fri Oct 23, 2009 3:32 am
Posts: 3
Hi everyone,

I have formated my linux Centos 4 server with PHP 4.4 and install Centos 5 with PHP 5.1 ( will upgrade to 5.2 soon ).

I succeed to restore all of my web sites and forums except one which has 110MB sql file, VBulletin 3.6.8.

I think the problem is related on my hack's and modifications I have done before...

Now I decided to install a new and fresh forum with version of 3.6.8 to be the same with ex one ( I will upgrade it after transferring ( migrating ) every threads, posts and members to new forum to 3.8.4)

But the problem is: when I restore the whole sql to new forum I had come across many problems.

THE QUESTION IS:

how can I transfer just "threads", "posts" and "members" to a new and fresh vBulletin forum ?

please note that my forum is not working now and I just have a "whole-website-backup.SQL" file and also back up of whole database folder in the linux ( it contains .frm , .MYD , .MYI files like: mst_post.frm , mst_post.MYD , mst_post.MYI and others...)

I have tried to copy these .frm .MYD and .MYI files on the new database folder but it was not worked!!

I think I must restore by the help of .SQL file but I dont know how! when I recover whole the .SQL file forum does not work good and had some problem ( I can't log in to admin panel for example, and my VBSeo configurations gone and can't be repaire...

Please show me how can I transfer just my Posts and members to a NEW installed VBulletin forum with same or different "database name" and "database username".

Thank you in advance.


Top
 Profile  
 
 Post subject: Re: How To Transfer Users and Threads to a new Vbulletin Forum?
Unread postPosted: Fri Oct 23, 2009 8:19 am 
Offline
Forum Regular
Forum Regular

Joined: Mon Apr 10, 2006 12:55 pm
Posts: 672
Really this is a topic for the vbulletin forums. In general, however, you can't just copy the underlying mysql files and expect it to work. Remember that your database also has things like users, permissions, etc, that are not stored in those files.

It sounds like you have a mysqldump of the database. If that is the case then I would simply recreate your database and read your dump file back in
Quote:
mysql -u user -p databasename < dumpfile.sql

_________________
"Its not a mac. I run linux... I'm actually cool." - scott


Top
 Profile  
 
 Post subject: Re: How To Transfer Users and Threads to a new Vbulletin Forum?
Unread postPosted: Fri Oct 23, 2009 8:30 am 
Offline
New Forum User
New Forum User

Joined: Fri Oct 23, 2009 3:32 am
Posts: 3
Thank you for replay,

I had tried it but its take many times! ( sql is 110 MB ) and I just want a fresh forum without hacks and modifications, to do that I want to just restore the users and posts!

please forgive me I am newbie and don't know everything about this subject.


Top
 Profile  
 
 Post subject: Re: How To Transfer Users and Threads to a new Vbulletin Forum?
Unread postPosted: Fri Oct 23, 2009 8:37 am 
Offline
Forum Regular
Forum Regular

Joined: Mon Apr 10, 2006 12:55 pm
Posts: 672
Like I said, this is more of a specific question for vbulletin. The best we can do here is tell you basics. I've not ever done what you're talking about and it's not likely anyone else here has either.

_________________
"Its not a mac. I run linux... I'm actually cool." - scott


Top
 Profile  
 
 Post subject: Re: How To Transfer Users and Threads to a new Vbulletin Forum?
Unread postPosted: Fri Oct 23, 2009 8:38 am 
Offline
New Forum User
New Forum User

Joined: Fri Oct 23, 2009 3:32 am
Posts: 3
You are right, Thank you.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 5 posts ] 

» Feed - Atomicorp

All times are UTC - 5 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group