Error restoring DB to another host

[Vinyljunky]

Dear Gurus

Im in the process of seting up a VB test site. I have dumped my DB and Im trying to import it on another host using phpMYadmin.

However part way through the import I get the error below

Error
SQL query:

--
-- Dumping data for table `holiday`
--
--
-- Table structure for table `icash_donations`
--
CREATE TABLE icash_donations(

id int( 11 ) NOT NULL AUTO_INCREMENT ,
FROM text NOT NULL ,
TO text NOT NULL , I get an error icon on this line
amount int( 11 ) NOT NULL default '0',
time text NOT NULL ,
PRIMARY KEY ( id )
) TYPE = MYISAM ;



MySQL said:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from text NOT NULL,
to text NOT NULL,
amount int(11) NOT NULL default '0',
' at line 3

Can anybody help? :confused:

Many Thanks

VJ

[eobie]

have you tried to do it via ssh?

[Vinyljunky]

have you tried to do it via ssh?

I only have WWW access, the new host provides the CPanel interface to manage my site.

Any other ideas :confused:

Thanks

VJ

[eobie]

some hosts will grant you access to ssh if you ask. if not ask for them if they could do it for you.

[Snake]

And if they can't, I can definitely help you out with this. ;)

[cyberphr]

I think I received an error like this when trying to import my forum database to my desktop.

Have you got some type of points hack installed?

[Vinyljunky]

And if they can't, I can definitely help you out with this. ;)

I may take you up on that ;)

I think I received an error like this when trying to import my forum database to my desktop.

Have you got some type of points hack installed?

Yes icash

Thanks

VJ