Projekt Caros Gruppenblog - Revision history

Joachim: /* Test Site */

2014-03-23T12:16:21Z

Test Site

← Older revision		Revision as of 12:16, 23 March 2014
Line 144:		Line 144:
	== Test Site ==		== Test Site ==

	created a test site wptest exactly like wordpress, just without the content and users.		I created a test site wptest exactly like wordpress, just without the content and users.

			* copy wordpress directory to wptest in document root
			* delete the copied wp-config.php
			* copy wordpress.conf to wptest.conf in apache2's conf.d
			* create new mysql user and database wptest
			* add new ftp user wptest
			* adjust backup cron script and add it to crontab of wptest
			* restart apache (reload did not work for static pages)
			* go through the setup pages of wptest page
			* activate and configure the plugins

	https://banzhaf.chickenkiller.com/wptest		https://banzhaf.chickenkiller.com/wptest

2014-03-23T12:06:52Z

FTP Install

← Older revision		Revision as of 12:06, 23 March 2014
Line 85:		Line 85:
	* User angelegt:		* User angelegt:
	useradd -c 'wordpress ftp user' -d /srv/www/htdocs/wordpress/ -g www wordpress		useradd -c 'wordpress ftp user' -d /srv/www/htdocs/wordpress/ -g www wordpress
	* Passwort setzen (Caros PW!)		* Passwort setzen (Caros PW, damit sie die Updates machen kann!)
	passwd wordpress		passwd wordpress
	* vsftpd start		* vsftpd start

2014-03-23T12:04:50Z

← Older revision		Revision as of 12:04, 23 March 2014
Line 1:		Line 1:
	= Caros Frauengruppenblog =		= Caros Frauengruppenblog =

	~~Ich~~ hab mal wordpress installiert, ~~und zwar~~ so:		Caro und ein paar Freundinnen möchten gern einen Blog zum privaten Meinungsaustausch nutzen.
			Daher hab ich mal wordpress installiert:

			https://banzhaf.chickenkiller.com/wordpress

			Da ich auf diesen Blog keinen Zugriff habe, gibt es noch einen zweiten für Tests:

			https://banzhaf.chickenkiller.com/wptest

			Installiert hab ich die so:

	== Mysql Config ==		== Mysql Config ==

2014-03-23T11:39:19Z

Backup

← Older revision		Revision as of 11:39, 23 March 2014
Line 132:		Line 132:
	user=wordpress		user=wordpress
	password=the-password		password=the-password

			== Test Site ==

			created a test site wptest exactly like wordpress, just without the content and users.

			https://banzhaf.chickenkiller.com/wptest

2014-03-23T11:35:47Z

Backup Script

← Older revision		Revision as of 11:35, 23 March 2014
Line 112:		Line 112:

	#!/bin/bash		#!/bin/bash

			DB=wordpress
	MOUNT_DIR=/net/qnap/BackupJob4		MOUNT_DIR=/net/qnap/BackupJob4
	BACKUP_DIR=$MOUNT_DIR/~~ladiesroom~~		BACKUP_DIR="$MOUNT_DIR/$DB"

	if ! mount \| grep -q "$MOUNT_DIR"; then		if ! mount \| grep -q "$MOUNT_DIR"; then
Line 120:		Line 121:
	fi		fi

	if ! mysqldump ~~wordpress~~ \| gzip >$BACKUP_DIR/backup_`date '+%F-%H-%M-%S'`.sql.gz; then		if ! mysqldump "$DB" \| gzip >$BACKUP_DIR/backup_`date '+%F-%H-%M-%S'`.sql.gz; then
	echo "$0: backup failed"		echo "$0: backup failed"
	fi		fi

2014-03-23T11:18:31Z

Wordpress Install

← Older revision		Revision as of 11:18, 23 March 2014
Line 55:		Line 55:
	mysql -p wordpress < backup-file.sql		mysql -p wordpress < backup-file.sql
	* Alternativ neue Installation starten		* Alternativ neue Installation starten
	** https://banzhaf.chickenkiller.com~~:444~~/wordpress		** https://banzhaf.chickenkiller.com/wordpress
	** Name und Kurzbeschreibung des Blogs		** Name und Kurzbeschreibung des Blogs
	** Admin User		** Admin User

2014-03-23T11:03:05Z

Mysql Config

← Older revision		Revision as of 11:03, 23 March 2014
Line 8:		Line 8:
	*** https://banzhaf.chickenkiller.com/phpMyAdmin		*** https://banzhaf.chickenkiller.com/phpMyAdmin
	*** Anmelden als root		*** Anmelden als root
	*** Link "~~Rechte~~"		*** Link "Benutzer"
	*** Link "Neuen Benutzer hinzufügen"		*** Link "Neuen Benutzer hinzufügen"
	*** Formular ausfüllen		*** Formular ausfüllen

2014-03-23T11:01:40Z

Mysql Config

← Older revision		Revision as of 11:01, 23 March 2014
Line 6:		Line 6:
	* In einem Mysql System (muß nicht der Webserver sein) einen User mit Datenbank anlegen		* In einem Mysql System (muß nicht der Webserver sein) einen User mit Datenbank anlegen
	** geht ganz einfach mit phpMyAdmin		** geht ganz einfach mit phpMyAdmin
	*** https://banzhaf.chickenkiller.com~~:444~~/phpMyAdmin		*** https://banzhaf.chickenkiller.com/phpMyAdmin
	*** Anmelden als root		*** Anmelden als root
	*** Link "Rechte"		*** Link "Rechte"

2014-03-17T14:19:47Z

Backup

← Older revision		Revision as of 14:19, 17 March 2014
Line 103:		Line 103:
	== Backup ==		== Backup ==

	Make daily backup now		Make daily backup now. Currently backup size is ~30k (-> 10MB/year).

	=== Crontab ===		=== Crontab ===

2014-03-17T14:18:19Z

Web Address Change

← Older revision		Revision as of 14:18, 17 March 2014
Line 100:		Line 100:

	https://banzhaf.chickenkiller.com/wordpress		https://banzhaf.chickenkiller.com/wordpress

			== Backup ==

			Make daily backup now

			=== Crontab ===

			44 04 * * * $HOME/backup.sh

			=== Backup Script ===

			#!/bin/bash

			MOUNT_DIR=/net/qnap/BackupJob4
			BACKUP_DIR=$MOUNT_DIR/ladiesroom

			if ! mount \| grep -q "$MOUNT_DIR"; then
			mount "$MOUNT_DIR"
			fi

			if ! mysqldump wordpress \| gzip >$BACKUP_DIR/backup_`date '+%F-%H-%M-%S'`.sql.gz; then
			echo "$0: backup failed"
			fi

			=== Mysql Config ===

			~/.my.cnf contains these lines:

			[mysqldump]
			user=wordpress
			password=the-password