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

Groups > comp.lang.php > #7543

Re: phpmyadmin export

Show all headers | View raw

Am 13.11.2012 09:05, schrieb Michael Vilain:
> In article <gpt7n9-tii.ln1@luuk.invalid.lan>, Luuk <luuk@invalid.lan> 
> wrote:
> 
>> 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.
>>>
--cut--
>>>
>>
>> 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.....
> 
> Assuming the OP can do that query, extract the result, and format it for 
> each table.  If there are 500 tables, seems like writing a script is 
> what needs to happen, assuming they can do that.

To give the OP some ideas: I have a (admin) script that can send any database table
as excel download.

In the database I have some views that can give me all the table, view and function
names together with their comments. I can download it with one click to Excel/OO
Calc. No need for yet another tool set.

My db is postgresql.

/Str.

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