How do I move data from a database into another database.

[Tomi]

Specificaly I have a website with 12,000 members including username, password and email address. What I want to do is open a forum on my site but not have to make each member register again so i want to copy my site database into my forum user database... I plan to use PHPBB.

Thanks

[Johnathan]

Don't know if there is a proper way but I would export the db as a SQL file then open it in wordpad or something with a find and replace thing and just rename thing like the password, email address and username to whatever phpbb asks for then import the SQL file into the phpbb installation.

[webmaster]

Install phpMyAdmin and export the data to a .SQL-file and then import it to the other database.

[flabbyrabbit]

This was the problem that I had as the database you originaly have is not going to be the same as the phpBB table. The easiest way that I found to do this was to write a php script that looped through the original table and insertered the details into the phpBB members table. The main problem I found was if the passwords being encrypted in MD5 as phpBB3 uses a different encryption, but this is easily over come.

Flabby Rabbit

[Tomi]

I added you on MSN Mr Flabby Rabbit.

[flabbyrabbit]

YAY...and i like the MR