Code:
INSERT INTO users( `id` , `username`)
SELECT `id` , `username` FROM users2;
INSERT INTO users( `password` )
SELECT `user_password` FROM phpbb_users;
INSERT INTO users ( `secret` , `email` , `status` , `added` , `last_login` , `last_access` , `editsecret` , `privacy` , `stylesheet` , `language` , `info` , `acceptpms` , `ip` , `class` , `avatar` , `uploaded` , `downloaded` , `title` , `donated` , `country` , `notifs` , `enabled` , `modcomment` , `gender` , `client` , `age` , `warned` , `signature` , `last_browse` , `passkey` )
SELECT `secret` , `email` , `status` , `added` , `last_login` , `last_access` , `editsecret` , `privacy` , `stylesheet` , `info` , `acceptpms` , `ip` , `class` , `avatar` , `uploaded` , `downloaded` , `title` , `donated` , `country` , `notifs` , `enabled` , `modcomment` , `gender` , `client` , `warned` , `signature` , `last_browse` , `passkey`FROM users2;
this is what i am using to try and import the userdb from one source to another but when i try to do it i get an error message