The Deacon - I was planning on doing that but the restore process says that it will overwrite the existing cdr records and I was afraid I would lose the new cdr.
I'm sorry, I mis-read your question. You're right. It will!
Here is a command line approach to do it:
On the old box, let's export the data (but since we just need the data, not to create a database or a table, use the -n and -t options respectively):
mysqldump -u root -p asteriskcdrdb -n -t > old_cdr.sql
Copy this file over to your new box via scp.
On the new box, let's get a quick backup of the data before we monkey with anything:
mysqldump -u root -p asteriskcdrdb > new_cdr.sql
Now, let's import the old data into the cdr database:
mysql -u root -p asteriskcdrdb < old_cdr.sql
That should do the trick!
-Rick