Accounts transfer new setup

[johnswolter]

I need to move accounts to a different instance of SugarCRM. The number could vary from just one to batches of 20 or 30 at a time. Both instances are the same version. Is there an easy way to export then import between these two setups?

[Angel]

SQLyog (www.webyog.com) provides a facility to that very easily. For Windows users only though...

[ros.vol]

or phpMyAdmin (web- application) is free and almost at every server.

[johnswolter]

My system is LINUX based, so I will have to use PHP based manager. Since I don't know the database's table layouts how do I know how to transfer an account completely? Are accounts contained in a single table? What might you know about the table layouts and inter-links for accounts?

[Angel]

All the accounts info is stored in the Accounts table. If you added custom fields, you'll also want to transfer accounts_cstm. The relationship data is stored in the other tables whose names begin with accounts_*, but beware because that is not a comprehensive list. For example, e-mails are linked to an account via other tables.

[theone]

Where are the email addresses for accounts stored? I'm attempting to take an older version of Sugar data and import it into a new version of Sugar plus set up the information correctly. On the old version accounts hadd all of the email addresses and none of them were in contacts. So now I'm trying to export the emails address on the accounts and then on the new version import them as contacts associated with the account. But I can't find where I can export the account email address. I'm even scouring the db in phpMyAdmin and I can't locate them.
Any help would be greatly appreciated.
Don

[eggsurplus]

email_addresses and email_addr_bean_rel tables