import only some category rows ?

[Frank71]

ai,

I have the follow problem:
I want to every category subcategories with continent -> country = a lot of categories.
How can I copy these if I built the structure one time ?

The only way I see is to build it one time, export all these category rows allone, import it again with phpmyadmin and change the cat-ID from 2,3,4,5.... to 6,7,8,9 also with phpmyadmin by hand.

Now, with which phpmyadmin option should i export and import them ?
With a dump data 2 to 5 ?
Structure and data ? Only data ?
With 'drop table' or complete 'inserts' ?
And what should I do to get it back in th e right table ?

Maybe somebody can help, to add all these categories again and again by hand will be a work of months

Greetings
Frank

[dody]

Now, with which phpmyadmin option should i export and import them ?
With a dump data 2 to 5 ?
Structure and data ? Only data ?
With 'drop table' or complete 'inserts' ?
And what should I do to get it back in th e right table ?

Frank, it may helpful if you know some sql knowledge. If you want to add some partial data, use insert command. Do not play with drop table because it will delete the table and all its data.

If you want to add your existing data that is in 'dump' mysql, then use query box provided with phpmyadmin. Copy/paste from your data, search line like
'insert into xxx_table_name_xxx (.....'

make sure they both table have the same fields.

You may need sql knowledge. Search in google with keyword 'sql tutorial' ... etc. It will definitely help you much