Navigation:
all content © by Mario Emmenlauer.
|
Install Wordpress on Tanabata* Taken from the instructions here: http://codex.wordpress.org/Installing_WordPress General mySQL commands# list mySQL databases mysql --user='root' --password -e "SHOW DATABASES;" # show all mySQL users: mysql --user='root' --password -e "SELECT User FROM mysql.user;" # backup mySQL databases: mysqldump --user='root' --password fabelwerk_wp_A | gzip -9 > /tmp/fabelwerk_wp_A.sql.gz # change a user password: mysql --user='root' --password -e "SET PASSWORD FOR 'fabelwerk_wp_A'@'localhost' = PASSWORD('<put password here>');" # DANGEROUS: drop databases that are not used anymore: #mysql --user='root' --password -e "DROP DATABASE fabelwerk_wp_A;" For the Page fabelwerk.de# create a new mysql database: mysql --user='root' --password -e "CREATE DATABASE fabelwerk_wp_A DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;" # create a user for this database: mysql --user='root' --password -e "CREATE USER 'fabelwerk_wp_A'@'localhost' IDENTIFIED BY '<put password here>';" # grant required permissions for table: mysql --user='root' --password -e "GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, LOCK TABLES, CREATE TEMPORARY TABLES ON fabelwerk_wp_A.* TO 'fabelwerk_wp_A'@'localhost';" From the shell, continue with: ssh tanabata cd /home/www/de.fabelwerk/pages/ wget --no-check-certificate https://wordpress.org/wordpress-4.0.1.tar.gz # the next two steps have been used only for validation: #tar -xzf wordpress-4.0.1.tar.gz #mv wordpress /tmp/wordpress-4.0.1 # get the backup from Steffen: mkdir -p /home/www/de.fabelwerk/pages/tmp && cp -pr /home/www/de.fabelwerk/pages/root/wordpress /home/www/de.fabelwerk/pages/tmp/wordpress cd /home/www/de.fabelwerk/pages/tmp/wordpress/ mkdir -p backwpup_2484f5_2014-11-24_15-10-03 cd ./backwpup_2484f5_2014-11-24_15-10-03/ tar -xzf ../backwpup_2484f5_2014-11-24_15-10-03.tar.gz # copy the backup over the wordpress-4.0.1 installation directory: rm -fr /home/www/de.fabelwerk/pages/wordpress-4.0.1 cp -pr /home/www/de.fabelwerk/pages/tmp/wordpress/backwpup_2484f5_2014-11-24_15-10-03 /home/www/de.fabelwerk/pages/wordpress-4.0.1 # restore the database: mysql --user='root' --password -e "DROP DATABASE fabelwerk_wp_A;" mysql --user='root' --password -e "CREATE DATABASE fabelwerk_wp_A DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;" mysql --user='root' --password -e "GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, LOCK TABLES, CREATE TEMPORARY TABLES ON fabelwerk_wp_A.* TO 'fabelwerk_wp_A'@'localhost';" cp /home/www/de.fabelwerk/pages/tmp/wordpress/backwpup_2484f5_2014-11-24_15-10-03/wp209.sql /tmp/wp209.sql perl -pi -e 's@/www.fabelwerk.de/neue-homepage@/data.fabelwerk.de/neue-homepage@g' /tmp/wp209.sql perl -pi -e 's@/fabelwerk.de/neue-homepage@/data.fabelwerk.de/neue-homepage@g' /tmp/wp209.sql perl -pi -e 's@/www.fabelwerk.de/Homepage-Dateien@/data.fabelwerk.de/Homepage-Dateien@g' /tmp/wp209.sql perl -pi -e 's@/fabelwerk.de/Homepage-Dateien@/data.fabelwerk.de/Homepage-Dateien@g' /tmp/wp209.sql perl -pi -e 's@127.0.0.1@www.fabelwerk.de@g' /tmp/wp209.sql perl -pi -e 's@Applications/AMPPS/www/@@g' /tmp/wp209.sql perl -pi -e 's@\\\\/wp\\\\/@\\\\/@g;s@/wp([^a-zA-Z0-9-])@$1@g' /tmp/wp209.sql mysql --user='root' --password 'fabelwerk_wp_A' < /tmp/wp209.sql # adjust the config: cd /home/www/de.fabelwerk/pages/wordpress-4.0.1/ perl -pi -e "s@'DB_NAME', '.*?'@'DB_NAME', 'fabelwerk_wp_A'@g" wp-config.php perl -pi -e "s@'DB_USER', '.*?'@'DB_USER', 'fabelwerk_wp_A'@g" wp-config.php perl -pi -e "s@'DB_COLLATE', '.*?'@'DB_COLLATE', 'utf8_unicode_ci'@g" wp-config.php # compare the files from backup and original: diff -wBdqr /tmp/wordpress-4.0.1/ ./ rm -f backwpup_readme.txt rm -f liesmich.html rm -f wp209.sql # set up for apache web server: ln -s wordpress-4.0.1 /home/www/de.fabelwerk/pages/wordpress-current sudo chown -R www-data:www-data /home/www/de.fabelwerk/pages/wordpress-4.0.1 sudo chown -R www-data:www-data /home/www/de.fabelwerk/pages/wordpress-current |