How to I merge tables between 2 databases?

[MrLeN]

I have 12 forums running, and they all have a members table.

I am going to use just the members table of one forum.

How can I get all the members tables out and merge them all into the main one?

Can I do it with myphpAdmin?

MrLeN

[brian.mark]

We use MysqlFront. It allows us to open 2 or more databases and directly copy tables and data from one to the other.

Depending on the version of mySql and the version of phpMyAdmin, you should have an "Export" option to create a text file and an "SQL" tab which usually has "Insert data from a textfile into table" at the bottom.

That should accomplish the merge you want to do.

Brian.

[MrLeN]

Okies mate, I'll go find the export buttons :)

MrLeN