Drupal HowTo Copy site to test server

Tags: Drupal HowTo

Process

1. Run the ​Full backup script to produce a file called something like sitebackup-YYYY-MM-DD.tgz
2. scp the tar file to the new server
3. tar -zxvf sitebackup-YYYY-MM-DD.tgz, which will produce 2 files called dbcontent.sql and filecontent.tar
4. Create a directory for the web folder mkdir /local/www/scad
5. Log into MySql
6. Create the database using CREATE DATABASE {databasename} CHARACTER SET utf8 COLLATE utf8_general_ci;
7. Grant the user permissions to the database using GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES ON {databasename}.* TO '{username}'@'localhost' IDENTIFIED BY '{password}';
8. Make any necessary changes to the Apache config
9. Restart Apache

Error: Macro BackLinks(None) failed

'Environment' object has no attribute 'get_db_cnx'