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 #179481 is a reply to message #179480]

Thu, 01 November 2012 13:51

Jerry Stuckle
Messages: 2598
Registered: September 2010

Karma:

Senior Member

On 11/1/2012 9:41 AM, Richard Yates wrote:
> On Thu, 01 Nov 2012 10:17:56 +0000, The Natural Philosopher
> <tnp(at)invalid(dot)invalid> wrote:
>
>> On 01/11/12 05:37, Michael Vilain wrote:
>>> In article <g1t398hmljqrkvr1htkgbartoaq03tpql9(at)4ax(dot)com>,
>>> Richard Yates <richard(at)yatesguitar(dot)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(at)attglobal(dot)net
==================

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 17:12:41 GMT 2024

Total time taken to generate the page: 0.08088 seconds