how to move data between databases?

[rdrnnr]

I have a few mysql tables that have unique id's referenced to each other in a separate table. (ie: dates, timelines and dates_timelines). I want to move all this data into the same structure on another server, maintaining the ID relationships. The ID's themselves don't have to remain the same, but the relationships do.

I was wondering if there is a simple way of doing this, as a part of the mysql package (im kind of new at mysql).

I'm sure there is a common solution to this common task... if not in mysql then i can write a script or something.

thanks
rdrnnr

[ultraslacker]

Check the man pages for mysqldump