| Version 5 (modified by , 10 years ago) ( diff ) |
|---|
Drupal HowTo Copy site to test server
Process
- Run the Full backup script to produce a file called something like
sitebackup-YYYY-MM-DD.tgz scpthe tar file to the new servertar -zxvf sitebackup-YYYY-MM-DD.tgz, which will produce 2 files calleddbcontent.sqlandfilecontent.tar- Create a directory for the web folder
mkdir /local/www/scad - Log into MySql
- Create the database using
CREATE DATABASE {databasename} CHARACTER SET utf8 COLLATE utf8_general_ci; - 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}'; - Restore the contents to the database using
mysql -u {username} -p {database} < dbcontent.sql - Make any necessary changes to the Apache config
- Restart Apache
Note:
See TracWiki
for help on using the wiki.
