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

Groups > comp.lang.php > #7433

Re: phpmyadmin export

Path csiph.com!usenet.pasdenom.info!aioe.org!news.stack.nl!newsfeed.xs4all.nl!newsfeed5.news.xs4all.nl!xs4all!post.news.xs4all.nl!not-for-mail
Date Fri, 02 Nov 2012 20:04:20 +0100
From Luuk <luuk@invalid.lan>
User-Agent Mozilla/5.0 (Windows NT 6.1; WOW64; rv:16.0) Gecko/20121026 Thunderbird/16.0.2
MIME-Version 1.0
Newsgroups comp.lang.php
Subject Re: phpmyadmin export
References <g1t398hmljqrkvr1htkgbartoaq03tpql9@4ax.com> <vilain-E54CFB.22375531102012@news.individual.net> <1804943.i1rY43TrDM@PointedEars.de>
In-Reply-To <1804943.i1rY43TrDM@PointedEars.de>
Content-Type text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding 8bit
Message-ID <f2idm9-8jf.ln1@luuk.invalid.lan> (permalink)
Lines 27
NNTP-Posting-Host 2001:980:9089:1:8c87:1dc3:53d6:375a
X-Trace 1351883401 news.xs4all.nl 6892 [2001:980:9089:1:8c87:1dc3:53d6:375a]:43495
X-Complaints-To abuse@xs4all.nl
Xref csiph.com comp.lang.php:7433

Show key headers only | View raw

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

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