Support » Fixing WordPress » XOOPS to WP

  • Hi All

    I am attempting to move all my users from my site (currently using XOOPS) to WPMU 2.7.1

    I have matched up the proper tables from the db but with my limited sql ability I am stumped about how to convert the unix timestamp from user_regdate in XOOPS to the date format used in WPMU.

    I am simply using the sql statement below in the myPHPadmin sql window.

    It looks like using FROM_UNIXTIME might be a solution but I am unsure how to use it within the sql statement below.

    SELECT uid AS ‘ID’, uname AS ‘login_name’, uname AS ‘user_nicename’, pass AS ‘user_pass’, email AS ‘user_email’, url AS ‘user_url’, user_regdate AS ‘user_registered’, uname AS ‘display_name’ FROM mcm_users WHERE 1

    Any help would be appreciated.

    Thanks Foz

Viewing 3 replies - 1 through 3 (of 3 total)
Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘XOOPS to WP’ is closed to new replies.