Drupalcon Paris Session: Install, Backup, Upgrade, Migrate.

Drupalcon Paris Session: How to install, backup, upgrade, and migrate.

moving sites from paris1.drupaladmin.net to paris2.drupaladmin.net

paris1.drupaladmin.net - 66.146.206.202
paris2.drupaladmin.net - 66.146.206.205

***********************************************************************************
Install Drupal 6.12
http://ftp.drupal.org/files/projects/drupal-6.12.tar.gz

cd /etc/apache2/sites-available/
wget http://drupaladmin.net/sites/default/files/presentations/apache-template
cat apache-template | sed 's/$DOMAIN/paris1.drupaladmin.net/g' > paris1.drupaladmin.net

cd /var/www/sites
mkdir paris1.drupaladmin.net
mkdir paris1.drupaladmin.net/htdocs
a2ensite paris1.drupaladmin.net
/etc/init.d/apache2 reload

mysql -u root -p

CREATE DATABASE `dbparis1`;
CREATE USER 'userparis1'@'localhost';
SET PASSWORD FOR 'userparis1'@'localhost' = PASSWORD('passwordparis1');
GRANT ALL PRIVILEGES ON `dbparis1`.* TO 'userparis1'@'localhost';
quit

Once the web server is finsihed and has your domain enabled, we can install Drupal.

cd /var/www/sites/paris1.drupaladmin.net/htdocs
wget drupal http://ftp.drupal.org/files/projects/drupal-6.12.tar.gz
tar -zxvf drupal-6.12.tar.gz
rm drupal-6.12.tar.gz
cd drupal-6.12
mv .htaccess ..;mv * ..; cd ..
rm -r drupal-6.12

Make a backup coppy of default.settings.php and allow write access to it. Create a files directory to store files for the site and provide write access.

cp /var/www/sites/paris1.drupaladmin.net/htdocs/sites/default/default.settings.php /var/www/sites/paris1.drupaladmin.net/htdocs/sites/default/settings.php
chmod a+w /var/www/sites/paris1.drupaladmin.net/htdocs/sites/default/settings.php

mkdir /var/www/sites/paris1.drupaladmin.net/htdocs/sites/all/modules
mkdir /var/www/sites/paris1.drupaladmin.net/htdocs/sites/all/themes

mkdir /var/www/sites/paris1.drupaladmin.net/htdocs/sites/default/files
chmod a+w /var/www/sites/paris1.drupaladmin.net/htdocs/sites/default/files

If you open Drupal in a web browser you can enter the database name, user, and pass. After installation issue these commands to secure your site.

chmod a-w /var/www/sites/paris1.drupaladmin.net/htdocs/sites/default/
chmod a-w /var/www/sites/paris1.drupaladmin.net/htdocs/sites/default/settings.php

Drupal requires a cronjob to be ran freuqntly to reindex the site.

crontab -e
45 * * * * /usr/bin/lynx -source http://paris1.drupaladmin.net/cron.php

*Create sample content to migrate.

***********************************************************************************
Enable Back Up & Migrate and Admin_Menu
* Admin_menu - http://drupalmodules.com/download/14898
cd /var/www/sites/paris1.drupaladmin.net/htdocs/sites/all/modules
wget http://drupalmodules.com/download/14898
tar -zxvf admin_menu-6.x-1.5.tar.gz
rm admin_menu-6.x-1.5.tar.gz

* Back Up & Migrate - http://drupalmodules.com/download/10540
cd /var/www/sites/paris1.drupaladmin.net/htdocs/sites/all/modules
wget http://drupalmodules.com/download/10540
tar -zxvf backup_migrate-6.x-1.2.tar.gz
rm backup_migrate-6.x-1.2.tar.gz
***********************************************************************************

Upgrade to Drupal 6.13
****GO OVER UPGRADE.txt!!!****

