User tables

[Langly]

What tables contain the users, the threads and the posts? I have to manually move my SQL to a different host and have to verify each line to be sure it is not corrupted. I did a fresh install of vbulletin and the last thing I have to add is the previous users, threads and post part of the database. So any ideas what tables those are please?

Thanks

[filburt1]

Ironically enough, user, thread, and post. There are some secondary tables that provide additional dependencies.

[Langly]

I lost you there. You mean it is more than 1 table for each of them? I know the user table itself uses like 2 or 3 tables but I don't know which ones all of them use which is what I'm trying to find out.

[Marco van Herwaarden]

Why don't you just backup & restore the database? Why playing with single tables, that will really give you a lot of headaches.