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


Groups > comp.lang.php > #7410 > unrolled thread

phpmyadmin export

Started byRichard Yates <richard@yatesguitar.com>
First post2012-10-31 21:04 -0700
Last post2012-11-09 07:35 -0500
Articles 16 — 7 participants

Back to article view | Back to comp.lang.php


Contents

  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

#7410 — phpmyadmin export

FromRichard Yates <richard@yatesguitar.com>
Date2012-10-31 21:04 -0700
Subjectphpmyadmin export
Message-ID<g1t398hmljqrkvr1htkgbartoaq03tpql9@4ax.com>
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

[toc] | [next] | [standalone]


#7411

FromMichael Vilain <vilain@NOspamcop.net>
Date2012-10-31 22:37 -0700
Message-ID<vilain-E54CFB.22375531102012@news.individual.net>
In reply to#7410
In article <g1t398hmljqrkvr1htkgbartoaq03tpql9@4ax.com>,
 Richard Yates <richard@yatesguitar.com> 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

AFAIK, phpmyadmin uses mysqladmin to extract the tables from MySQL.  You 
might look at a good MySQL manual and learn how to do it by hand rather 
than relying on phpmysql.  It require you to change the internal 
mysqladmin command to include comments, if such an option exists.

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

[toc] | [prev] | [next] | [standalone]


#7412

FromThe Natural Philosopher <tnp@invalid.invalid>
Date2012-11-01 10:17 +0000
Message-ID<k6ti8i$ldp$1@news.albasani.net>
In reply to#7411
On 01/11/12 05:37, Michael Vilain wrote:
> In article <g1t398hmljqrkvr1htkgbartoaq03tpql9@4ax.com>,
>   Richard Yates <richard@yatesguitar.com> 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
>
> AFAIK, phpmyadmin uses mysqladmin to extract the tables from MySQL.  You
> might look at a good MySQL manual and learn how to do it by hand rather
> than relying on phpmysql.  It require you to change the internal
> mysqladmin command to include comments, if such an option exists.
>
I think it does..it (phpmyadmin) probably invokes mysqldump which seems 
to take --comments as an argument


-- 
Ineptocracy

(in-ep-toc’-ra-cy) – a system of government where the least capable to 
lead are elected by the least capable of producing, and where the 
members of society least likely to sustain themselves or succeed, are 
rewarded with goods and services paid for by the confiscated wealth of a 
diminishing number of producers.

[toc] | [prev] | [next] | [standalone]


#7413

FromRichard Yates <richard@yatesguitar.com>
Date2012-11-01 06:41 -0700
Message-ID<cou498hg12f96od4keup15pcemo8ir3m07@4ax.com>
In reply to#7412
On Thu, 01 Nov 2012 10:17:56 +0000, The Natural Philosopher
<tnp@invalid.invalid> wrote:

>On 01/11/12 05:37, Michael Vilain wrote:
>> In article <g1t398hmljqrkvr1htkgbartoaq03tpql9@4ax.com>,
>>   Richard Yates <richard@yatesguitar.com> 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
>>
>> AFAIK, phpmyadmin uses mysqladmin to extract the tables from MySQL.  You
>> might look at a good MySQL manual and learn how to do it by hand rather
>> than relying on phpmysql.  It require you to change the internal
>> mysqladmin command to include comments, if such an option exists.
>>
>I think it does..it (phpmyadmin) probably invokes mysqldump which seems 
>to take --comments as an argument

Thanks. I found the "--comments" switch in the mysql manual, but I do
not know how to run mysqldump (or anything else mysql) except through
phpmyadmin and php scripts. I found this on a tech site: 

"If you wish to perform a MySQL dump manually, without using a
PHPMyAdmin tool or other graphic environment, you need to connect to
your database via SSH and run the following command:..."

What is SSH? How do I execute a manual dump with mysqldump without
phpmyadmin?

[toc] | [prev] | [next] | [standalone]


#7414

