Showing posts with label myphpadmin. Show all posts
Showing posts with label myphpadmin. 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, 31 May 2014

Drupal moving database from one server to another

So I wanted to get a site I've been making 'live' which meant transferring from the test server to the real one. How to do this? I remember in Joomla it was as easy as pie, not so with Drupal, although not too tough.

Basically:

  1. move all files
  2. move all tables from database
So, in myPHPadmin you can export, but I was coming up with an error:

Error

SQL query:
--
-- Database: `sitename_pw`
--
CREATE DATABASE IF NOT EXISTS `sitename_pw` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

 
MySQL said: dot.gif
#1044 - Access denied for user 'my_user_name'@'localhost' to database 'sitename_pw'

So I found this website which explained that you have to export the tables within a database, rather then a whole database. To do this you have to be looking at the database tables, then press the export button to export just the tables.

Then when you import them, you have to be actually in the new database and press the import button