<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix"><br>
Andy,<br>
<br>
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. <br>
<br>
<br>
Joe<br>
<br>
On 02/10/2016 06:52 AM, Andy Chung wrote:<br>
</div>
<blockquote
cite="mid:CA+u-Dee1-tTkrGzsMeEBfBYsyCK=Ya5EE4PAt6pj=55dGki8_g@mail.gmail.com"
type="cite">
<div dir="ltr">
<div>
<div>
<div>Thanks Joe.<br>
</div>
So it seems like you are doing it on monthly basis to diff
db_ddddmmyy.<br>
</div>
Yes I have exported at my windows 10 machine.<br>
<br>
</div>
I would also like to do it in my linux Fedora 23 gnome, but am
facing a problem.<br>
In Fedora 23 gnome, I am not seeing QSYSQL in database type. I
could only see the SQLite db type.<br>
I have mariadb installed in my Fedora and could see it at
phpMyAdmin page.<br>
What have I missed?<br>
<br>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">2016-02-10 19:38 GMT+08:00 Joe W. Byers
<span dir="ltr"><<a moz-do-not-send="true"
href="mailto:ecjbosu@aol.com" target="_blank">ecjbosu@aol.com</a>></span>:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
<div>On 02/10/2016 01:04 AM, Andy Chung wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">
<div>
<div>
<div>
<div>
<div>
<div>Hi there,<br>
<br>
</div>
I have exported my kmymoney to mariadb.<br>
</div>
going fwd I would like to use db as periodic
bkup.<br>
</div>
in my next export should I<br>
</div>
(a) export to same db name? would it overwrite
and not causing any duplicate entries, or<br>
</div>
(b) export to another db e.g. kmymoney_yyyymmdd?<br>
<br>
</div>
Happy Chinese New Year.<br>
</div>
</blockquote>
<br>
Hello,<br>
<br>
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.<br>
<br>
DATE=`date +%Y%m%d`<br>
# Our Base backup directory<br>
BASEBACKUP="/DBtemp"<br>
FinalDest="/media/usbdisk" <br>
#"/mnt/usb-drive"<br>
HOST="localhost"<br>
<br>
mysqldump -h$HOST --user=user -ppassword --opt
kmymoney | bzip2 -c > $FinalDest/kmymoney-$DATE.sql.bz2<br>
<br>
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.<span
class="HOEnZb"><font color="#888888"><br>
<br>
<br>
<br>
<div>-- <br>
<b>Joe W. Byers</b><br>
</div>
</font></span></div>
</blockquote>
</div>
<br>
<br clear="all">
<br>
-- <br>
<div class="gmail_signature">
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div><br>
</div>
cheers,<br>
<br>
</div>
Andy<br>
</div>
</div>
</div>
</div>
</div>
</blockquote>
<br>
<div class="moz-signature">-- <br>
<b>Joe W. Byers</b><br>
</div>
</body>
</html>