FromJerry Stuckle <jstucklex@attglobal.net>
Date2012-11-01 09:51 -0400
Message-ID<k6tuo7$18s$1@dont-email.me>
In reply to#7413
On 11/1/2012 9:41 AM, Richard Yates wrote:
> On Thu, 01 Nov 2012 10:17:56 +0000, The Natural Philosopher
> <tnp@invalid.invalid> wrote:
>
>> On 01/11/12 05:37, Michael Vilain wrote:
>>> In article <g1t398hmljqrkvr1htkgbartoaq03tpql9@4ax.com>,
>>>    Richard Yates <richard@yatesguitar.com> 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
>>>
>>> AFAIK, phpmyadmin uses mysqladmin to extract the tables from MySQL.  You
>>> might look at a good MySQL manual and learn how to do it by hand rather
>>> than relying on phpmysql.  It require you to change the internal
>>> mysqladmin command to include comments, if such an option exists.
>>>
>> I think it does..it (phpmyadmin) probably invokes mysqldump which seems
>> to take --comments as an argument
>
> Thanks. I found the "--comments" switch in the mysql manual, but I do
> not know how to run mysqldump (or anything else mysql) except through
> phpmyadmin and php scripts. I found this on a tech site:
>
> "If you wish to perform a MySQL dump manually, without using a
> PHPMyAdmin tool or other graphic environment, you need to connect to
> your database via SSH and run the following command:..."
>
> What is SSH? How do I execute a manual dump with mysqldump without
> phpmyadmin?
>

This isn't a PHP question.  Try comp.databases.mysql.

-- 
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[toc] | [prev] | [next] | [standalone]


#7416

FromThe Natural Philosopher <tnp@invalid.invalid>
Date2012-11-01 16:49 +0000
Message-ID<k6u96v$euf$1@news.albasani.net>
In reply to#7413
On 01/11/12 13:41, Richard Yates wrote:
> On Thu, 01 Nov 2012 10:17:56 +0000, The Natural Philosopher
> <tnp@invalid.invalid> wrote:
>
>> On 01/11/12 05:37, Michael Vilain wrote:
>>> In article <g1t398hmljqrkvr1htkgbartoaq03tpql9@4ax.com>,
>>>    Richard Yates <richard@yatesguitar.com> 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
>>>
>>> AFAIK, phpmyadmin uses mysqladmin to extract the tables from MySQL.  You
>>> might look at a good MySQL manual and learn how to do it by hand rather
>>> than relying on phpmysql.  It require you to change the internal
>>> mysqladmin command to include comments, if such an option exists.
>>>
>> I think it does..it (phpmyadmin) probably invokes mysqldump which seems
>> to take --comments as an argument
>
> Thanks. I found the "--comments" switch in the mysql manual, but I do
> not know how to run mysqldump (or anything else mysql) except through
> phpmyadmin and php scripts. I found this on a tech site:
>
> "If you wish to perform a MySQL dump manually, without using a
> PHPMyAdmin tool or other graphic environment, you need to connect to
> your database via SSH and run the following command:..."
>
> What is SSH? How do I execute a manual dump with mysqldump without
> phpmyadmin?
>
Ah. I see. This is a hosted server to which you have very limited access...

hence the dreadful phpadmin.

IF you have a linux  machine you just  type ssh <my remote server> and 
with luck it will accept a connection from you.

http://www.phpmyadmin.net/documentation/#faqexport

"Add into comments" includes column comments, relations, and MIME types 
set in the pmadb in the dump as SQL comments (/* xxx */).




-- 
Ineptocracy

(in-ep-toc’-ra-cy) – a system of government where the least capable to 
lead are elected by the least capable of producing, and where the 
members of society least likely to sustain themselves or succeed, are 
rewarded with goods and services paid for by the confiscated wealth of a 
diminishing number of producers.

[toc] | [prev] | [next] | [standalone]


#7419

FromThomas 'PointedEars' Lahn <PointedEars@web.de>
Date2012-11-01 21:29 +0100
Message-ID<1804943.i1rY43TrDM@PointedEars.de>
In reply to#7411
Michael Vilain wrote:

> Richard Yates <richard@yatesguitar.com> 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?
> 
> AFAIK, phpmyadmin uses mysqladmin to extract the tables from MySQL.  […]

