Copying data from 1 site to another

[jwoo]

Hi,


I am going to input project data into one testing machine.
But this machine will not be the ultimate production one.

Later when the production machine is set up,
how can I 'copy' the information in the testing machine
to the production machine?
Is it done by exporting mySQL table data and
importing? If so, which tables should I copy?

Thank you for your attention.


Regards,


Johnny

[caseydk]

Exporting via mysql is the easiest way.

The relevant tables depend on what information you're importing. If you create a Project and some Tasks, you'll need those tables. Since you have to create Companies and Users, you'll need those also. If you add Forums, you'll need the forum_* tables. Most likely you'll want to do the whole database.

If this is a one-time, one-way import, it shouldn't be a problem.