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.
I think you need to query only the insert procedures... If you are installing new forum the database will be created all tables with be there.. so what you need only to import the INSERT - UPDATE - DELETE procedures.. I hope that is what u lookin for..