Greetings,

In this article I will try to explain how you can copy your data (categories and links) from one eSyndiCat based directory to another one. Let's imagine we have directory installed here - dirone.com (a source directory )and another one is here dirtwo.com (where we want to copy our links and categories).

The instructions below will work for the following versions:

• #1 From PRO 1.2 to PRO 2.0
• #2 From PRO 1.2 to PRO 2.1
• #3 From PRO 2.0 to PRO 2.1

So first step is to export your source data:

• #1 Login to your Admin panel of eSyndiCat that's installed on dirone.com
• #2 Open Manage Database -> Export
• #3 Select the following tables:
  1. "*_categories"
  2. "*_flat_structure"
  3. "*_links"
  4. "*_link_categories"
• #4 Select the following export options:
  1. Structure : Off
  2. Add DROP TABLE : Off
  3. Data : On
  4. Complete inserts : On
  5. Save as file: On
  6. Save to PC: On
  7. Click "Go"
• #5 The action above will save your dump to your PC.

Next step is to import prepared database dump:

• #1 Login to your dirtwo.com admin panel
• #2 Upload the SQL file to "updates" folder
• #3 Click "Manage Database"
• #4 Click "Import"
• #5 Chose the SQL dump in the dropdown menu
• #6 Click "Go"

And the last step is to remove duplicated ROOT category.

• #1 Click Manage Database
• #2 Insert the following query in the field:
  DELETE FROM *_categories WHERE `title` = 'ROOT' AND `id` > 0;
• #3 Run the query

That's all. After that you will have your data copied to your another directory.