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

Thu, 01 November 2012 13:41

Richard Yates
Messages: 86
Registered: September 2013

Karma:

Member

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?

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: Fri Nov 22 04:55:34 GMT 2024

Total time taken to generate the page: 0.04120 seconds