Moving quizzes from WP site to another
-
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
- The topic ‘Moving quizzes from WP site to another’ is closed to new replies.