Difference between revisions of "Moving the SF wiki"
From stgo
(Created page with ">> return to Cedeus IDE ---- copy existing backup: * copy from SF the zip of the image folder * copy from SF the tar of the MySQL DB dump then: * install mediawiki (now...") |
|||
Line 7: | Line 7: | ||
then: | then: | ||
− | * install mediawiki (now under var/www/html/) | + | * install mediawiki (now under var/www/html/) => guide under: http://www.mediawiki.org/wiki/Manual:Installing_MediaWiki |
+ | *: Note, if there is a already a MediaWiki installation, one needs to use a different DB, see: | ||
* copy the images to the image folder | * copy the images to the image folder | ||
* apply the sql dump file to mediawiki db using the "import" option | * apply the sql dump file to mediawiki db using the "import" option |
Revision as of 16:01, 20 June 2014
>> return to Cedeus IDE
copy existing backup:
- copy from SF the zip of the image folder
- copy from SF the tar of the MySQL DB dump
then:
- install mediawiki (now under var/www/html/) => guide under: http://www.mediawiki.org/wiki/Manual:Installing_MediaWiki
- Note, if there is a already a MediaWiki installation, one needs to use a different DB, see:
- copy the images to the image folder
- apply the sql dump file to mediawiki db using the "import" option
- run:
php maintenance/update.php
- perhaps reset the passwords using a script SQL (http://kb.siteground.com/how_to_reset_my_mediawiki_admin_password/)
UPDATE user SET user_password = MD5( CONCAT( user_id, ‘-’, MD5( ‘NEWPASS‘ ) ) ) WHERE user_id =1(the ID is the user id) or use
php changePassword.php --user=example --password=newpassword
- open up the wiki (create account + edit rights)
- create a new (admin) user
- change this user rights to be a sysop:
- first find the users ID:
select user_id from user where user_name = 'Whatever';
- If the user id is found (admin has usually '1') do:
INSERT INTO user_groups (ug_user, ug_group) VALUES ('1', 'bureaucrat');
INSERT INTO user_groups (ug_user, ug_group) VALUES ('1', 'sysop')
- first find the users ID:
- create another account for editing (e.g. stefanS)
- close the wiki - so no one else can sign up