Forums

Reverse Engineer MySQL db Table -> db.xml

Permalink 2 users found helpful
This is getting annoying - I've got these huge tables that already exist and it's getting a little old having to manually create the db.xml file... I tried the one here:

http://www.tangraframework.net/mysql_axmls.php...

But it seems to generate an error for anything but a really simple table.

Any ideas? suggestions? I'm really not in the mood to manually create the db.xml file if I can help it :(
jtrelfa
 
jtrelfa replied on at Permalink Best Answer Reply
jtrelfa
Found the answer (sorry - was getting frustrated)

1. Download ADODB5http://sourceforge.net/projects/adodb/files/adodb-php5-only/adodb-5...
2. unzip it into a folder on your server
3. create a page for performing the extract (I called mine dbextract.php):
<?php
require( "adodb5/adodb.inc.php");
//remove the '03' from the file name to use axmls version 2
require( "adodb5/adodb-xmlschema03.inc.php" );
$platform = 'mysql';
$dbHost = 'localhost';
$dbName = 'db name';
$dbUser = 'db user';
$dbPassword = 'password';
$db = ADONewConnection( $platform );
$db->Connect( $dbHost, $dbUser, $dbPassword, $dbName );
$schema = new adoSchema( $db );
//the first arg is so you don't get the data, the second arg is what is used to indent the xml
echo $schema->ExtractSchema(FALSE,"\t");

4. visit the page you created (e.g.http://localhost/dbextract.php)...
5. Save the file
stephendmalloy replied on at Permalink Reply
stephendmalloy
This works well - you're the man. I even whipped up an interface and it works quite well...thanks! When I have time some day I'll probably create an add-on for this

This website stores cookies on your computer. These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media. To find out more about the cookies we use, see our Privacy Policy.