Transferring just a few tables...
 

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?

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

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].

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.

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?

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

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.

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?!

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.

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]...

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.