[Drupal] How to sync live and development sites?
BY prince.kr
6 years ago

Syncing means importing all files, permissions and data's from master to the development site, so that we have a two copies of live sites to test our new developments. In Drupal, its very easy to create versions of websites using this syncing process. Once the site is live to Production, the above process helps to fetch the sites data in the current scenario and to update few more features in the live site.
I had a task to sync live database to development site's and came across some issues while syncing live database with the dev database.

The following commands could be used to import the database from live server

Before proceeding to do anything on live server, it's a good practice to always keep a db backup and file backups.

  • To backuping up live database
     mysqldump -u username -ppassword  database_name | gzip > filname.sql.gz
  • Import the live database to dev server
     gunzip < filename.sql.gz | mysql -u dev_username -pdev_password dev_databasename

The following errors occurs after syncing in development website.

  • "The website met an unexpected error. Please try again later."
  • PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'status', ...line 382 of /modules/filter/filter.module
  • PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column .....line 187 of /home/xxxxx/public_html/sites/all/modules/entity/includes/entity.controller.inc).

The above issue can be fixed by disabling the following in the sites.

  1. Disable boost module
    drush pm-disable boost
  2. Disable memcached module
    drush pm-disable memcached
  3. Disable css/js aggregations
    drush vset preprocess_js 0 --yes
            drush vset preprocess_css 0
            drush vset preprocess_js 0
            drush cc css+js
  4. Cleared all cached data
    drush cc all

Hope the above helps you to sort the issues after syncing live and dev database.



on 01st January 2008 / by webmaster
We have added a few new modules to our site recently. Drupal Technical StumbleThis Sean (not verified) access_time 20 Sep 2021 - 17:58 Hi there, I uploaded the files, enabled the modules to use SU, and now I see the link, but there is no icon... How can I fix this? Thanks, Sean webmaster access_time 20 Sep 2021 - 17:58 In reply to Icon doesn&#039;t show by Sean (not verified) What do you see when you view the source? Search for stumblethis_button and you should be able to see the code for the image and the URL. Then you should be able to troubleshoot from there. Juicy Couture Addict (not verified) access_time 20 Sep 2021 - 17:58 thanks for the post. would love to hear more of you. by the way, drupal's really popular nowadays as it has easy and fast features. you agree with me? thanks.

on 16th January 2008 / by webmaster
Most webmasters do not realize this, but a lot of the content on lot of websites can be accessed from multiple URLs. A simple example would be where www.example.com and example.com leads to the same page. This is a fatal mistake in Search Engine Optimization and search engines penalize you for duplicate content. The correct configuration would be where the above two urls will lead you to the same page but example.com will redirect you to www.example.com with a 301 (Moved permanently) status which will not result in search engines penalizing the page. It is very easy to configure 301 redirects using Apache .htaccess file and the process is the same for a Drupal installation also. Drupal Technical Apache htaccess SEO Anonymous (not verified) access_time 20 Sep 2021 - 17:58 Hello. I'm trying to make example.com show as www.example.com, and I'm running into difficulties. I'm on Apache 2.0 and using the following lines in my httpd.conf file: RewriteEngine on RewriteCond %{HTTP_HOST} ^xxxxxxxxxx\.com$ [NC] RewriteRule ^(.*)$ http://www.xxxxxxxxxx.com/$1 [L,R=301] When I go to http://xxxxxxxxxx.com, I get http://www.xxxxxxxxxx.com (as expected). However, when I go to http://xxxxxxxxxx.com/node/1 (it's a Drupal site), I get a 404 thrown and the URL changes to xxxxxxxxxx.com/var/www/drupal/node/1. Same thing with www.xxxxxxxxxx.com/node/1. Any suggestions? I want to run without Drupal's .htaccess file (instead incorporating these calls into my httpd.conf file). webmaster access_time 20 Sep 2021 - 17:58 In reply to Rewrite including filesystem path by Anonymous (not verified) I think the problem is with the base path which results in the redirection to /var/www/ part. The best approach I would think is to start with drupal htaccess and then strip out parts and move to httpd SNVC (not verified) access_time 20 Sep 2021 - 17:58 This is definitely a good guide. Thanks for this. wellyson access_time 20 Sep 2021 - 17:58 This is really nice and helpful.

on 08th February 2008 / by webmaster
Attachment Size slashdotit.tar.gz 173.55 KB Similar to the StumbleThis module that we had created earlier we have created another bookmarking Drupal Technical Slashdotit Shlomi Fish (not verified) access_time 20 Sep 2021 - 17:58 Hi! I'm interested in this module, but Drupal 6.2 complains that it's incompatible with it. Can you please update it or tell me how? Regards, Shlomi Fish shlomifish.org webmaster access_time 20 Sep 2021 - 17:58 In reply to Can you update it for Drupal-6.x? by Shlomi Fish (not verified) Sure we are working on this currently and will post an update soon. Also we will post this module on www.drupal.org as well Cheers Anoop John Team Zyxware Anonymous (not verified) access_time 20 Sep 2021 - 17:58 Hello! Nice Article very interesting, thanks