Re: Backup of a MySQL database.

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" <dewaard@netcollective.nl> escribió en el mensaje news:587E23EC-7C52-11D8-AF90-000A95B959C0@netcollective.nl... > 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