How I Migrated the Live Drupal site to VirtualBox site


This is what I did–Brute Force, But it worked, sort of

  1. Used MyPHPAdmin and exported the database (after following Katy’s instructions to clear the various cache tables and other ones–I forget)
  2. Downloaded the foxfami1_drp10.sql file to vagrant-chef-dlamp/public directory
  3. Using Putty:  Went into MySql and deleted/redefined dbname database (easier than manually deleting all the tables)
    1. mysql -u root -p
    2. drop database dbname;
    3. create database dbname;
  4. Using Putty: mysql -u root -p dbname<vagrant/public/foxfami1_drp10.sql – to restore the database.
  5. On Host:  Used Zip to save the existing Site folder, downloaded and unZipped it to /vagrant-chef-dlamp/public and replaced the existing site directory.
  6. Using Putty: drush updatedb

Problems

  • Even though I thought that I had the same modules in the LocalHost Drupal, I was missing the Libaries Module,  This caused a problem with my Views Slideshow.
    • Undefined variable: module_path in _views_slideshow_cycle_preprocess_views_slideshow_cycle_main_frame() (line 91 of /vagrant/public/sites/all/modules/views_slideshow/contrib/views_slideshow_cycle/theme/views_slideshow_cycle.theme.inc).
    • From Putty:  drush dl libaries and then drush en libraries

Future

I need to figure out how exactly to use the Backup/Restore module to keep the database in sync and modules/themes.

Advertisements

2 thoughts on “How I Migrated the Live Drupal site to VirtualBox site

  1. I am also looking to be able to sync sites and dbs. I would ideally like to do it with drush rsync and drush sql-sync. But it means getting ssh working.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s