I'm after a way to load a mySQL database through a PHP/HTML form, uploading an SQL dump file then running it through a script to execute all the SQL commands in the file.
I know phpmyadmin can do it, but this needs to be a standalone solution for client's uploads to a single table.
The phpmyadmin code is way, way too complicated to follow, and I can't seem to extract the section that deals with this.
I've checked the manuals for LOAD FILE, but AFAIK that only deals with CSV files, and they aren't an option in this particular case. (Client's demands - go figure...)
Any pointers?
I know phpmyadmin can do it, but this needs to be a standalone solution for client's uploads to a single table.
The phpmyadmin code is way, way too complicated to follow, and I can't seem to extract the section that deals with this.
I've checked the manuals for LOAD FILE, but AFAIK that only deals with CSV files, and they aren't an option in this particular case. (Client's demands - go figure...)
Any pointers?