* http://ftp.drupal.org/files/projects/drupal-6.13.tar.gz
mkdir /var/www/sites/paris1.drupaladmin.net/backup
cp -r /var/www/sites/paris1.drupaladmin.net/htdocs/sites/ /var/www/sites/paris1.drupaladmin.net/backup/

****Put site into offline mode****

****Disable contrib modules and themes****

cd /var/www/sites/paris1.drupaladmin.net/htdocs/
rm -r *

wget drupal http://ftp.drupal.org/files/projects/drupal-6.13.tar.gz
tar -zxvf drupal-6.13.tar.gz
rm drupal-6.13.tar.gz
cd drupal-6.13
mv .htaccess ..;mv * ..; cd ..
rm -r drupal-6.13

cp -r /var/www/sites/paris1.drupaladmin.net/backup/sites/ /var/www/sites/paris1.drupaladmin.net/htdocs/
chmod a+w /var/www/sites/paris1.drupaladmin.net/htdocs/sites/default/files
chmod a+w /var/www/sites/paris1.drupaladmin.net/htdocs/sites/default/files/backup_migrate/
chmod a+w /var/www/sites/paris1.drupaladmin.net/htdocs/sites/default/files/backup_migrate/manual

****Run http://paris1.drupaladmin.net/upgrade.php****

****Enable contrib modules and themes****

****Put site into online mode****

****Make new backup for migration****
***********************************************************************************
Setup new server and migrate site.

cd /etc/apache2/sites-available/
cat apache-template | sed 's/$DOMAIN/paris2.drupaladmin.net/g' > paris2.drupaladmin.net

cd /var/www/sites
mkdir paris2.drupaladmin.net
mkdir paris2.drupaladmin.net/htdocs
a2ensite paris2.drupaladmin.net
/etc/init.d/apache2 reload

mysql -u root -p

CREATE DATABASE `dbparis2`;
CREATE USER 'userparis2'@'localhost';
SET PASSWORD FOR 'userparis2'@'localhost' = PASSWORD('passwordparis2');
GRANT ALL PRIVILEGES ON `dbparis2`.* TO 'userparis2'@'localhost';
quit

Once the web server is finsihed and has your domain enabled, we can install Drupal.

cd /var/www/sites/paris2.drupaladmin.net/htdocs
wget drupal http://ftp.drupal.org/files/projects/drupal-6.13.tar.gz
tar -zxvf drupal-6.13.tar.gz
rm drupal-6.13.tar.gz
cd drupal-6.13
mv .htaccess ..;mv * ..; cd ..
rm -r drupal-6.13

crontab -e
45 * * * * /usr/bin/lynx -source http://paris2.drupaladmin.net/cron.php

cp /var/www/sites/paris2.drupaladmin.net/htdocs/sites/default/default.settings.php /var/www/sites/paris2.drupaladmin.net/htdocs/sites/default/settings.php
chmod a+w /var/www/sites/paris2.drupaladmin.net/htdocs/sites/default/settings.php

mkdir /var/www/sites/paris2.drupaladmin.net/htdocs/sites/all/modules
mkdir /var/www/sites/paris2.drupaladmin.net/htdocs/sites/all/themes

mkdir /var/www/sites/paris2.drupaladmin.net/htdocs/sites/default/files
chmod a+w /var/www/sites/paris2.drupaladmin.net/htdocs/sites/default/files

Open in browser and setup site with new database info. Then take away write access to settings.php

chmod a-w /var/www/sites/paris2.drupaladmin.net/htdocs/sites/default/
chmod a-w /var/www/sites/paris2.drupaladmin.net/htdocs/sites/default/settings.php

scp -r /var/www/sites/paris1.drupaladmin.net/backup/sites/all/modules root@66.146.206.205:/var/www/sites/paris2.drupaladmin.net/htdocs/sites/all/
scp -r /var/www/sites/paris1.drupaladmin.net/backup/sites/all/themes root@66.146.206.205:/var/www/sites/paris2.drupaladmin.net/htdocs/sites/all/

****Import database from Back Up & Migrante module's import feature****
***********************************************************************************