Problem Moving to new Host

[turbowarp]

Hello,

I haven't been thrilled with my current host and have heard very good things with hostgator as a webhost, so I am changing hosts. I have moved several other domains, but this one has phplink Regional directory running on it and is giving me and them fits.

I signed up with them and asked them to move my domain... when they did they tried to export my databases and got this response.

----------------------
SQL query:

SHOW CREATE TABLE `texas_directory`.`PLD_LINK_RATE`

MySQL said: Documentation
#1016 - Can't open file: 'PLD_LINK_RATE.InnoDB'. (errno: 1)
----------------------

Until I resolve this issue, currently the domain is at the old host and appears to be working as normal:
http://www.turbowarp.net
my new host is (will be) at:
{ip address url removed}

Any advice would be appreciated.

thanks
Randy

[anon]

it sound like you have a corrupted file, but don't quote me on that.

[David]

It looks like it may be working now.
Am I right?

[turbowarp]

Content visible to registered users only.

Yes, it is working on the old host ... but the database on the old host still seems to be corrupt or something.

When I run the mysql check from the cpanel this is what I get on the old host...
MySQL Account Maintenance



Checking Database
texas_directory is now being checked.
texas_directory.PLD_CATEGORY OK
texas_directory.PLD_CATEGORY_SEQ OK
texas_directory.PLD_CITY OK
texas_directory.PLD_CONFIG OK
texas_directory.PLD_COUNTRY OK
texas_directory.PLD_EMAIL OK
texas_directory.PLD_EMAIL_SEQ OK
texas_directory.PLD_EMAIL_TPL OK
texas_directory.PLD_EMAIL_TPL_SEQ OK
texas_directory.PLD_LINK OK
texas_directory.PLD_LINK_RATE
error : Can't open file: 'PLD_LINK_RATE.InnoDB'. (errno: 1)
texas_directory.PLD_LINK_RATE_SEQ OK
texas_directory.PLD_LINK_SEQ OK
texas_directory.PLD_PAYMENT OK
texas_directory.PLD_PAYMENT_SEQ OK
texas_directory.PLD_USER OK
texas_directory.PLD_USER_PERMISSION OK
texas_directory.PLD_USER_SEQ OK
texas_directory.PLD_ZONE OK


Check Complete

Hostgator couldn't (wouldn't) transfer all of the tables, they only transferred the top 10 tables until this got resolved. DNS is still pointing to the old host.

Any help would be appreciated, even a donation would be considered if necessary.

Thanks
Randy

[turbowarp]

Bump... anyone with any help?