sniperscope Posted March 21, 2013 Share Posted March 21, 2013 Hello I am facing a problem like importing huge (2.5gb) sql file into new server. Super moron who create web page, saved image files into db. So first i have to import that sql file then convert image strings into image file. The first thing i thought open sql file and insert one by one but this time i have two problem; one: db is huge so text editors cannot open it and second there is about 80.000 records in it. How can i handle this task? Regards Quote Link to comment https://forums.phpfreaks.com/topic/275961-huge-mysql-data-file/ Share on other sites More sharing options...
deepakfugo Posted March 21, 2013 Share Posted March 21, 2013 (edited) 2.5 GB is Massive for opening in normal text editor.... I had similar problem but mine was 1.5 GB of SQL file which i was able to open in Hex Editor(HxD). Try Hex for Opening the SQL file it might help u.... Also Its advised not to store Image/doc in Blob format. Edited March 21, 2013 by deepakfugo Quote Link to comment https://forums.phpfreaks.com/topic/275961-huge-mysql-data-file/#findComment-1420058 Share on other sites More sharing options...
sniperscope Posted March 21, 2013 Author Share Posted March 21, 2013 2.5 GB is Massive for opening in normal text editor.... I had similar problem but mine was 1.5 GB of SQL file which i was able to open in Hex Editor(HxD). Try Hex for Opening the SQL file it might help u.... Also Its advised not to store Image/doc in Blob format. Hello Thanks for advice. Personally, i never store image files into database. The someone did it who built homepage at first and now i have to clean up his mess because he used php script to display images therefor, server has load problem Quote Link to comment https://forums.phpfreaks.com/topic/275961-huge-mysql-data-file/#findComment-1420083 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.