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? Quote 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. Quote 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? Quote 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.. Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.