database export

[Thomas Spuhler]

On Wednesday, February 10, 2016 09:38:28 PM Joe W. Byers wrote:
> Andy,
> 
> I have been running on fedora 23 for several months.  I have used both
> KDE and cinammin desktops and connect to the database with no difficulties.
> 
> 
> Joe
> 
> On 02/10/2016 06:52 AM, Andy Chung wrote:
> > Thanks Joe.
> > So it seems like you are doing it on monthly basis to diff db_ddddmmyy.
> > Yes I have exported at my windows 10 machine.
> > 
> > I would also like to do it in my linux Fedora 23 gnome, but am facing
> > a problem.
> > In Fedora 23 gnome, I am not seeing QSYSQL in database type.  I could
> > only see the SQLite db type.
> > I have mariadb installed in my Fedora and could see it at phpMyAdmin page.
> > What have I missed?
> > 
> > 
> > 2016-02-10 19:38 GMT+08:00 Joe W. Byers <ecjbosu at aol.com
> > 
> > <mailto:ecjbosu at aol.com>>:
> >     On 02/10/2016 01:04 AM, Andy Chung wrote:
> >>     Hi there,
> >>     
> >>     I have exported my kmymoney to mariadb.
> >>     going fwd I would like to use db as periodic bkup.
> >>     in my next export should I
> >>     (a) export to same db name?  would it overwrite and not causing
> >>     any duplicate entries, or
> >>     (b) export to another db e.g. kmymoney_yyyymmdd?
> >>     
> >>     Happy Chinese New Year.
> >     
> >     Hello,
> >     
> >     I have this  on a linux machine using a monthly cron, You could do
> >     something similar on windows in a batch file with the system
> >     schedular.
> >     
> >     DATE=`date +%Y%m%d`
> >     # Our Base backup directory
> >     BASEBACKUP="/DBtemp"
> >     FinalDest="/media/usbdisk"
> >     #"/mnt/usb-drive"
> >     HOST="localhost"
> >     
> >         mysqldump -h$HOST --user=user -ppassword --opt kmymoney |
> >     
> >     bzip2 -c > $FinalDest/kmymoney-$DATE.sql.bz2
> >     
> >     I am using a mariaDB as well.   This does a test dump with create
> >     statements that is zipped.  if needed it can be executed from the
> >     command line.  I had a system crash several years ago and this
> >     saved my behind.
> > 
> > cheers,
> > 
> > Andy

You actually don't need to compress it. The file is verys small, a few MB
-- 
Best regards
Thomas Spuhler

All of my e-mails have a valid digital signature
ID 60114E63
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 181 bytes
Desc: This is a digitally signed message part.
URL: <http://mail.kde.org/pipermail/kmymoney/attachments/20160210/493c34c0/attachment.sig>