By rahulg2 on

hi,

i have full DB Backup of a running 4.6.3 drupal..
and also i have a fresh drupal site with no data..

and now i want to add all the NODES (just nodes) of the "Running DRUPAL" site to this TEST Site..
means i want to add ONLY pages, comments, blogs and forums....
and NOT the Other things like.."search_index, accesslogs, watchdog logs etc.."

i tried by copying data of "node" table...
but i cant see those nodes in contents section of admin page..
also when i click on link to open that node(on block) .. it says "you dont have permission.."

please tell me how can i do this in a proper way...
since i dont want to run Whole script; which is too big...

thanks.
--
pangu

⋅ Categories: Drupal 4.6.x

Comments

dman’s picture

dman commented

I understand why you would not want to dump everything on there, but you've got to understand that much data about nodes is spread out among the various tables.

Before mirroring a site, I always
DELETE FROM watchdog;
DELETE FROM cache;
DELETE FROM sessions;

... and a few others. This makes the archive mysql_dump much more managable.

If, however you want to synch two sites without touching their respective configurations, it gets really tricky. You need the taxonomy, you need the taxonomy lookups, the menu and a dozen more tables to replicate an existing site.
There is no easy answer that I've found.

.dan.

http://www.coders.co.nz/

.dan. is the New Zealand Drupal Developer working on Government Web Standards

rahulg2’s picture

rahulg2 commented

can i remove data of 'search_index' , `search_total` & `accesslog` tables??

i removed 'search_index' , `search_total` and found that SEARCH isnt working...

i did the CRON and still search isnt working...

when does values of 'search_index' get populated??

thanks much..

dman’s picture

dman commented

Accesslog I guess
I don't know anything about search, sorry.

http://www.coders.co.nz/

.dan. is the New Zealand Drupal Developer working on Government Web Standards