I was looking something more like a MySQL dump class or function... I think since i can't do any phpmyadmin or anything like that, that i will simply write my own code... yuk i was hoping to save 1-2 days work... thanks
vamp "Filip De Waard" <[EMAIL PROTECTED]> escribió en el mensaje news:[EMAIL PROTECTED] > On Mar 22, 2004, at 11:34 PM, Elliot J. Balanza wrote: > > > 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