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

Groups > comp.lang.php > #7414

Re: phpmyadmin export

Show all headers | View raw

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

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