[wellylug] Mysqldump problem

[Jo Booth]

On 12/09/2005, at 11:51 , Michael Dittmer wrote:

> Hi Mark
>
> Fixed the shebang issue, but my script still complains about the -b
> option which as you can see isn't in the script.
>
[snip]
> On Mon, Sep 12, 2005 at 10:15:07AM +1200, Michael Dittmer wrote:
>
>> Hi
>>
>> The following is a script that I'm having some trouble with. The
>> permissions are set to 744.
>>
>> #bin/bash
>> rm /root/MySQL_BackUp/backup.sql
>> mysqldump -p --password=********* -alldatabases >
>> /root/MySQL_BackUp/backup.sql
>>
>> When I issue the command "mysqldump -p --password=*********
>> -alldatabases > /root/MySQL_BackUp/backup.sql" it works properly,
>> however when I try to use it inside the script it fails saying
>> "mysqldump: unknown option '-b'
>>
>> Any idea what is going on?
>>
>> Thanks
>>
>> Michael

I'll probably just confuse the issue - and this box doesn't have the  
man page -- but why are you mixing -'s and --'s in your arguments?   
maybe it's expanding the -alldatabases to -a -l -l -d -a -t -a -b...  
etc? I dunno.

-Jo.