On Mon, 8 Mar 2010 14:14:09 -0800 John Oliver said:
> OK, a Drupal site I deal with has two copies... a production site and a
> test site. After new changes are developed, they're put on the test
> site. Once the test site is deemed to be OK, that entire site and
> database will be copied over to the production site.
> The issue is, while that work is taking place, changes are still
> happening on the production site, like new user registrations and some
> form input. What I'm thinking is, we can dump the affected tables and
> then import them into the test site, which started life as a mirror copy
> of the production site. If I were to:
> mysqldump -h db_server -h user -pPASSWORD database table_1 table_2 >
Get the table layout on the production box:
mysqldump --add-drop-table ...
> On the production side, and then:
> mysql -h test_db_server -h user -pPASSWORD database < /tmp/db.sql
Don Read don_read@stripped
It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.