Kmymoney 1.0.2 Database Clarification

Using 1.0.1 under openSUSE 11.2 RC2, KDE4.3.2 release 2. I just set up a MySQL
database and saved my transactions to it.

I have the following question:
1. when I try to save as Database after adding data, I get a message " the
database has information that must be removed first, Is it OK to Continue?
 will I loose any of the past data?

2. Can I then use save and backup to save my data to an external usb drive?  
If not whats the best way to backup the mysql tables, etc?

3. MySQL is OK (speed wise) saving to the database, but reading it back in is
slow and uses a lot of CPU time between mysqld and kmymoney processes.  I
know you are working on this.

Any time frame for 64 bit version and using KDE4.3, later KDE?

Thanks for your continuing good work.

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
KMyMoney2-developer mailing list
KMyMoney2-developer@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-developer

[Thomas Baumgart]

Hi,

on Wednesday 04 November 2009 upscope wrote:

[...]

> Any time frame for 64 bit version and using KDE4.3, later KDE?

The 64 bit version is just a matter of packaging. I use it here all the time
in 32 and 64 bit environments (on two different boxes).

The KDE4.x version is on its way, though the port is not an easy task. So
there will be some more time required to finish this work.

--


Regards

Thomas Baumgart

GPG-FP: E55E D592 F45F 116B 8429   4F99 9C59 DB40 B75D D3BA
-------------------------------------------------------------
Person A: It's an ISO standard.
Person B: ...And that means what?
 --mal (http://theangryadmin.blogspot.com/2008/04/future.html)
-------------------------------------------------------------


------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
KMyMoney2-developer mailing list
KMyMoney2-developer@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-developer

[tonyb-2]

On Wednesday 04 Nov 2009 22:36:40 upscope wrote:
> Using 1.0.1 under openSUSE 11.2 RC2, KDE4.3.2 release 2. I just set up a
> MySQL database and saved my transactions to it.
>
> I have the following question:
> 1. when I try to save as Database after adding data, I get a message " the
> database has information that must be removed first, Is it OK to Continue?
>  will I loose any of the past data?
>

You don't need to use 'Save As' when you are working with the database;
updates are written to the dbase as they happen. That menu option should be
disabled.

> 2. Can I then use save and backup to save my data to an external usb drive?
> If not whats the best way to backup the mysql tables, etc?

mysqldump -R --databases KMyMoney > wherever you like.

See the script mysqlcrypt.sh in the contrib directory.

--
Cheers,

TonyB

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
KMyMoney2-developer mailing list
KMyMoney2-developer@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-developer

On Wednesday 04 November 2009 02:36:40 pm upscope wrote:

> Using 1.0.1 under openSUSE 11.2 RC2, KDE4.3.2 release 2. I just set up a
>  MySQL database and saved my transactions to it.
>
> I have the following question:
> 1. when I try to save as Database after adding data, I get a message " the
> database has information that must be removed first, Is it OK to Continue?
>  will I loose any of the past data?
>
> 2. Can I then use save and backup to save my data to an external usb drive?
> If not whats the best way to backup the mysql tables, etc?
>
> 3. MySQL is OK (speed wise) saving to the database, but reading it back in
>  is slow and uses a lot of CPU time between mysqld and kmymoney processes.
>  I know you are working on this.
>
> Any time frame for 64 bit version and using KDE4.3, later KDE?
>
> Thanks for your continuing good work.
>
> ---------------------------------------------------------------------------
> --- Let Crystal Reports handle the reporting - Free Crystal Reports 2008
>  30-Day trial. Simplify your report design, integration and deployment -
>  and focus on what you do best, core application coding. Discover what's
>  new with Crystal Reports now.  http://p.sf.net/sfu/bobj-july
> _______________________________________________
> KMyMoney2-developer mailing list
> KMyMoney2-developer@...
> https://lists.sourceforge.net/lists/listinfo/kmymoney2-developer

Thanks for the responses. i will try the command line backup. I did one from
phpMyAdmin and it appears to generate a restoreable SQL command set with the
data also.

Only unanswered part now is when I do a save to database after adding to the
ledger, it tells me there is data to remove first. Does this mean it rewrite
the total ledger and all the other tables each time? No way to Append to
current data?

Is there a bug reporting system for KMyMoney or do I report any I find thru
KDE Bugzilla?

Thanks again for all responses.

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
KMyMoney2-developer mailing list
KMyMoney2-developer@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-developer

[Thomas Baumgart]

Hi,

on Thursday 05 November 2009 upscope wrote:

[...]

> Thanks for the responses. i will try the command line backup. I did one
>  from phpMyAdmin and it appears to generate a restoreable SQL command set
>  with the data also.
>
> Only unanswered part now is when I do a save to database after adding to
>  the ledger, it tells me there is data to remove first. Does this mean it
>  rewrite the total ledger and all the other tables each time? No way to
>  Append to current data?

The 'save to database' function is used once when transferring data from an
existing XML file to the SQL database.

Whenever you open a database (as opposed to opening a KMY file) and change any
item, the database is updated instantaneously (that's what these animals are
good for). So even if the program crashes no changes are lost. So there is
absolutely no need to run the 'save as database' twice and in case you do, the
existing data will be overridden.

> Is there a bug reporting system for KMyMoney or do I report any I find thru
> KDE Bugzilla?

Officially, we use the SF tracker at
https://sourceforge.net/tracker/?group_id=4708 for bugs and feature requests,
but also have a look at b.k.o. on an intermittent basis.  With the port to
KDE4 and the move of the package into the KDE SVN repository this will be the
place to report bugs in the future anyway.

> Thanks again for all responses.

You're welcome.

--


Regards

Thomas Baumgart

GPG-FP: E55E D592 F45F 116B 8429   4F99 9C59 DB40 B75D D3BA
-------------------------------------------------------------
Faster, better, cheaper - choose two of the above.
 - Old engineering proverb
-------------------------------------------------------------


------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
KMyMoney2-developer mailing list
KMyMoney2-developer@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-developer

On Thursday 05 November 2009 08:55:24 am Thomas Baumgart wrote:

> Hi,
>
> on Thursday 05 November 2009 upscope wrote:
>
> [...]
>
> > Thanks for the responses. i will try the command line backup. I did one
> >  from phpMyAdmin and it appears to generate a restoreable SQL command set
> >  with the data also.
> >
> > Only unanswered part now is when I do a save to database after adding to
> >  the ledger, it tells me there is data to remove first. Does this mean it
> >  rewrite the total ledger and all the other tables each time? No way to
> >  Append to current data?
>
> The 'save to database' function is used once when transferring data from an
> existing XML file to the SQL database.
>
> Whenever you open a database (as opposed to opening a KMY file) and change
>  any item, the database is updated instantaneously (that's what these
>  animals are good for). So even if the program crashes no changes are lost.
>  So there is absolutely no need to run the 'save as database' twice and in
>  case you do, the existing data will be overridden.
>
> > Is there a bug reporting system for KMyMoney or do I report any I find
> > thru KDE Bugzilla?
>
> Officially, we use the SF tracker at
> https://sourceforge.net/tracker/?group_id=4708 for bugs and feature
>  requests, but also have a look at b.k.o. on an intermittent basis.  With
>  the port to KDE4 and the move of the package into the KDE SVN repository
>  this will be the place to report bugs in the future anyway.
>
> > Thanks again for all responses.
>
> You're welcome.
>

Thanks again

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
KMyMoney2-developer mailing list
KMyMoney2-developer@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-developer