FUDforum: comp.lang.php » phpmyadmin export

Home » Imported messages » comp.lang.php » phpmyadmin export

Show: Today's Messages :: Polls :: Message Navigator

Re: phpmyadmin export [message #179611 is a reply to message #179606]

Tue, 13 November 2012 08:05

Michael Vilain
Messages: 88
Registered: September 2010

Karma:

Member

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.
>>
>> 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.....

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.

--
DeeDee, don't press that button! DeeDee! NO! Dee...
[I filter all Goggle Groups posts, so any reply may be automatically ignored]

Report message to a moderator

[Message index]

		phpmyadmin export By: Richard Yates on Thu, 01 November 2012 04:04
		Re: phpmyadmin export By: Michael Vilain on Thu, 01 November 2012 05:37
		Re: phpmyadmin export By: The Natural Philosoph on Thu, 01 November 2012 10:17
		Re: phpmyadmin export By: Richard Yates on Thu, 01 November 2012 13:41
		Re: phpmyadmin export By: Jerry Stuckle on Thu, 01 November 2012 13:51
		Re: phpmyadmin export By: The Natural Philosoph on Thu, 01 November 2012 16:49
		Re: phpmyadmin export By: Thomas 'PointedEars' on Thu, 01 November 2012 20:29
		Re: phpmyadmin export By: Luuk on Fri, 02 November 2012 19:04
		Re: phpmyadmin export By: Luuk on Thu, 01 November 2012 18:39
		Re: phpmyadmin export By: Richard Yates on Fri, 09 November 2012 05:01
		Re: phpmyadmin export By: Michael Vilain on Fri, 09 November 2012 08:11
		Re: phpmyadmin export By: Michael Vilain on Mon, 12 November 2012 07:50
		Re: phpmyadmin export By: Luuk on Mon, 12 November 2012 19:03
		Re: phpmyadmin export By: Michael Vilain on Tue, 13 November 2012 08:05
		Re: phpmyadmin export By: M. Strobel on Tue, 13 November 2012 09:25
		Re: phpmyadmin export By: Jerry Stuckle on Fri, 09 November 2012 12:35

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) ] [

]

Current Time: Thu Nov 21 22:30:33 GMT 2024

Total time taken to generate the page: 0.09079 seconds