How To Transfer Users and Threads to a new Vbulletin Forum?
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".
If you are using the same version of vbulletin, you can restore the old backup to a database. Take the dump of the required tables only from the new database and restore those tables to the vbulletin database.
To dump a table only
mysqldump dbname tablename > /path/to/file.sql
To restore a tables only. From mysql prompt.
mysql> RESTORE TABLE ely_runner_log FROM '/path/to/file.sql';
Thank you for quick replay, I have installed it in my new forum, but how can I import my .sql file by it??
I see that there is a "source" in impexconfig.php but there is no installed database from my ex forum, I have format the server! I just have the .sql and database folder which I have copied before format.