Convert .myd file to SQL Query?

On Jan 3, 3:37*pm, "Rik Wasmus" <luiheidsgoe...@hotmail.com> wrote:
> On Thu, 03 Jan 2008 22:27:40 +0100, <karlj...@gmail.com> wrote:
> > Sorry guys- yep Peter has it:
>
> > ERROR 1064 (42000): You have an error in your SQL syntax; check the
> > manual that corresponds to your MySQL server version for the right
> > syntax to use near 'mysqldump --help' at line 1
>
> And that would be because mysqldump is run from the shell, not the mysql *
> prompt (i.e. it's not a query of some sorts, it's a program).
> --
> Rik Wasmus

Thanks for the information. Any idea where the mysqldump program can
be downloaded (or otherwise purchased)? My searches arent turning up
much.

On Thu, 3 Jan 2008 15:41:19 -0800 (PST),
karljcox@gmail.com wrote:

>On Jan 3, 3:37*pm, "Rik Wasmus" <luiheidsgoe...@hotmail.com> wrote:
>> On Thu, 03 Jan 2008 22:27:40 +0100, <karlj...@gmail.com> wrote:
>> > Sorry guys- yep Peter has it:
>>
>> > ERROR 1064 (42000): You have an error in your SQL syntax; check the
>> > manual that corresponds to your MySQL server version for the right
>> > syntax to use near 'mysqldump --help' at line 1
>>
>> And that would be because mysqldump is run from the shell, not the mysql *
>> prompt (i.e. it's not a query of some sorts, it's a program).
>> --
>> Rik Wasmus
>
>Thanks for the information. Any idea where the mysqldump program can
>be downloaded (or otherwise purchased)? My searches arent turning up
>much.

It is in the same directory as your mysql.exe
to find it from a CMD window, do :

dir /b /s C:\mysqldump.exe

Read:
http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html

Everywhere where it shows the
shell>
prompt, it assumes you are in a CMD window.
--
( Kees
)
c[_] -"If we are going to teach creation science as an alternative to
evolution, then we should also teach the stork theory as an
alternative to biological reproduction." (Judith Hayes)
-"You mean my mum wasn't telling me the truth?" (Jeff Gaines) (#147)

On Jan 3, 5:59*pm, Kees Nuyt <k.n...@nospam.demon.nl> wrote:
> On Thu, 3 Jan 2008 15:41:19 -0800 (PST),
>
>
>
>
>
> karlj...@gmail.com wrote:
> >On Jan 3, 3:37*pm, "Rik Wasmus" <luiheidsgoe...@hotmail.com> wrote:
> >> On Thu, 03 Jan 2008 22:27:40 +0100, <karlj...@gmail.com> wrote:
> >> > Sorry guys- yep Peter has it:
>
> >> > ERROR 1064 (42000): You have an error in your SQL syntax; check the
> >> > manual that corresponds to your MySQL server version for the right
> >> > syntax to use near 'mysqldump --help' at line 1
>
> >> And that would be because mysqldump is run from the shell, not the mysql *
> >> prompt (i.e. it's not a query of some sorts, it's a program).
> >> --
> >> Rik Wasmus
>
> >Thanks for the information. *Any idea where the mysqldump program can
> >be downloaded (or otherwise purchased)? *My searches arent turning up
> >much.
>
> It is in the same directory as your mysql.exe
> to find it from a CMD window, do :
>
> dir /b /s C:\mysqldump.exe
>
> Read:http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html
>
> Everywhere where it shows the
> * * * * shell>
> prompt, it assumes you are in a CMD window.
> --
> *( *Kees
> * )
> c[_] -"If we are going to teach creation science as an alternative to
> * * *evolution, then we should also teach the stork theory as an
> * * *alternative to biological reproduction." (Judith Hayes)
> * * *-"You mean my mum wasn't telling me the truth?" (Jeff Gaines) *(#147)- Hide quoted text -
>
> - Show quoted text -

Found it- It was in the bin folder. Thanks for the help guys.