how do i remove all users with imported in it?

[lowandloudinc]

can i do that on a mass scale? or one by one?...

[lowandloudinc]

yes they are the same and that merge user would take me forever since there are almost over 500 - 1000 users like this.

so back to my original question. since i know all the users have an...

[lowandloudinc]

ok so i should run the user module one more time?

and some emails arent the same as their other account.

example:

vinny - email: [email protected]
imported_vinny...

[lowandloudinc]

some have different some have the same email. but the username always says in use when i try to delete the import part of it.

they are the same user for sure cause alot of these names are...

[lowandloudinc]

well i checked 5 accounts and every imported user had the same name.

so they are duplicates on the forum and i should either merge them or delete? the imported do have posts in some of the...

[lowandloudinc]

i merged 2 forums both VB 3.6.7 pl1

the target had 7500 members

and the source had 11,000 members

i followed all the modules by th ladder and all went fine except...

[lowandloudinc]

it was a merge. now i have alot of users with imported_ in front of the usernames. how do i delete them?

i think they are all doubles.

[lowandloudinc]

i have alot of imported_username members and i want to know how to mass delete all of them. anyone know how?

[lowandloudinc]

this worked for me thanks...

[lowandloudinc]

did that work? having the same issue.

[lowandloudinc]

i created a new user and DB but still no go. it allows me to do it with other DB.

sending you a pm about the issue so you can see the sensitive info. thanks

could this be the...

[lowandloudinc]

but i did set all the permissions for the database i created.

or do you mean the backup sql file?

[lowandloudinc]

ok im trying to restore a back up of a forum and it will not let me using bigdump. this is the error i get when i try to do it.

Error at the line 12: CREATE DATABASE `dbname` DEFAULT CHARACTER...

[lowandloudinc]

yea thanks , i tried that after i posted and worked....

[lowandloudinc]

ok i seem to have imported the users but on the forum home it shows 0 members. can you tell me why and how can i fix that?

[lowandloudinc]

what i did was just download the tables that are linked to the user table and restored that. then ran impex on the user module and went through smoothly. thanks for the help and i appreciate it.

[lowandloudinc]

i remember a while ago doing it with just the user tables i had from one of my old forum. can you point me in how to do that?...

[lowandloudinc]

i pulled it from the admincp and saved only the user table. dont have ftp access right now. i restored it but the impex wont read it cause of the table prefix issue.

so im trying to see...

[lowandloudinc]

ive looked for that feature and cant seem to find it. downloaded impex but no luck. is it in another download? or tools?

[lowandloudinc]

what are the settings i need to change if i want to try to import from a file instead of a database?

i have a user table i want to import.