The free forums are no longer in use. It remains available as read-only archive.
5:19 pm
I have tried using the xCloner tool on a database with a view defined. It is treated as a table, which means that restoring fails. Notice, I did not use mysqldump but I used instead the xCloner tools internal implementation.
However, it is possible to fix the problem by manually changing the generate database script.
1:03 pm
The xCloner generated:
Â
Â
which I changed to:
Â
DROP table IF EXISTS `jos_jf_languages`;
(placed in the beginning of the file)
Â
CREATE OR REPLACE ALGORITHM=UNDEFINED DEFINER=`mortenm`@`%` SQL SECURITY DEFINER VIEW `jos_jf_languages` AS select `l`.`lang_id` AS `lang_id`,`l`.`lang_code` AS `lang_code`,`l`.`title` AS `title`,`l`.`title_native` AS `title_native`,`l`.`sef` AS `sef`,`l`.`description` AS `description`,`l`.`published` AS `published`,`l`.`image` AS `image`,`lext`.`image_ext` AS `image_ext`,`lext`.`fallback_code` AS `fallback_code`,`lext`.`params` AS `params`,`lext`.`ordering` AS `ordering` from (`jos_languages` `l` left join `jos_jf_languages_ext` `lext` on((`l`.`lang_id` = `lext`.`lang_id`))) order by `lext`.`ordering`;
(placed in the end of the file)
1 Guest(s)