set the columns for the new user table to the same types as the phpbb ones and do a simple SELECT username, password and loop through the results and INSERT into the new db/ table
phpbb gurus
personally I would just write my own simple script for it
set the columns for the new user table to the same types as the phpbb ones and do a simple SELECT username, password and loop through the results and INSERT into the new db/ table
set the columns for the new user table to the same types as the phpbb ones and do a simple SELECT username, password and loop through the results and INSERT into the new db/ table
[i]And shepherds we shall be, for thee my Lord for thee, Power hath descended forth from thy hand, that our feet may swiftly carry out thy command, we shall flow a river forth to thee, and teeming with souls shall it ever be. In nomine patris, et fili, et spiritus sancti.[/i]
-
^misantropia^
- Posts: 4022
- Joined: Sat Mar 12, 2005 6:24 pm
mysqldump the source table and execute it on the destination host with `mysql -u username -p -B -e 'data.sql'`. At the very worst, you need to manually patch data.sql a little to make sure it uses the right database etc.