Showing posts with label sql. Show all posts
Showing posts with label sql. Show all posts

Sunday, 29 March 2015

Drupal security updating

Using drupal it's always good to stay up-to-date with security updates. The trouble is, how to update as it is usually a manual thing (please could you automate it Drupal?).

So, the manual process is:
  1. Backup files
    1. You really only need to backup the /Sites/All folder, but I backup all of it
    2. I use FileZilla, and simply drag the whole online folder onto my machine in an appropriately named folder - /Backups/29-03-2015/webfiles/
  2. Backup database
    1. The database is probably the most important thing to backup
    2. Log in to your myPHPadmin console
    3. click on the database
    4. Click on export
    5. I just use the simple settings
    6. When it's made the file, it'll give it to you to download
    7. Download and put it in an appropriately named folder - /Backups/29-03-2015/database/
  3. Download the latest Drupal release
  4. Upload all the files
    1. I use FileZilla, which doesn't replace folders, only files within folders. Very handy! You don't want to overwrite your /sites/ folder as this contains all your custom stuff!
  5. Run the update
    1. go to http://www.yourwebsite.com/update.php
  6. Done!

Saturday, 20 September 2014

Drupal Backup and Migrate - how to (in progress)

So, I have a drupal website. I'd like to write down the process of backing up and then restoring upon a complete failure.

So, to backup just use the default backup and set to download. Save these somewhere safe. Just to be safe I also did the same for Public Files Directory and Private Files Directory.

I guess thats the easy part. For the next part I've found it hard to find any documentation on restoring from a complete failure. Here's what I have found:

http://www.anexusit.com/blog/how-restore-backup-migrate-file-using-drush
http://drupal.stackexchange.com/questions/40490/how-to-restore-a-site-from-a-backup-done-with-backup-and-migrate-module-using-dr

Both are related to drush which is a command line shell and scripting interface for Drupal.

My best guess for restore is to install drupal, install drush and run the restore command line.

If you also lose files, then you have to make sure you have backup of all files as well.

I think what I'd really like is the backup utility used with Joomla, Akeeba. This is much easier. I don't even think you need to install Joomla to reinstall. And it backs up all files. There must be a reason it isn't as easy. Oh well.