Sajan & Steve,
Thanks. I will have to look at this as an alternate possibility.
I didn't mean to criticize, but I take computer security seriously and
when I see a vulnerability, I tend to bring it to the person's
attention. There are far too many people out there who take computer
security nonchalantly and can be bitten.
Girvin
Sajan Parikh wrote:
I don't see the security issue in mysqldump using a cron. You can throw
your password in a mysqldump.cnf file and make it only readable by your
user. You can combine that with what Steve said and use a special MySQL
user as well.
------
*Sajan Parikh*
*Web Consultant, Noppix LLC*
*Work* - 563.726.0371
*Cell *- 563.447.0822
*Fax* - 563.726.0122
*Email *- sa...@noppix.com
On Tue, May 28, 2013 at 4:06 PM, Steve Edmonds
<steve.edmo...@ptglobal.com>wrote:
Hi Girvin.
For security I created a mysql user 'backup' with read only access for
backup.
I make the cron script readable by root only
-rwxr-x--- 1 root root 586 2012-12-05 16:19 /etc/cron.backup/dailytmp.bu
MYSQL_PWD="*******" mysqldump -ubackup --all-databases --add-drop-database
| gzip -9 > /home/bu/mysql.sql.gz
Steve
On 2013-05-29 06:57, Girvin R. Herr wrote:
Sajan,
The only problem I see with a cron job is a security issue. I assume you
are putting your MySQL password(s) in your cron job script, since mysqldump
requires it. I would not recommend doing that. I have a system backup
script which I manually run monthly. It does not include the passwords.
When that script runs, mysqldump prompts me for the password, I enter it,
and off it goes.
I might add that I have been using mysqldump for several years and I have
not had any problems with it or with retrieving the database data from its
backup files. I need to retrieve the backup when I upgrade MySQL, in order
to restore my databases in the new version. It works fine, even when I
upgraded from MySQL 5.0.67 to 5.5.29.
Girvin Herr
Sajan Parikh wrote:
Someone mentioned mysqldump, this is definitely the way to go. Set it up
on a cron and have it dump files to a backup directory.
------
*Sajan Parikh*
*Web Consultant, Noppix LLC*
*Work* - 563.726.0371
*Cell *- 563.447.0822
*Fax* - 563.726.0122
*Email *- sa...@noppix.com
On Tue, May 28, 2013 at 11:08 AM, Wolfgang Keller <felip...@gmx.net>
wrote:
My question now is - Where does MySQL store the Database and how do I
track it down to make a backup??
You'll have to use the MySQL administration tool for that. LO only sees
a server running at an IP address listening to a specific port. It has
no means to know where the data is.
And I still recommend PostgreSQL over MySQL. ;-)
Among others, it allows backing up a database while "live".
Sincerely,
Wolfgang
--
To unsubscribe e-mail to:
users+unsubscribe@global.**libreoffice.org<users%2bunsubscr...@global.libreoffice.org>
Problems?
http://www.libreoffice.org/**get-help/mailing-lists/how-to-**
unsubscribe/<http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/>
Posting guidelines + more: http://wiki.**documentfoundation.org/**
Netiquette <http://wiki.documentfoundation.org/Netiquette>
List archive:
http://listarchives.**libreoffice.org/global/users/<http://listarchives.libreoffice.org/global/users/>
All messages sent to this list will be publicly archived and cannot be
deleted
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
