Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.php > #7537

Re: phpmyadmin export

Show all headers | View raw

On 12-11-2012 08:50, Michael Vilain wrote:
> In article <vilain-8DC764.00110309112012@news.individual.net>,
>   Michael Vilain <vilain@NOspamcop.net> wrote:
>
>> In article <oe3p9852lkjutl0jbqo5cgssu8kkmlvdqg@4ax.com>,
>>   Richard Yates <richard@yatesguitar.com> wrote:
>>
>>> On Thu, 01 Nov 2012 19:39:30 +0100, Luuk <luuk@invalid.lan> wrote:
>>>
>>>> On 01-11-2012 05:04, Richard Yates wrote:
>>>>> I cannot find a way of exporting (except as SQL) a mysql table that
>>>>> includes all the comments that I have added to each field in the table
>>>>> using phpmyadmin.
>>>>>
>>>>> Any ideas?
>>>>>
>>>>> Richard Yates
>>>>>
>>>
>>>> When you click 'Export', half way down the screeen, i see:
>>>>
>>>> Format-specific options:
>>>>
>>>> Display comments (includes info such as export timestamp, PHP version,
>>>> and server version)
>>>>
>>>> I tested this by selecting this option, and i did see a comment in my
>>>> export......
>>>>
>>>
>>> Right, but that is only for an SQL export. As I asked, I am trying to
>>> get an export with the comments in a format besides SQL.
>>
>> AFAIK, you'd need to write a utility that extracts the SQL and comments,
>> the strips out the SQL and formats the comments for the output you want.
>> I didn't get from your original post that you were exporting to
>> something other than SQL.  What other formats do you need?  How does
>> phpmyadmin generate that output (i.e. look at the code)?  Is there a way
>> to change the code generation to include comments?
>>
>> You'll probably have to roll your own here.  Get ready to roll up your
>> sleeves.
>
> I looked further into this.  SQL is the only format that will
> automatically extract comments from MySQL and include them into the
> export file.  The other formats do individual queries on a per-table
> basis and output things like CSV or EXCEL formatted files.  So you're
> going to have to download a version of phpmyadmin, modify it to query
> MySQL for the comment metadata (if that's even possible) and include
> that in your format.  Or you can output to MySQL and pull the comments
> out of the export file and format them for your import.
>
> Either way, you're on your own here.
>

Comments are fields stored in information_schema.columns

There will be NO need to change anything to phpMyAdmin, a simple script 
querying this table will be enough.....

Back to comp.lang.php | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

phpmyadmin export Richard Yates <richard@yatesguitar.com> - 2012-10-31 21:04 -0700
  Re: phpmyadmin export Michael Vilain <vilain@NOspamcop.net> - 2012-10-31 22:37 -0700
    Re: phpmyadmin export The Natural Philosopher <tnp@invalid.invalid> - 2012-11-01 10:17 +0000
      Re: phpmyadmin export Richard Yates <richard@yatesguitar.com> - 2012-11-01 06:41 -0700
        Re: phpmyadmin export Jerry Stuckle <jstucklex@attglobal.net> - 2012-11-01 09:51 -0400
        Re: phpmyadmin export The Natural Philosopher <tnp@invalid.invalid> - 2012-11-01 16:49 +0000
    Re: phpmyadmin export Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2012-11-01 21:29 +0100
      Re: phpmyadmin export Luuk <luuk@invalid.lan> - 2012-11-02 20:04 +0100
  Re: phpmyadmin export Luuk <luuk@invalid.lan> - 2012-11-01 19:39 +0100
    Re: phpmyadmin export Richard Yates <richard@yatesguitar.com> - 2012-11-08 21:01 -0800
      Re: phpmyadmin export Michael Vilain <vilain@NOspamcop.net> - 2012-11-09 00:11 -0800
        Re: phpmyadmin export Michael Vilain <vilain@NOspamcop.net> - 2012-11-11 23:50 -0800
          Re: phpmyadmin export Luuk <luuk@invalid.lan> - 2012-11-12 20:03 +0100
            Re: phpmyadmin export Michael Vilain <vilain@NOspamcop.net> - 2012-11-13 00:05 -0800
              Re: phpmyadmin export "M. Strobel" <sorry_no_mail_here@nowhere.dee> - 2012-11-13 10:25 +0100
      Re: phpmyadmin export Jerry Stuckle <jstucklex@attglobal.net> - 2012-11-09 07:35 -0500

csiph-web