Using MySQL with GnuCash

[Colin Law]

On 14 September 2015 at 15:56, Hossain <contacthossain at gmail.com> wrote:
> Hello, I want to save the GNUCash data to MySQL server , Hence, I installed
> WAMP.
> GnuCash can connect to MySQL server very well but I dont see any related
> database tables or data
> in the database I made for Gnucash with PhpAdmin. Do I have to set the
> saving preference at the beginningm when I make the file?
> I did it later.

You don't need to make the database in advance, GnuCash will make it
if necessary when you save it.  Just select mysql as the type to save
as and provide the database name, user and password and it should do
it.  You should then be able to see the data in phpadmin.

Does GC appear to save the data as mysql ok?
Does mysql://.... then appear in the GC title bar?
Can you close GC and and re-open it and the data are still there?
If so then it is saving the data ok so if you can't see it in
phpmyadmin then the problem lies there not in gc.  You may have to
refresh phpmyadmin after saving in GC.

Colin