• Hi,
    How to duplicate quizzes, questions AND results history from one WP site to another ?
    I have both 6.0.4 installed on 2 different sites but MySQL tables have a slightly different structure.
    ie for quizz table
    Source:
    +———————–+——————————+——+—–+———————+—————-+
    | Field | Type | Null | Key | Default | Extra |
    +———————–+——————————+——+—–+———————+—————-+
    | quiz_id | bigint(20) unsigned | NO | PRI | NULL | auto_increment |
    | quiz_title | varchar(255) | NO | | | |
    | quiz_title_filtered | varchar(255) | NO | | NULL | |
    | quiz_description | text | NO | | NULL | |
    | quiz_image_id | bigint(20) unsigned | NO | MUL | 0 | |
    | quiz_type | enum(‘PERSONALITY’,’TRIVIA’) | NO | MUL | TRIVIA | |
    | question_count | smallint(11) unsigned | NO | | 0 | |
    | shuffle_answers | tinyint(1) unsigned | NO | | 0 | |
    | random_questions | tinyint(1) unsigned | NO | | 0 | |
    | random_question_count | smallint(6) unsigned | NO | | 0 | |
    | use_paging | tinyint(1) unsigned | NO | | 0 | |
    | questions_per_page | smallint(6) unsigned | NO | | 0 | |
    | start_immediately | tinyint(1) unsigned | NO | | NULL | |
    | theme | varchar(30) | NO | | | |
    | quiz_meta | longtext | YES | | NULL | |
    | author_id | bigint(20) unsigned | NO | MUL | 0 | |
    | created | datetime | NO | | 0000-00-00 00:00:00 | |
    | modified | datetime | NO | | 0000-00-00 00:00:00 | |
    | collect_data | tinyint(1) unsigned | NO | | 0 | |
    | collect_data_optional | tinyint(1) unsigned | NO | | 0 | |
    | collect_email | tinyint(1) unsigned | NO | | 0 | |
    | collect_name | tinyint(1) unsigned | NO | | 0 | |
    | post_id | bigint(20) unsigned | NO | MUL | 0 | |
    +———————–+——————————+——+—–+———————+—————-+

    Destination
    +————————–+————–+——+—–+———+—————-+
    | Field | Type | Null | Key | Default | Extra |
    +————————–+————–+——+—–+———+—————-+
    | quiz_id | mediumint(9) | NO | PRI | NULL | auto_increment |
    | quiz_name | text | NO | | NULL | |
    | message_before | text | NO | | NULL | |
    | message_after | text | NO | | NULL | |
    | message_comment | text | NO | | NULL | |
    | message_end_template | text | NO | | NULL | |
    | user_email_template | text | NO | | NULL | |
    | admin_email_template | text | NO | | NULL | |
    | submit_button_text | text | NO | | NULL | |
    | name_field_text | text | NO | | NULL | |
    | business_field_text | text | NO | | NULL | |
    | email_field_text | text | NO | | NULL | |
    | phone_field_text | text | NO | | NULL | |
    | comment_field_text | text | NO | | NULL | |
    | email_from_text | text | NO | | NULL | |
    | question_answer_template | text | NO | | NULL | |
    | leaderboard_template | text | NO | | NULL | |
    | system | int(11) | NO | | NULL | |
    | randomness_order | int(11) | NO | | NULL | |
    | loggedin_user_contact | int(11) | NO | | NULL | |
    | show_score | int(11) | NO | | NULL | |
    | send_user_email | int(11) | NO | | NULL | |
    | send_admin_email | int(11) | NO | | NULL | |
    | contact_info_location | int(11) | NO | | NULL | |
    | user_name | int(11) | NO | | NULL | |
    | user_comp | int(11) | NO | | NULL | |
    | user_email | int(11) | NO | | NULL | |
    | user_phone | int(11) | NO | | NULL | |
    | admin_email | text | NO | | NULL | |
    | comment_section | int(11) | NO | | NULL | |
    | question_from_total | int(11) | NO | | NULL | |
    | total_user_tries | int(11) | NO | | NULL | |
    | total_user_tries_text | text | NO | | NULL | |
    | certificate_template | text | NO | | NULL | |
    | social_media | int(11) | NO | | NULL | |
    | social_media_text | text | NO | | NULL | |
    | pagination | int(11) | NO | | NULL | |
    | pagination_text | text | NO | | NULL | |
    | timer_limit | int(11) | NO | | NULL | |
    | quiz_stye | text | NO | | NULL | |
    | question_numbering | int(11) | NO | | NULL | |
    | quiz_settings | text | NO | | NULL | |
    | theme_selected | text | NO | | NULL | |
    | last_activity | datetime | NO | | NULL | |
    | require_log_in | int(11) | NO | | NULL | |
    | require_log_in_text | text | NO | | NULL | |
    | limit_total_entries | int(11) | NO | | NULL | |
    | limit_total_entries_text | text | NO | | NULL | |
    | scheduled_timeframe | text | NO | | NULL | |
    | scheduled_timeframe_text | text | NO | | NULL | |
    | disable_answer_onselect | int(11) | NO | | NULL | |
    | ajax_show_correct | int(11) | NO | | NULL | |
    | quiz_views | int(11) | NO | | NULL | |
    | quiz_taken | int(11) | NO | | NULL | |
    | deleted | int(11) | NO | | NULL | |
    +————————–+————–+——+—–+———+—————-+

    So, i don’t know how to duplicate datas to the new database…
    Any help would be greatly appreciated.

    Thanks,
    Phil

Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
  • The topic ‘Moving quizzes from WP site to another’ is closed to new replies.