Cloning DB with view fails | Report Bugs | Free Forums

All Wordpress Forum requests have been moved to Wordpress Support Forums

 

Avatar

Please consider registering
guest

sp_LogInOut Log In sp_Registration Register

Register | Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_Feed Topic RSS sp_TopicIcon
Cloning DB with view fails
March 6, 2012
5:19 pm
Avatar
Guest

Frown 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.

SmileHowever, it is possible to fix the problem by manually changing the generate database script.

March 7, 2012
8:09 am
Avatar
XCloner! Support
Admin
Forum Posts: 2485
Member Since:
September 26, 2010
sp_UserOfflineSmall Offline

Hi there, care to share the changes you have made to make it work? 🙂

 

Cheers, Ovidiu

Please consider our XCloner Premium Support or making a Donation XCloner.com – Backup Made Easy!
March 7, 2012
1:03 pm
Avatar
Guest

The xCloner generated:

 

DROP table IF EXISTS `jos_jf_languages`;
CREATE 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`;

#
# Dumping data for table `jos_jf_languages`
#
INSERT INTO `jos_jf_languages` VALUES ('1','en-GB','','English (United Kingdom)','en','','1','en','/media/com_joomfish/default/flags/en.gif','','MetaDesc=rnMetaKeys=rnrn','0');
INSERT INTO `jos_jf_languages` VALUES ('2','da-DK','','Dansk','da','','1','da','/media/com_joomfish/default/flags/da.gif','','MetaDesc=rnMetaKeys=rnrn','0');
INSERT INTO `jos_jf_languages` VALUES ('3','de-DE','','Deutch','de','','1','de','/media/com_joomfish/default/flags/de.gif','','MetaDesc=rnMetaKeys=rnrn','0');

 

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)

March 8, 2012
5:59 pm
Avatar
XCloner! Support
Admin
Forum Posts: 2485
Member Since:
September 26, 2010
sp_UserOfflineSmall Offline

Thx, i will look into getting this fixed! Ovidiu

Please consider our XCloner Premium Support or making a Donation XCloner.com – Backup Made Easy!
Forum Timezone: UTC 0

Most Users Ever Online: 867

Currently Online:
13 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

tom_1: 70

mlguru: 33

Django29: 29

D: 21

Andy: 21

Marcus: 20

Member Stats:

Guest Posters: 737

Members: 41536

Moderators: 1

Admins: 1

Forum Stats:

Groups: 3

Forums: 7

Topics: 2517

Posts: 8419

Newest Members:

Nespressokmg Nespressokmg

Moderators: Ovidiu - Support!: 0

Administrators: XCloner! Support: 2485

Quick contact

place

Hi there, my name is Ovidiu Liuta and i support the XCloner! project
XCloner is a Joomla backup component, Wordpress backup plugin and Free website backup tool.
Contact me here!

About company

XCloner.com is a dynamic company focusing on providing backup and recovery solutions for small to medium websites.
We are based in Romania and offer 24/7 support through forums and our private ticket system for Premium users support.

© 2020 XCloner - Website Backup and Restore made simple
All Rights Reserved | Privacy Policy