[Phpmyadmin-devel] Suggestions for Import/Export Changes

[Derek Schaefer]

Hello Sebastian,

Thank you for the advice.

I had considered such a schema (as it is more akin to proper XML), but
ultimately I decided against it on the grounds that the plug-in
supports the export of database, table, view, trigger, function, and
procedure schemas. The problem is that between all of those there are
simply too many options to manually account for.

Therefore, I chose a hybrid schema that can be seen here:
http://www.moonlapse.org/?p=472

I'm still open to suggestions, though. The above schema is merely what
I am currently using.

-Derek Schaefer

On Mon, Jul 6, 2009 at 1:46 AM, Sebastian
Mendel<lists at sebastianmendel.de> wrote:
> Hi,
>
> On 01.07.2009 10:32, Michal Čihař wrote:
>>> Second, I would like to propose a new XML export format to better
>>> support my new import features. This new format will present the
>>> option to export the SQL creation code for each of the exported tables
>>> in the manner outlined below:
>>>
>>> <?xml version="1.0" encoding="utf-8" ?>
>>> <!--
>>> -
>>> - phpMyAdmin XML Dump
>>> - ... etc. etc. etc.
>>> -->
>>>
>>> <pma_xml_export version="1.0"
>>> xmlns:pma="http://www.phpmyadmin.net/some_doc_url/">
>>>      <pma:structure>
>>>          <pma:db_name>
>>>              <pma:tbl_name_1>CREATE TABLE `tbl_name_1`...</pma:tbl_name_1>
>>
>> Please make it proper XML then and do not (re)introduce variable tag
>> names.
>>
>> <pma:structure>
>>    <pma:db name="databaze">
>>       <pma:table name="tabulka">CREATE...</pma:table>
>>       ...
>>       <pma:view name="pohled">CREATE...</pma:view>
>>       <pma:trigger name="procedura">...</pma:trigger>
>>    </pma:db>
>> </pma:structure>
>
>
> will something like the following be too difficult? or inadequate for
> the purpose of the export?
>
> <pma:structure>
>   <pma:db name="databaze">
>      <pma:table name="tabulka" engine="MyISAM">
>        <pma:field name="myfield" type="int(11)" .../>
>        <pma:index name="myindex" type="BTREE" ...>
>          <pma:field name="myfield" length="255"/>
>        </pma:index>
>      </pma:table>
>      ...
>      <pma:view name="pohled">CREATE...</pma:view>
>      <pma:trigger name="procedura">...</pma:trigger>
>   </pma:db>
> </pma:structure>
>
> --
> Sebastian Mendel
>
> ------------------------------------------------------------------------------
> _______________________________________________
> Phpmyadmin-devel mailing list
> Phpmyadmin-devel at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
>