Re: Nightly Backup of my database

2001-01-30 Thread Steve Ruby
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

RE: Nightly Backup of my database

2001-01-30 Thread Quentin Bennett
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

Re: Nightly Backup of my database

2001-01-30 Thread Laszlo G. Szijarto
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