One of my favorite tools to play around with when working with MySQL databases is PHPMyAdmin. This web-based tool allows you to do quite a bit, including importing Excel files into your web-based MySQL database. This is a life-saver! I wasn’t always a fan…the one feature I wished for, PHPMyAdmin didn’t seem to be able to do for me. Of course, I was still learning how to use a complex tool…now, it’s something I teach my team responsible for maintaining Moodle backups, etc.
Since I was running off a XAMPP (local installation), I found that the pre-installed version of PHPMyAdmin wasn’t working easily with the import of a CSV file. I’d previously learned about the right import settings, shown below (click to enlarge):
Get Blog Updates via Email!
Enter your email address:
Everything posted on Miguel Guhlin’s blogs/wikis are his personal opinion and do not necessarily represent the views of his employer(s) or its clients. Read Full Disclosure