New Local Site

Make directory for new site

sudo mkdir /var/www/yoursite

Copy site files to /var/www/yoursite

sudo git clone github.com/user/repo /var/www/yoursite

Add site to /etc/apache2/sites-available/locals.conf

<VirtualHost *:80>
    ServerAdmin [email protected]
    ServerName yoursite.com
    ServerAlias www.yoursite.com
    DocumentRoot /var/www/yoursite	
    <Directory /var/www/yoursite/>
        Options Indexes FollowSymLinks
        AllowOverride All
        Require all granted
    </Directory>
    ErrorLog ${APACHE_LOG_DIR}/error.log
    CustomLog ${APACHE_LOG_DIR}/access.log combined
</VirtualHost>

Update Apache

sudo service apache2 reload

Add site to /etc/hosts

# yoursite
142.54.230.252 yoursite.dev www.yoursite.dev

Import database

mysql -u root yoursite < db_dump.sql

Add Definer User (may not be necessary)

create user 'yoursite'@'localhost';
grant all privileges on yoursite.* to 'yoursite'@'localhost';
flush privileges;

Change base URLs

# Magerun
n98-magerun.phar sys:store:config:base-url:list
n98-magerun.phar sys:store:config:base-url:set
# (make sure the secure URL isn't using https)

# MySQL
select * from core_config_data where path like '%base_url%';
update core_config_data set value = 'http://www.yoursite.dev' where path like '%base_url%';