Mysql Database will not import to new site.

[graybeard]

Hi, We are moving our vB 4.2.3 sites to a new host. I have one moved over. The second will be an add on domain. I have imported all of the DB with the exception of the "post" table. It is 326 MB in size. Somewhere within that table is a post that redirects me to a now defunct site. This occurs during the import. At one point I exported a couple 100 tables and when I saved it locally, instead of showing it came from my server, it shows it came from secureserver.net's server. This is way above my pay grade and could really use some advice or help with this. The site with the DB issues is currently running on the old host's server. Thank you in advance for your replies.
I wanted to add that I have tried both SSH and the phpMyAdmin importing. This is where I am redirected to during the import. Looks like a cPanel for secureserver.net. https://a2plcpnl0851.prod.iad2.secur...min/import.php

[Trevor Hannant]

Somewhere within that table is a post that redirects me to a now defunct site. This occurs during the import.

It only imports what's been exported! Exporting a database from one server won't change links etc so when you import it, you'll get whatever was present in the old database.

What you'll need to do is do a search within the table for that URL and then edit it to replace it.