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

Thu, 01 November 2012 16:49

The Natural Philosoph
Messages: 993
Registered: September 2010

Karma:

Senior Member

On 01/11/12 13:41, 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?
>
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.

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: Thu Nov 21 22:49:07 GMT 2024

Total time taken to generate the page: 0.05001 seconds