MyBB Community Forums

Full Version: Import Users [Please Help!]
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
So I currently have a list of users in plain text. , like this:
user_id,user_age,user_town,user_nick,user_regip,addedtomap,user_email,user_gender,isModerator,user_password,user_updateip,hhscore_score,user_postcode,postcode_state,user_lastLogin,user_statusText,user_info_public,user_regDateTime,hhscore_testDate,user_latitude_min,user_latitude_max,user_longitude_min,user_info_approved,user_longitude_max,user_statusFlagged,user_updateDateTime,user_statusDateTime

5,NA,NEWTOWN,miserable_shit,203.2.218.132,1,[email protected],m,0,ae5728815eff76b748cddab86f926642c5d168dd,203.2.218.132,13,2042,NSW,2010-09-10 16:17:24,schadenfreude,yes,2010-09-08 14:12:51,2010-09-08 15:40:04,-33.9084,-33.891,151.167,no,151.189,NULL,2010-09-08 16:48:48,2010-09-08 16:48:48
Is there a way to save it as sql and import it?
format it to match your current SQL type and file type and then import the data in phpmyadmin.