Adsense
Popular Posts
- jQuery autocomplete scroll bar for dropdown menu
- JavaScript Arrays and Associate Arrays
- mod_auth_cas.so error: undefined symbol: SSL_connect
- Design date and signature box in Latex
- Install APXS in Redhat Linux
- JavaScript, remove trailing insignificant zeros after toFixed function
- jQuery, toggle the display
- Difference between state and props in React
- Set Windows path command line
- super(props) in React
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;
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment