Don wrote:
>
> Hi list,
>
> I'm trying to backup up database in /etc/cron.daily. I've played with
> mysql dump with the following syntax:
>
> mysqldump --opt -p my_dbf.db > my_dbf.backup
> mysqldump --opt -p "my_password" my_dbf.db > my_dbf.backup
> mysqldump --opt -p my_dbf.db > my_dbf.backup
Hi,
Try taking the space out from "-p passwd"
Regards
Quentin
-Original Message-
From: Don [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 31 January 2001 09:45
To: msql list
Subject: Nightly Backup of my database
Hi list,
I'm trying to backup up database in /etc/cron.daily. I've played
Hi,
Well, there's one easy way to do it, but it compromises security just a
little bit.
mysqldump --opt -u'username' -p'userspassword' my_dbf.db > my_dbf.backup
One way to minimize security risks would be to create a user with minimal
capabilities to do backups -- only given these limited permis