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 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 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. 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 Link to comment https://forums.phpfreaks.com/topic/275961-huge-mysql-data-file/#findComment-1420083 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.