Copy data from tmp db to real db; Easy way?

Hi,

I need to copy data from my temporary database to the definite db. I
can do this by selecting all data, create new insert statements and
execute those. But I have a feeling that their is an easier way.
Something like dumping, buth without the table building statements.
What is the easy way to do this?