Need procedure to setup mysql for Gnucash in window

[durgaprasad alaparthi]

Hi Colin,

Thanks for explaining the procedure. I have followed the steps mentioned in
the mail. However GNUCash is giving following error.

"The server at URL mysql://localhost:gnucash:narayana:narayana experienced
an error or encountered bad or corrupt data."

Can you please let me know how this error can be resolved?

Note: 1. I have installed Mysql5.1 Newly and did not create any database or
tables related to GNUCash. I have just created new Account Hirerachy in
GNUCash and selected Mysql as the database to save the data.

Regards,
Lakshminarayana

On Fri, Dec 4, 2009 at 7:50 PM, Colin Law <clanlaw at googlemail.com> wrote:

> 2009/12/4 durgaprasad alaparthi <8765439 at gmail.com>:
> > Hi,
> >
> > I am new in using Gnucash. I do not know how to create a new database and
> > store the data in Mysql using Gnucash.
> > Can anyone help me by explianing
> > 1. How to establish connection between Gnucash and Mysql.
> > 2. How to create Gnucash account tables in Mysql.
> > 3. How to store data in Mysql.
> >
> > I am using Gnucash 2.3.7 and Mysql 5.1
> > Thanks in advance,
>
> In gnucash simply click File, Save As and select MySql in the dropdown
> list.
> Then setup the database data in the fields provided and it will make a
> new database for you with all your accounts in it (or overwrite and
> existing database if it already exists).  Then changes to your GC data
> will be saved in the database automatically as you add accounts,
> transactions etc.
>
> Colin
>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: GNUCash_Error.JPG
Type: image/jpeg
Size: 72587 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20091204/303bbae1/attachment-0001.jpe>