Moving the SF wiki

>> 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/)
• 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')

• create another account for editing (e.g. stefanS)
• close the wiki - so no one else can sign up