The Arcive of Official vBulletin Modifications Site.

Transferring just a few tables... · **Released**: 10-25-2002

how can I transfer some tables from one DB to another DB? I want to get everything to do with the users/usernames etc. but no custom titles or avatars. I want to keep members, posts, threads, too. How can I just choose what I want to keep?

NTLDR · #2 10-25-2002, 07:28 PM

Slelect the tables you wish to dowload in the Backup Option in the ACP.

N9ne · #3 10-25-2002, 09:14 PM

I heard backing up from adminCP is useless, I have a big DB

[and it's all the posts, threads etc. that take a lot of space up?]

I also forgot to mention I want to keep the attachments...[that's another whole load eh].

NTLDR · #4 10-25-2002, 09:18 PM

Backing up from the CP is fine, I've never had any problems with it, its restoring via the web thats the problem, you need SSH access to restore a large DB.

N9ne · #5 10-25-2002, 09:21 PM

So what you're saying is, I can download such and such from the adminCP, and restore it via SSH?

I have SSH access etc. so how do I restore certain tables like that?

NTLDR · #6 10-25-2002, 09:27 PM

Just upload the MySQL files to you server and SSH in, cd into the directory they are stored and use the follwing command:

Quote:

mysql -u USERNAME_HERE -p -h MYSERVERHERE.COM MYvBDB < FILE.sql

Making sure you replace the upper case sections with your username, MySQL server, the database the dump is going into and the name of the file on the server.

It will prompt for you password when you press enter.

N9ne · #7 10-25-2002, 09:29 PM

MYSERVERHERE.com ... this the mySQL server? I have localhost as that? I'm a bit confused over that part

Also, I thought I'd add that I have PhpMyAdmin, and that both databases are on the same host etc. in the same control panel! Is it possible to just transfer very quickly via phpmyadmin as they're on the same host and same hosting account?!

NTLDR · #8 10-25-2002, 09:33 PM

Yes if there on the same host there is an option to. Click a table name in the right colum and then in the main fram scroll to the bottom, you will see:

Copy table to (database.table):

Select the DB you want to copy to and enter the table name, it should then copy it accross.

Thats where it is in v2.2.4, it may have moved in newer versions of phpMyAdmin.

N9ne · #9 10-25-2002, 09:37 PM

It's still the same, when it copies, does it overwrite? [I want it to...I want it to completely change the one that's there with the one i'm transferring]...

NTLDR · #10 10-25-2002, 09:55 PM

I would have thought that it would have overwritten it, but I've never used that function, you can allways drop the tables on the DB your copying them too just to be sure.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.10978 seconds Memory Usage 2,287KB Queries Executed 23 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (10)post_thanks_box (10)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (10)post_thanks_postbit_info (9)postbit (10)postbit_onlinestatus (10)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!