Import large sql file using mysql console

[amrigo]

Hi

I am using windows and need to importa a large sql file, it have 2.5gb.

I try to use phpmyadmin but the limit for phpmyadmin is 2gb.

Is there a comand line for mysql using DOS, opening the mysql console to importa a .sql file ?

Thank´s in advance

[vasyapupkin]

mysql < file.sql ?

[opifex]

The easiest way is to split the original sql file into manageable blocks... a separate file for each table maybe since your data base is so large.
You can do this manually from the file that you already have... or export the original sql in blocks as separate files.