database export

[Joe W. Byers]

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.
>
>
>
>     -- 
>     *Joe W. Byers*
>
>
>
>
> -- 
>
> cheers,
>
> Andy

-- 
*Joe W. Byers*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/kmymoney/attachments/20160210/b04588ac/attachment.html>