Both the Importing XML Data into MySQL Tables Using a Stored Procedure and the Enhance Your MySQL XML Import Procedures using Prepared Statements tutorials described a way to overcome MySQL’s import restrictions using the “proc-friendly” Load_File() and ExtractValue() functions. While by no means a perfect solution, it got the job done.
Now it’s time to take a step back and ask ourselves how to best load large amounts of external data into our MySQL database(s) as efficiently as possible.
