How to import 300 mb file?

[turifungia]

I need to import but I get error : any suggestion, please?

Thanks
Turifungia

 

[scsi]

What kind of 300mb file?

 

[turifungia]

sql (sorry)

 

[RHS-Chris]

Fastest, and easiest way is through the command line. If you have shell access, use this:

mysql dbname < filename.sql -u user --password=pass

Make sure you run that in the directory where the filename.sql is located.

 

[turifungia]

I use Phpmyadmin and i can't find this..

 

[RHS-Chris]

If you do not have shell access, you can ask your host to import the database for you, or, try alternate means, one being big dump:

http://www.ozerov.de/bigdump.php

I've not used it, however, I have heard it works. Another would be MySQLDumper:

http://www.mysqldumper.net/

Again, I've not used it, however, I have heard that it works.

 

[turifungia]

Great!!

Chris ..u save my life!!
This tool is awesome!!


Many thanks