Jump to content

Importing a large sql file


misheck

Recommended Posts

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?

Link to comment
https://forums.phpfreaks.com/topic/215080-importing-a-large-sql-file/
Share on other sites

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.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.