database export

[Andy Chung]

Have to install the package qt-mysql.
Could export to mariadb now under fedora gnome.  tks.

2016-02-11 11:03 GMT+08:00 Thomas Spuhler <thomas.spuhler at btspuhler.com>:

> 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




-- 

cheers,

Andy
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/kmymoney/attachments/20160212/319a6a41/attachment.html>