Difference between revisions of "Moving the SF wiki"

From stgo
Jump to: navigation, search
(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:

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')
  • create another account for editing (e.g. stefanS)
  • close the wiki - so no one else can sign up