<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">On 02/10/2016 01:04 AM, Andy Chung
wrote:<br>
</div>
<blockquote
cite="mid:CA+u-DedqdEdR31H1BoOBHskQSQYxfRa8DN+UbABUMQgsS180=A@mail.gmail.com"
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.<br>
<br>
<br>
<br>
<div class="moz-signature">-- <br>
<b>Joe W. Byers</b><br>
</div>
</body>
</html>