[wellylug] Mysqldump problem

[Michael Dittmer]

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.

I'm calling the script using ./MySQL_Dump.sh

I'm going to use cron to call the script once I have the bugs worked
out.

Michael

-----Original Message-----
From: wellylug-admin at lists.wellylug.org.nz
[mailto:wellylug-admin at lists.wellylug.org.nz] On Behalf Of Mark
Sent: Monday, 12 September 2005 10:32 a.m.
To: wellylug at lists.wellylug.org.nz
Subject: Re: [wellylug] Mysqldump problem

> #bin/bash

should be shebang?

#!/bin/bash

?

-M

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
> 
> 
> --
> Wellington Linux Users Group Mailing List: 
> wellylug at lists.wellylug.org.nz To Leave:  
> http://lists.wellylug.org.nz/mailman/listinfo/wellylug
> 

--
starnix at sdf.lonestar.org
http://sdf.lonestar.org/~starnix/
gpg fingerprint: 44D7 63F6 2210 24D8 E922  6AA5 FEFC 0024 3549 8CFC

"Life is like a box of chocolates. A cheap, thoughtless, perfunctory
gift that nobody ever asks for. Unreturnable because all you get back is
another box of chocolates. So your stuck with this indefinable whipped
mint crap that you mindlessly wolf down when there's nothing else left
to eat. Sure, once in a while there's a Peanut Butter Cup or an English
Toffee. But they're gone too fast and the taste is... fleeting. So you
end up with nothing but broken bits filled with hardened jelly and
teeth-shattering nuts. And if you're desperate enough to eat those, all
you got left is an empty box... filled with useless brown paper
wrappers." --smoking man