Difference between revisions of "User:Pierre"

From ArchWiki
Jump to: navigation, search
(FluxBB 1.4 Upgrade)
(FluxBB 1.4 Upgrade)
Line 17: Line 17:
 
** just import backup from above into fluxbb
 
** just import backup from above into fluxbb
 
* optional: remove fluxbb_ prefix from tables (adjust config.php)
 
* optional: remove fluxbb_ prefix from tables (adjust config.php)
 +
<pre>RENAME TABLE fluxbb_bans TO bans;
 +
RENAME TABLE fluxbb_categories TO categories;
 +
RENAME TABLE fluxbb_censoring TO censoring;
 +
RENAME TABLE fluxbb_config TO config;
 +
RENAME TABLE fluxbb_forum_perms TO forum_perms;
 +
RENAME TABLE fluxbb_forums TO forums;
 +
RENAME TABLE fluxbb_groups TO groups;
 +
RENAME TABLE fluxbb_online TO online;
 +
RENAME TABLE fluxbb_posts TO posts;
 +
RENAME TABLE fluxbb_ranks TO ranks;
 +
RENAME TABLE fluxbb_reports TO reports;
 +
RENAME TABLE fluxbb_search_cache TO search_cache;
 +
RENAME TABLE fluxbb_search_matches TO search_matches;
 +
RENAME TABLE fluxbb_search_words TO search_words;
 +
RENAME TABLE fluxbb_subscriptions TO subscriptions;
 +
RENAME TABLE fluxbb_topics TO topics;
 +
RENAME TABLE fluxbb_users TO users;</pre>
 
* Deny access to cache, include, lang, plugins, config.php, header.php, footer.php
 
* Deny access to cache, include, lang, plugins, config.php, header.php, footer.php
 
* Add password-protected access to db_update.php, install.php
 
* Add password-protected access to db_update.php, install.php

Revision as of 13:52, 15 July 2010

https://users.archlinux.de/~pierre/

L10n-de Todo

FluxBB 1.4 Upgrade

  • Password-protect access to bbs
  • Backup database phpbb
  • move current bbs.archlinux.org dir and clone new git repo
  • copy avatars to new dir
  • adjust config.php
    • don't forget to add arch_navbar and arch_home vars
  • copy phpbb database to fluxbb
    • permissions for fluxbb user might need to be adjusted
    • just import backup from above into fluxbb
  • optional: remove fluxbb_ prefix from tables (adjust config.php)
RENAME TABLE fluxbb_bans TO bans;
RENAME TABLE fluxbb_categories TO categories;
RENAME TABLE fluxbb_censoring TO censoring;
RENAME TABLE fluxbb_config TO config;
RENAME TABLE fluxbb_forum_perms TO forum_perms;
RENAME TABLE fluxbb_forums TO forums;
RENAME TABLE fluxbb_groups TO groups;
RENAME TABLE fluxbb_online TO online;
RENAME TABLE fluxbb_posts TO posts;
RENAME TABLE fluxbb_ranks TO ranks;
RENAME TABLE fluxbb_reports TO reports;
RENAME TABLE fluxbb_search_cache TO search_cache;
RENAME TABLE fluxbb_search_matches TO search_matches;
RENAME TABLE fluxbb_search_words TO search_words;
RENAME TABLE fluxbb_subscriptions TO subscriptions;
RENAME TABLE fluxbb_topics TO topics;
RENAME TABLE fluxbb_users TO users;
  • Deny access to cache, include, lang, plugins, config.php, header.php, footer.php
  • Add password-protected access to db_update.php, install.php
  • killall php-cgi
  • run update script
  • re-enable public access