Thanks for the help Ted. Is this format the dump that you can import
into Dia? or is it just a schema XML output? I can give it a try, but I
think the Dia XML is going to be a bit different.
I might try converting the Perl based MySQL2Dia script (GenDia.pm) into
something I can use but some of their variable substitutions are
confusing to me.
On 02/12/2014 09:32 AM, Ted Roche wrote:
<?xml version="1.0" encoding="utf-8"?> <!-- - phpMyAdmin XML Dump -
version 3.4.9 - http://www.phpmyadmin.net - - Host: localhost -
Generation Time: Feb 12, 2014 at 09:30 AM - Server version: 5.0.95 -
PHP Version: 5.3.21 --> <pma_xml_export version="1.0" xmlns:pma="
http://www.phpmyadmin.net/some_doc_url/";> <!-- - Structure schemas -->
<pma:structure_schemas> <pma:database name="sample"
collation="utf8_general_ci" charset="utf8"> <pma:table name="User">
CREATE TABLE `User` ( `iUserPK` bigint(20) NOT NULL auto_increment,
`cUserName` char(25) default NULL, `cUserInitials` char(10) default
NULL, `lActive` enum('Y','N') default NULL, `lAdmin` enum('Y','N')
default NULL, `tChanged` timestamp NULL default CURRENT_TIMESTAMP,
`cDatabase` char(20) default NULL, PRIMARY KEY (`iUserPK`) )
ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8; </pma:table>
</pma:database> </pma:structure_schemas> </pma_xml_export>
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
