Can anyone post a link to a good reference material on how to do this...
evidentely mysqldump is not working here... and i need to do this via php
programming.
I'm sure you will find prewritten scripts with Google and I know phpmyadmin does it to.
Without giving it much though my first reaction to your question is pretty straigtforward: use SHOW TABLES to find out which tables are in the DB and then just do SHOW COLUMNS FROM table for each table. Then you can query the table using SELECT * FROM table and create the insert using the knowledge you have gained about the columns in that table.
However, I would like to suggest looking for a prewritten solution, since it's probably not necessary to reinvent the wheel here...
Regards,
Filip de Waard
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
