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

>On Jan 3, 3:37pm, "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 --' 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)