I have just imported bbvsf_bp_xprofile_data.sql into my new site. All is great except that the user ID numbers are wrong. I manually changed all of the tables that show me as ID#2436 to ID#2, and it now puts the correct information in my profile but there were probably 15 or 20 instances that had to be changed.
I need to do this with 139 of my members. Instead of doing the fields one at a time, is there a way to "find and replace all" within the phpMyAdmin tables?