Copying DB data

by Simon Gooffin

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.