Monday, February 17, 2014

Transfer modules between sites




Use MySQL dump, error message:
"The dump file was not created by MySQL Administrator and could contain unsupported syntax. Hence we cannot restore its content. You can override this behavior by enabling "Ignore errors" on the General page."
 Change to command line:
C:\Program Files (x86)\MySQL\MySQL Server 5.0\bin>
mysql -u jiansen -p cnsh_lms <  C:\Users\jiansen\Documents\transferrmodule.sql
find the errors  in input sql files

1.
INSERT INTO `cesei_course_modules` (`course_id`,`module_id`) VALUES 
(4,123);
2.
INSERT INTO `cesei_course_targets` (`course_id`,`target_id`) VALUES
 (123,63);
3.
INSERT INTO `cesei_module_sharing` (`course_id`,`institution_id`) VALUES
(123,1);
4.
INSERT INTO `edu_content` 
(`content_id`,`course_id`,`content_parent_id`,`ordering`,`last_modified`,`revision`,`formatting`,`release_date`,`keywords`,`content_path`,`title`,`text`,`inherit_release_date`) VALUES
(769,123,0,1,'2012-03-15 11:05:11',0,1,'2012-03-15 11:00:00','','','Welcome to CESEI','Welcome to the CESEI LMS.


INSERT INTO `edu_courses` (`course_id`,`member_id`,`created_date`,`title`,`description`,`max_quota`,`max_file_size`,`hide`,`copyright`,`primary_language`,`rss`,`status`) VALUES
(123,1,'2012-03-15','TEST-200: Case Study Test10','test','-2','-3',1,'','en',1,'development');


 update `cnsh_lms`.`edu_courses` SET member_id=1;

  

No comments:

Post a Comment