Difference between revisions of "User:Pierre"

From ArchWiki
Jump to: navigation, search
(dbscripts package pool migration)
 
(4 intermediate revisions by 2 users not shown)
Line 1: Line 1:
https://users.archlinux.de/~pierre/
+
https://pierre-schmitz.com/
 
 
==L10n-de Todo==
 
* Rewrite
 
** [[ArchWiki Tutorial (Deutsch)]]
 
** [[Getting Involved (Deutsch)]]
 
 
 
==FluxBB 1.4 Upgrade==
 
* done :-)
 
===Post update tasks===
 
* write a script to check and fix database integrity
 
<pre>
 
update topics a set a.first_post_id=(SELECT MIN(posts.id) FROM posts WHERE posts.topic_id=a.id);
 
update topics a set a.last_post_id=(SELECT MAX(posts.id) FROM posts WHERE posts.topic_id=a.id);
 
update topics set first_post_id=0, last_post_id=0, last_poster=null, num_views=0, num_replies=0 where moved_to is not null;
 
update topics set num_replies=(select count(id)-1 from posts where topic_id=topics.id) where topics.moved_to is null;
 
update forums set num_topics=(select count(id) from topics where forum_id=forums.id);
 
update forums set num_posts=(select sum(num_replies)+count(topics.id) from topics where forum_id=forums.id and topics.moved_to is null);
 
</pre>
 
* if everything is fine remove phpbb db
 
* why are there two fluxbb users
 
* why is the db that slow?
 
* create backup script
 
 
 
==dbscripts package pool migration==
 
* sigurd
 
** install -d -o root -g tusers /srv/ftp/packages/community/{i686,x86_64,any}
 
* gerolde
 
** install -d -o ftp -g ftp-extra /srv/ftp/packages/arch/{i686,x86_64,any}
 
** rsync the packages/community dir from sigurd
 
* check if mirrors sync correctly
 
* review rsync modules
 
* git pull on sigurd and gerolde
 
** check cron jobs
 
* send announcement to arch-dev-public and aur-general
 

Latest revision as of 21:30, 13 December 2011

https://pierre-schmitz.com/