Description:
database is myisam. when attempting to back up/restore a database from one mysql 5.0.15 server to another mysql 5.0.15 server using mysql administrator 1.1.4, the following lines are reported.
also, only tables are displayed on the restore content tab. the backup functions list views as well as tables.
Warning: Do not know how to handle this statement at line 2147:
CREATE ALGORITHM=UNDEFINED DEFINER=`webmaster`@`%` SQL SECURITY DEFINER VIEW `v_bldg` AS select `building`.`buildingId` AS `buildingId`,`building`.`title` AS `title`,`building`.`about` AS `about`,`building`.`outdoors` AS `outdoors`,`building`.`hours` AS `hours`,`building`.`photo` AS `photo`,`building`.`directions` AS `directions`,`building`.`main` AS `main`,`building`.`hcInfo` AS `hcInfo`,`building_types`.`typeId` AS `typeId`,`types`.`type` AS `type`,`types`.`typeSingular` AS `typeSingular`,`campus`.`name` AS `c_name`,`entrance`.`name` AS `e_id`,`cross_street`.`name` AS `name`,`orderbuildings`.`orderNumber` AS `orderNumber`,`building`.`mainClipId` AS `mainClipId`,`building_building_info`.`buildingInfoId` AS `buildingInfoId`,`building_info`.`title` AS `bi_title`,`building_info`.`description` AS `bi_desc`,`clips`.`file` AS `bi_file`,`clips`.`alt` AS `bi_alt`,`clip_types`.`type` AS `bi_type`,`clip_types`.`folder` AS `bi_folder` from ((((((((((`building` left join `campus` on((`campus`.`campusId` = `building`.`campusId`))) left join `building_types` on((`building_types`.`buildingId` = `building`.`buildingId`))) left join `types` on((`types`.`typeId` = `building_types`.`typeId`))) left join `entrance` on((`building`.`entranceId` = `entrance`.`entranceId`))) left join `cross_street` on((`building`.`streetId` = `cross_street`.`streetId`))) left join `orderbuildings` on((`orderbuildings`.`buildingId` = `building`.`buildingId`))) left join `building_building_info` on((`building_building_info`.`buildingId` = `building`.`buildingId`))) left join `building_info` on((`building_info`.`buildingInfoId` = `building_building_info`.`buildingInfoId`))) left join `clips` on((`clips`.`clipId` = `building_info`.`clipId`))) left join `clip_types` on((`clip_types`.`clipTypeId` = `clips`.`clipTypeId`)));
Ignoring this statement. Please file a bug-report including the statement if this statement should be recognized.
Warning: Do not know how to handle this statement at line 2155:
CREATE ALGORITHM=UNDEFINED DEFINER=`webmaster`@`%` SQL SECURITY DEFINER VIEW `v_building` AS select `building`.`buildingId` AS `buildingId`,`building`.`title` AS `title`,`building`.`about` AS `about`,`building`.`outdoors` AS `outdoors`,`building`.`hours` AS `hours`,`building`.`photo` AS `photo`,`building`.`directions` AS `directions`,`building`.`main` AS `main`,`building`.`hcInfo` AS `hcInfo`,`building_types`.`typeId` AS `typeId`,`types`.`type` AS `type`,`types`.`typeSingular` AS `typeSingular`,`campus`.`name` AS `c_name`,`entrance`.`name` AS `e_id`,`cross_street`.`name` AS `name`,`orderbuildings`.`orderNumber` AS `orderNumber`,`clips`.`file` AS `file`,`clips`.`clipId` AS `clipId`,`clips`.`alt` AS `alt`,`clips`.`clipTypeId` AS `clipTypeId`,`clip_types`.`type` AS `clip_type`,`clip_types`.`folder` AS `folder`,`building`.`mainClipId` AS `mainClipId` from ((((((((`building` left join `campus` on((`campus`.`campusId` = `building`.`campusId`))) left join `building_types` on((`building_types`.`buildingId` = `building`.`buildingId`))) left join `types` on((`types`.`typeId` = `building_types`.`typeId`))) left join `entrance` on((`building`.`entranceId` = `entrance`.`entranceId`))) left join `cross_street` on((`building`.`streetId` = `cross_street`.`streetId`))) left join `orderbuildings` on((`orderbuildings`.`buildingId` = `building`.`buildingId`))) left join `clips` on((`building`.`mainClipId` = `clips`.`clipId`))) left join `clip_types` on((`clips`.`clipTypeId` = `clip_types`.`clipTypeId`)));
Ignoring this statement. Please file a bug-report including the statement if this statement should be recognized.
Warning: Do not know how to handle this statement at line 2163:
CREATE ALGORITHM=UNDEFINED DEFINER=`webmaster`@`%` SQL SECURITY DEFINER VIEW `v_clips` AS select `clips`.`clipId` AS `clipId`,`clips`.`clipTypeId` AS `clipTypeId`,`clips`.`file` AS `file`,`clips`.`alt` AS `alt`,`clip_types`.`type` AS `type`,`clip_types`.`folder` AS `folder` from (`clips` join `clip_types` on((`clips`.`clipTypeId` = `clip_types`.`clipTypeId`)));
Ignoring this statement. Please file a bug-report including the statement if this statement should be recognized.
Warning: Do not know how to handle this statement at line 2171:
CREATE ALGORITHM=UNDEFINED DEFINER=`webmaster`@`%` SQL SECURITY DEFINER VIEW `v_thumbs` AS select `clip_types`.`type` AS `type`,`clip_types`.`folder` AS `folder`,`clips`.`file` AS `file`,`clips`.`alt` AS `alt`,`clips`.`thumbnail` AS `thumbnail`,`clips`.`thumb_alt` AS `thumb_alt`,`building_info_thumb`.`clipId` AS `clipId`,`building_info_thumb`.`buildingInfoId` AS `buildingInfoId` from ((`building_info_thumb` join `clips` on((`building_info_thumb`.`clipId` = `clips`.`clipId`))) join `clip_types` on((`clips`.`clipTypeId` = `clip_types`.`clipTypeId`)));
Ignoring this statement. Please file a bug-report including the statement if this statement should be recognized.
Warning: Do not know how to handle this statement at line 2179:
CREATE ALGORITHM=UNDEFINED DEFINER=`webmaster`@`%` SQL SECURITY DEFINER VIEW `v_top_bar` AS select `building_building_info`.`buildingId` AS `buildingId`,`building_building_info`.`buildingInfoId` AS `buildingInfoId`,`building_info`.`title` AS `title`,`building_info`.`description` AS `description`,`clips`.`file` AS `file`,`clips`.`alt` AS `alt`,`clips`.`thumbnail` AS `thumbnail`,`clip_types`.`type` AS `type`,`clip_types`.`folder` AS `folder` from (((`building_building_info` left join `building_info` on((`building_building_info`.`buildingInfoId` = `building_info`.`buildingInfoId`))) left join `clips` on((`clips`.`clipId` = `building_info`.`clipId`))) left join `clip_types` on((`clips`.`clipTypeId` = `clip_types`.`clipTypeId`))) order by `building_building_info`.`buildingId`,`building_info`.`title`;
Ignoring this statement. Please file a bug-report including the statement if this statement should be recognized.
How to repeat:
attempt import of backup sql script from original server. tried with several combinations of backup options (flush read locks, complete backup, etc). all produce same results.
Suggested fix:
add view handling to the restore functions.
