idratherbeintheair Posted July 2, 2011 Share Posted July 2, 2011 I need some help in a hurry on this one. I've got a database in both CSV format and also in Microsoft Access format. The CSV format is over 500MB. Anyway, because it's in access, I can get it into excel, xml, whatever. Anyway, it's over 65,000 records, and I've got to import it to mysql. It timeouts if I try to import it using phpmyadmin. Any ideas? Link to comment https://forums.phpfreaks.com/topic/240939-large-mysql-file-to-import/ Share on other sites More sharing options...
fenway Posted July 2, 2011 Share Posted July 2, 2011 Try the CSV engine type. Link to comment https://forums.phpfreaks.com/topic/240939-large-mysql-file-to-import/#findComment-1237736 Share on other sites More sharing options...
idratherbeintheair Posted July 2, 2011 Author Share Posted July 2, 2011 Try the CSV engine type. I'm not sure what you mean. Could you elaborate? Link to comment https://forums.phpfreaks.com/topic/240939-large-mysql-file-to-import/#findComment-1237741 Share on other sites More sharing options...
fenway Posted July 2, 2011 Share Posted July 2, 2011 See here.. Link to comment https://forums.phpfreaks.com/topic/240939-large-mysql-file-to-import/#findComment-1237747 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.