PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!
I'd suggest looking through raghavan20's posts in regex/databases .. I remember several threads on extracting the individual queries in a dump file for insertion that I was involved in. They might be linked from Useful Posts, but I can't recall that specificly.
The best and easy way to read the mysql dump is with phpmyadmin from control panel of the website. Otherwise you should tell the hosting company to enable execution of binaries for limited programs ...
AlexC_ do you have control of install/stage3/tables.sql, if you do why not change it to install/stage3/table.sql.php and put each separate query as a separate element of an array?
Of course I do, It's my CMS I'm coding! hehe- that's not a bad idea actaully and it would be better than XML
What do you mean with 'XML would be the best way'? And what would be the dtd/xsd of the xml file?
I was thinking of putting each query in the XML document then parsing it and running each query - might not be a good idea actaully
How about looking at phpBB's installation code then. phpMyAdmin is a bit rough, but phpBB code might be a little easier to read through.