That would be surprising since AFAIK phpMyAdmin runs without exec() 
permission.  Using the functions provided by either the `mysql' or the 
`mysqli' PHP extension, both of which phpMyAdmin supports, it is already 
possible to extract that information using MySQL statements.  And indeed, I 
could not find an occurrence of `mysqladmin' in the phpMyAdmin source code, 
which is another strong indication that you are mistaken here.


PointedEars
-- 
When all you know is jQuery, every problem looks $(olvable).

[toc] | [prev] | [next] | [standalone]


#7433

FromLuuk <luuk@invalid.lan>
Date2012-11-02 20:04 +0100
Message-ID<f2idm9-8jf.ln1@luuk.invalid.lan>
In reply to#7419
On 01-11-2012 21:29, Thomas 'PointedEars' Lahn wrote:
> Michael Vilain wrote:
>
>> Richard Yates <richard@yatesguitar.com> 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?
>>
>> AFAIK, phpmyadmin uses mysqladmin to extract the tables from MySQL.  […]
>
> That would be surprising since AFAIK phpMyAdmin runs without exec()
> permission.  Using the functions provided by either the `mysql' or the
> `mysqli' PHP extension, both of which phpMyAdmin supports, it is already
> possible to extract that information using MySQL statements.  And indeed, I
> could not find an occurrence of `mysqladmin' in the phpMyAdmin source code,
> which is another strong indication that you are mistaken here.
>
>
> PointedEars
>

A simple:
SHOW CREATE tablename

will show the results, with comments

[toc] | [prev] | [next] | [standalone]


#7418

FromLuuk <luuk@invalid.lan>
Date2012-11-01 19:39 +0100
Message-ID<t7sam9-432.ln1@luuk.invalid.lan>
In reply to#7410
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......


This is in Version information: 3.5.2.2 of phpMyAdmin.
The latest stable version is 3.5.3

[toc] | [prev] | [next] | [standalone]


#7505

FromRichard Yates <richard@yatesguitar.com>
Date2012-11-08 21:01 -0800
Message-ID<oe3p9852lkjutl0jbqo5cgssu8kkmlvdqg@4ax.com>
In reply to#7418
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. 

[toc] | [prev] | [next] | [standalone]


#7506

FromMichael Vilain <vilain@NOspamcop.net>
Date2012-11-09 00:11 -0800
Message-ID<vilain-8DC764.00110309112012@news.individual.net>
In reply to#7505
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.

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

[toc] | [prev] | [next] | [standalone]


#7529

FromMichael Vilain <vilain@NOspamcop.net>
Date2012-11-11 23:50 -0800
Message-ID<vilain-5AE978.23503811112012@news.individual.net>
In reply to#7506
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.

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

[toc] | [prev] | [next] | [standalone]


#7537

FromLuuk <luuk@invalid.lan>
Date2012-11-12 20:03 +0100
Message-ID<gpt7n9-tii.ln1@luuk.invalid.lan>
In reply to#7529
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.....

[toc] | [prev] | [next] | [standalone]


#7542

FromMichael Vilain <vilain@NOspamcop.net>
Date2012-11-13 00:05 -0800
Message-ID<vilain-0A1B61.00054513112012@news.individual.net>
In reply to#7537
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.
> >
> > 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]

[toc] | [prev] | [next] | [standalone]


#7543

From"M. Strobel" <sorry_no_mail_here@nowhere.dee>
Date2012-11-13 10:25 +0100
Message-ID<agei17F18tiU1@mid.uni-berlin.de>
In reply to#7542
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.

[toc] | [prev] | [next] | [standalone]


#7508

FromJerry Stuckle <jstucklex@attglobal.net>
Date2012-11-09 07:35 -0500
Message-ID<k7itbe$4ud$1@dont-email.me>
In reply to#7505
On 11/9/2012 12:01 AM, Richard Yates 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.
>

As I told you before.  This is not a PHP question.  Ask in the correct 
newsgroup and you have a better chance of getting a good answer.

But some people are just too dense or too stoopid to understand such a 
simple concept.

-- 
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[toc] | [prev] | [standalone]


Back to top | Article view | comp.lang.php


csiph-web