= Drupal HowTo Copy site to test server

Tags: [[Drupal]] [[HowTo]]

== Process

1. Run the [[https://www.drupal.org/node/59373|Full backup script]] to produce a file called something like {{{sitebackup-YYYY-MM-DD.tgz}}}
1. {{{scp}}} the tar file to the new server
1. {{{tar -zxvf sitebackup-YYYY-MM-DD.tgz}}}, which will produce 2 files called {{{dbcontent.sql}}} and {{{filecontent.tar}}}
1. Create a directory for the web folder {{{mkdir /local/www/scad}}}
1. Log into MySql
1. Create the database using {{{CREATE DATABASE {databasename} CHARACTER SET utf8 COLLATE utf8_general_ci;}}}
1. 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}';}}}
1. Restore the contents to the database using {{{mysql -u {username} -p {database} < dbcontent.sql}}}
1. Make any necessary changes to the Apache config
1. Restart Apache

[[BackLinks]]