Re: [libreoffice-users] LO Base/MySQL Backup??

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 *- sajan@noppix.com
>
>
>
>
> On Tue, May 28, 2013 at 11:08 AM, Wolfgang Keller <feliphil@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
> > 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
> >
> >
> >     
>
>   

--
To unsubscribe e-mail to: users+unsubscribe@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