Can you load a file with PHPMyadmin from a file on the server?

[MrSpeed]

I have a huge amount of data I need to get into mysql. I'd like to zip it and then FTP it up to the server before I load it into the database.

Can phpmyadmin load this file from the server or will it only do it from the local drive om my pc?

If I can't do this are there any free utilities to load the data from the web server?

Thanks,

[jatar_k]

do you have the option of using command line?

upload it and then you can import it into mysql on the sevrer

/path/to/file.sql > mysql -u username -p

i think that syntax is right, can't remember

[MrSpeed]

>>do you have the option of using command line?

No.

[jatar_k]

Whenever I have had to deal with large I have had to go by commmand line.

Another option is running LOAD DATA [mysql.com] or just executing all of the inserts/creates either by issuing the commands through phpmyadmin or writing a quick script that will do it. The biggest problem you will have will be if the dump file is huge then both may time out.