Importing existing MySQL database

Hi, I have a member MySQL database with many fields and it’s taking my programmer forever to get it to the “import” stage… is this normal? I would assume that if you create the same fields in S2Member the import would go fairly smoothly.

So you’re importing with a database tool?

If you have the new WordPress running, you can export s2Member’s options and the WordPress users from the old one, and import them into the new one using these tools: [hilite path]Dashboard -› s2Member® -› Import/Export[/hilite]

Those tools don’t migrate WordPress, though.

Hi, Cristian, the problem is that the database is not a WordPress user database, it’s a MySql database that was used within a php program.

Ah, I see. So you’re migrating from another software. Knowledge Base » How to Migrate to s2Member Pro from Other Software

You’d just have to create the profile fields you need the user profile to have, create the CSV file with the users, and use s2Member’s import tool.

[hilite path]Dashboard -› s2Member® -› General Options -› Registration/Profile Fields[/hilite]
Knowledge Base » Import (or Mass Update) Users

For the CSV file, it’s good to create a user manually from the dashboard, with all the custom profile fields having a value, and export with s2Member so you get the right CSV format. Then add rows for the users and import. [hilite path]Dashboard -› s2Member® -› Import/Export -› User/Member Exportation[/hilite]

I recommend that you use OpenOffice Calc to edit the CSV file.

Thank you, Cristian. I really appreciate it.

Cristian, if I have trouble doing this, do you provide a paid service where someone can help me get it imported? Thanks.

We don’t offer that service, but you can post the job in a freelancers site like jobs.wordpress.net, odesk.com or elance.com.

I know one s2Member user that hired a developer for some customizations, that did a good job and she’s recommending him. This is his site if you want to try him: http://krumch.com/tag/s2member/

Thanks, Cristian!

Glad to help. :)