Moving data from 1 site to another.

[WMMM]

I am setting up a number of esyndicat sites and am wondering if there is an easy to move the categories and links from one site to another so I don't have to re-enter all the main items.

Thanks.

Mike Murphy

[sdawkins]

You can do a msql dump I think.

[WMMM]

Tried exporting if from 1 site and importing it in another and got sql error. Maybe I'll try it from cpane.

[sdawkins]

When I was reinstalling to a new database, I did the dump and it worked.
I used Cpanel to do it.

[OWG]

What is the process with cpanel please?

This would be really helpful to amny people who do not know what to do. (although I am sure there is an option here)

[Vincent Wright]

Greetings all,

as sdawkins said you can export your original database via MySQL dump and import it into new database. This should work.

The tool that's used to manage databases is called phpMyAdmin. You can export/import with this tool as well.

Log into your cpanel. Find a link "MySQL Databases", open the link. Scroll to the bottom of the page. Find "phpMyAdmin" link. Open it.

phpMyAdmin has Export/Import links. Just play with them and you will find out how to migrate your database.

Hope this helps.

[WMMM]

I exported my database and when installing it on the new location everything referenced the old one. Is there only certain tables that would need to be moved, like categories and links?

[Vincent Wright]

Actually, I don't quite understand what you mean by "everything referenced the old one".

[sdawkins]

WMM -- I know you tried to do a dump and then insert.

This is what I had to do to transfer mine.

Save your msql dump.

Open up the dump file in notepad.

Leave out (or remove) all the jumbo at the begining (that references the database you exported).
and start with the first insert into. You can then save it, or do as I did I did a copy and paste from that point on into your PHPMyAdmin via the Cpanel in the "Run SQL query/queries on database"
_________________

[WMMM]

Hi guys. I may be stupid, but can you expand a little more. Do I export the structure and data or only the data? Do I select every table or just certain ones? Then there's data types: 'complete inserts' or 'extended inserts'? Then 'use delayed inserts' or 'use ignore inserts' or 'use hexadecimal for binary fields'? Then export to 'insert' or 'update' or 'replace'?

Yikes. It's probably easy after doing it once :-) , but the first time is a killer.

Thanks for the help.

Mike

[OWG]

WMM that was what I was asking when I requested a step by step guide. there are so many combinations that you could spend months trying to get it right :(

[sdawkins]

Mike --

What I did...

I just did a total msql dump, with the structure and this checkboxed
Add AUTO_INCREMENT value
Enclose table and field names with backquotes

And checkbox data and Use hexadecimal for binary fields.

Saved it.

New database, emptied so no data in it.

Then as stated above, opened in notepad, deleted the begining where it referenced the other database.
Then copy and pasted everything into SQL --Run SQL query/queries on database.

Later I changed my password for Admin by going into Admin and changing it and be sure to use MD5.

[Vasily B.]

Hi all,
Just to clarify. There are 5 main tables that should be exported/imported. They are:
categories, flat_structure, link_categories, links, sequences.

Some guys above already mentioned how to export data. I will summarize:
1. Go to your phpMyAdmin (I will not explain how your get there, different hostings have different ways)
2. Then choose your esyndicat database
3 Click export
4. Choose these 5 tables from a multiple combo box.
5. Set the following export options:
Structure, Data, Complete Inserts, Save As file

Then install your eSyndiCat to new location. Go to phpMyAdmin and choose correct database. Remove these 5 tables.
Go to import and choose your saved file with categories and import it.

That's all. It seems there are too many steps but they are easy. You can even use eSyndiCat manage database tool.

[WMMM]

You guys are awesome. I finally got it to work and it was so simple once I knew the tables. Thanks sdawkins and Simon. This is going to save me so much time. If I could I'd buy your a :beer:

Mike

[Vasily B.]

I'm glad to advise, Mike :)