Importing Mysql data from 3.23.58 to 5.0.24

[Joe]

Hi All,

I have 2 Mysql databases, db 'Emp' resides on Solaris running Mysql 3.23 and db 'Jobs' is on RHE 4 running 5.0.24. I need to import data from specific tables into the db B on a daily basis.

I was thinking of using Mysqldump -t (do not drop and create tables at the destination). As there are some changes in table structures of the 2 dbs.
For instance: Emp.users has a blob(4000) field where as in the new version Jobs.users has been created with Varchar(4000) field.

But there's a catch, when I insert the rows from Emp.users table to the Jobs.users table, i want to insert all the rows only after cleaning up the previous records from Jobs.users.

Is there any straight forward mechanism to do that.
Any help would be highly appreciated.

Thanks in advance

Joe