Importing a large sql file

[misheck]

I am using wordpress for my website but now I am looking at transfering to a new webhost but I am having difficulties transfering my mysql files. The sql file is 16mb long and when I try insert into phpmyadmin nothing happens and also when I try inserting it using mysql commandline nothing happens again.

 

Is there a way of importing  a sql file?

[BlueSkyIS]

you can usually import a large file by using

 

SOURCE path/to/file

 

from mysql command line.

[misheck]

Thanks I will try this on my local machine but what can I use when I need to do it my website host?

[BlueSkyIS]

if you can't use phpmyadmin, it's probably because the file size is too large. if you can't alter php.ini to allow for larger files, larger uploads, and probably a larger execute time limit, you'll probably have to cut the file into smaller pieces and load them individually via phpmyadmin.