nitromaster Posted August 8, 2009 Share Posted August 8, 2009 Hi Basically I have a dump of an sql file for my site, from a previous hosting which has now expired. Got new hosting, need to import it. It's only 2MB, pretty small i guess, but I have a really shit connection, and so far have fail to upload it to phpmyadmin via my web browser. Any idea on the best way to upload it would be? I was thinking of splitting it, but how? Or any other ideas would be great. Thanks Quote Link to comment https://forums.phpfreaks.com/topic/169293-solved-importing-large-sql-file-into-database/ Share on other sites More sharing options...
abazoskib Posted August 8, 2009 Share Posted August 8, 2009 you have ssh access? Quote Link to comment https://forums.phpfreaks.com/topic/169293-solved-importing-large-sql-file-into-database/#findComment-893367 Share on other sites More sharing options...
nitromaster Posted August 8, 2009 Author Share Posted August 8, 2009 i could upgrade and get it enabled if needed. I mean if there's no other simple way. Quote Link to comment https://forums.phpfreaks.com/topic/169293-solved-importing-large-sql-file-into-database/#findComment-893373 Share on other sites More sharing options...
abazoskib Posted August 8, 2009 Share Posted August 8, 2009 what about ftp? Quote Link to comment https://forums.phpfreaks.com/topic/169293-solved-importing-large-sql-file-into-database/#findComment-893393 Share on other sites More sharing options...
cybernet Posted August 8, 2009 Share Posted August 8, 2009 what about ftp? ftp for a mysql database ? are kiddin' me ? maybe if he has access to the database directory ( /var/lib/mysql/database_name_here ) but he will still need a mysql server to transform his dump into mysql database files .MY* Quote Link to comment https://forums.phpfreaks.com/topic/169293-solved-importing-large-sql-file-into-database/#findComment-893481 Share on other sites More sharing options...
cybernet Posted August 8, 2009 Share Posted August 8, 2009 Hi Basically I have a dump of an sql file for my site, from a previous hosting which has now expired. Got new hosting, need to import it. It's only 2MB, pretty small i guess, but I have a really shit connection, and so far have fail to upload it to phpmyadmin via my web browser. Any idea on the best way to upload it would be? I was thinking of splitting it, but how? Or any other ideas would be great. Thanks i can give you my mysql host if you wanna use one it's open 24/7 PM if you need Quote Link to comment https://forums.phpfreaks.com/topic/169293-solved-importing-large-sql-file-into-database/#findComment-893482 Share on other sites More sharing options...
abazoskib Posted August 8, 2009 Share Posted August 8, 2009 what about ftp? ftp for a mysql database ? are kiddin' me ? maybe if he has access to the database directory ( /var/lib/mysql/database_name_here ) but he will still need a mysql server to transform his dump into mysql database files .MY* i dont know about phpmyadmin, but i can load local data infile on the command line if i ftp a file onto my server. so no i am not kidding you, drama queen. Quote Link to comment https://forums.phpfreaks.com/topic/169293-solved-importing-large-sql-file-into-database/#findComment-893631 Share on other sites More sharing options...
nitromaster Posted August 9, 2009 Author Share Posted August 9, 2009 Hi Yes I have ftp support. I tried using bigdump but this kept throwing "delimiter" errors. How would I do it via command line? Thanks for your help. Quote Link to comment https://forums.phpfreaks.com/topic/169293-solved-importing-large-sql-file-into-database/#findComment-894224 Share on other sites More sharing options...
nitromaster Posted August 9, 2009 Author Share Posted August 9, 2009 Okay. Eventually got it working with BigDump =) Quote Link to comment https://forums.phpfreaks.com/topic/169293-solved-importing-large-sql-file-into-database/#findComment-894382 Share on other sites More sharing options...
abazoskib Posted August 9, 2009 Share Posted August 9, 2009 http://dev.mysql.com/doc/refman/5.1/en/load-data.html use the 'load LOCAL...' version, and point it to the file you uploaded by ftp. you can set field and line delimiters too. hope you get everything sorted. Quote Link to comment https://forums.phpfreaks.com/topic/169293-solved-importing-large-sql-file-into-database/#findComment-894383 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.