MySql problem. Cannot fill database with .sql file

[Wojtek]

I'm trying and trying.

Via phpadmin = script times out
Via SSH = dosnt work :(

When I try to extraxt it via ssh, I do:

mysql -hlocalhost -unewsave -p*******

This gets me in to the sql promt:

mysql>

Now I write newsave_weather < hw3mysql.sql
and press enter.

It just skips to the next line with -> and I have to either do \c to break it or either exit.

And via phpmyadmin, it times out :(

It's a 10mb .sql file


Any ideas on how to do it?

Thanks

[Wojtek]

I found out I forgot something in the ssh command.
the ; at the end of the command.

I was hoping for it to work, but nop :(

You have an error in your SQL syntax near 'mysql -e "source /home/newsave/public_html/hw3mysql.sql" newsave_weather' at line 1

and

You have an error in your SQL syntax near 'newsave_weather < hw3mysql.sql' at line 1

[Kaliber]

10mb? Thats huge, perhaps you could split it up into smaller chunks, or get the structure up first then the data *or* upload the .sql file to your webserver and try using it as a local file.

Anyways, half of those probably won't work.

[Wojtek]

It's already uploaded.
It need to be uploaded to be able to call it from mysql, dosnt it?

Strcture and data after would be too complicated :(
But splitting *seems* like a probable solution.

Anyone else has some more info?