RE: [PEAR] DB ?

> From: Benoit des Ligneris [mailto:benoit@des.ligneris.net] > Sent: Friday, March 14, 2003 1:25 PM > To: pear-general@lists.php.net > Subject: [PEAR] DB ? > > Hello, > > I uses PEAR::DB since a few days instead of a home made abstraction > layer. > > Is there a "best practice" solution to dump the content of the database, > create the database and fill the database ? > > Actually, I use my "old" system that is very DB dependant : > - DB dump : mysqldump > - DB fill : mysql > - DB creation : mysqladmin > > All this is encapsulated in a class but, I don't want to write all the > methods depending on the DB we want to support (different type, different > commands, > ...). > > What is the recommended PEAR solution to do those actions in a > DB-independent way ? PEAR::DB does not feature database management capabilities. PEAR::MDB however does. There all the necessary methods to manage a database exist. Furthermore there is an RDBMS independent xml based syntax to manage schemas and to move data from one RDBMS to another. The Package homepage is here: http://pear.php.net/package-info.php?package=MDB Here is the link to an article that explains the above mentioned feature in great detail: http://www.php-mag.net/itr/online_artikel/show.php3?id=283&nodeid=114 Regards, Lukas