FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.
Home » Imported messages » comp.lang.php » phpmyadmin export
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
Re: phpmyadmin export [message #179612 is a reply to message #179611] Tue, 13 November 2012 09:25 Go to previous messageGo to previous message
M. Strobel is currently offline  M. Strobel
Messages: 386
Registered: December 2011
Karma:
Senior Member
Am 13.11.2012 09:05, schrieb Michael Vilain:
> In article <gpt7n9-tii(dot)ln1(at)luuk(dot)invalid(dot)lan>, Luuk <luuk(at)invalid(dot)lan>
> wrote:
>
>> On 12-11-2012 08:50, Michael Vilain wrote:
>>> In article <vilain-8DC764(dot)00110309112012(at)news(dot)individual(dot)net>,
>>> Michael Vilain <vilain(at)NOspamcop(dot)net> wrote:
>>>
>>>> In article <oe3p9852lkjutl0jbqo5cgssu8kkmlvdqg(at)4ax(dot)com>,
>>>> Richard Yates <richard(at)yatesguitar(dot)com> wrote:
>>>>
>>>> > On Thu, 01 Nov 2012 19:39:30 +0100, Luuk <luuk(at)invalid(dot)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.

Report message to a moderator

[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Message queues not working properly PHP -> C
Next Topic: file_get_contents doesn’t access one URL
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Nov 24 18:20:00 GMT 2024

Total time taken to generate the page: 0.13271 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.1.3.
Copyright ©2001-2023 FUDforum Bulletin Board Software