521211 - copy over production database over to stage

Status: RESOLVED FIXED

(Websites Graveyard :: spreadthunderbird.com, defect)

Description

[jamey]

gozer copy over production database over to stage

Comment 1

[Philippe M. Chiasson (:gozer)]

And you want that to squash the current staging database or to have it copied as a separate database on staging ?

Comment 2

[Paul Booker]

@gozer 

Can we have the stage server just running the latest production database. 

I'll then re-enable the new theme and given an account that is currently only on production administrative access 

Best, Paul

Comment 3

[Philippe M. Chiasson (:gozer)]

$> mysqldump -h production --ignore-table=drupal.cache --ignore-table=drupal.cache_block --ignore-table=drupal.cache_content --ignore-table=drupal.cache_filter --ignore-table=drupal.cache_form --ignore-table=drupal.cache_menu--ignore-table=drupal.cache_page --ignore-table=drupal.cache_update --ignore-table=drupal.cache_views --opt drupal | mysql drupal

Done, stage doesn't look very happy as a side-effect. Find me on IRC if you need assistance

Comment 4

[Philippe M. Chiasson (:gozer)]

Cleared cache and things look better.

Comment 5

[Paul Booker]

@gozer  Works perfectly!

Thanks Paul