By mysocom on

I have 2 sites. There is small deferents between them. (modules, menu) But most of menu item is the same. How can I copy content from my old site to new ?

Comments

zahor’s picture

zahor commented

You'd have to copy the database. Probably not the entire database but tables that contain the information you want.

To do that, you export the database from current site, save it as a file (if you are using phpMyadmin, it would be very easy), then open the file and copy all the "insert into" queries(don't want the "create table" queries) you have to make sure the tables you are inserting into exist.

cloxzime’s picture

cloxzime commented

Hi,

I have go to phpMyAdmin but cannot find any database which contains the menu that I need to copy.

I am not copying the menu to other site but the same site at other menu. Because each of my menu contained many submenus which takes time to make it manually.

Helps will appreciated.

Thanks.

Ghostthinker’s picture

Ghostthinker commented

A small hint. Export your database (in phpmyadmin, select your_db->export) and open the exported sql file with your editor. Now can search for your menu items.

Please post a reply if it worked...

shanep’s picture

shanep commented

I'm looking to do something similar but I want to just copy one or two CCK Fields from one site to the other. I tried a couple different Drupal modules to get this to work but to no avail. I also crossed my fingers and tried an Export/Import of the specific fields in the MySQL tables but it stated that the tables were already there. I'm not very familiar with phpMyAdmin or the process of replacing MySQL tables in it. Any assistance would be fantastic, thanks!

Shane