Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Server Operation

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Thread Tools Display Modes
Old 7th December 2011, 11:18
vmos vmos is offline
Join Date: Nov 2008
Posts: 57
Thanks: 1
Thanked 0 Times in 0 Posts
Default secure local mysql backups?

Good morning,
we've got a couple of servers that run a script that dumps the mysql databases into a local directory on the server.

Now this has two significant flaws. First, the mysql root password is stored as plain text in the script. Secondly, the databases dumps are just plain text, albiet zipped.

Now I've been looking for various solutions and not come up with anything satisfactory.

I could encrypt the zips but that still leaves the passwords in the script. I put the script and the dumps into an encrypted directory but then you can't run that with a cron job.

I could have a remote server login and take backups of the databases but if possible I'd like something on the local server.

These particular servers are either running debian or ubuntu with apache

Any suggestions?
Reply With Quote
Sponsored Links
Old 7th December 2011, 11:25
till till is offline
Super Moderator
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 37,045
Thanks: 842
Thanked 5,661 Times in 4,468 Posts

There is no security problem when you run the script as root cronjob so that the script itself is owned by root and has 700 permissions and the directory where the script dumps its files has to be owned by root as well with 700 permissions. So no user except of the root user can see the mysql password in the sdript or get the mysql database contents.
Till Brehm
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote


dump, local, mysql, secure

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
CPU load locks up box. Apache or MYSQL related. crypted General 61 29th October 2010 23:16
ISPConfig3 Mail Warn Errors reason8 General 3 25th November 2009 14:58
BIG Problem Postfix issue admins Installation/Configuration 11 13th November 2009 11:05
I Fail at installing ispconfig where did I go wrong? stocker741 Installation/Configuration 14 30th October 2008 15:12
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 10:11

All times are GMT +2. The time now is 16:38.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.