misheck Posted October 3, 2010 Share Posted October 3, 2010 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? Quote Link to comment https://forums.phpfreaks.com/topic/215080-importing-a-large-sql-file/ Share on other sites More sharing options...
BlueSkyIS Posted October 3, 2010 Share Posted October 3, 2010 you can usually import a large file by using SOURCE path/to/file from mysql command line. Quote Link to comment https://forums.phpfreaks.com/topic/215080-importing-a-large-sql-file/#findComment-1118711 Share on other sites More sharing options...
misheck Posted October 4, 2010 Author Share Posted October 4, 2010 Thanks I will try this on my local machine but what can I use when I need to do it my website host? Quote Link to comment https://forums.phpfreaks.com/topic/215080-importing-a-large-sql-file/#findComment-1118807 Share on other sites More sharing options...
BlueSkyIS Posted October 4, 2010 Share Posted October 4, 2010 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. Quote Link to comment https://forums.phpfreaks.com/topic/215080-importing-a-large-sql-file/#findComment-1118900 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.