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 #179598 is a reply to message #179575]

Mon, 12 November 2012 07:50

Michael Vilain
Messages: 88
Registered: September 2010

Karma:

Member

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.

--
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: Sun Nov 24 20:59:42 GMT 2024

Total time taken to generate the page: 0.04798 seconds