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

[Colin Law]

On 11 May 2014 15:25, Aaron Artmann <aartmann at comcast.net> wrote:
> ...
> I think the problem lies in the database data itself because I can
> create new tables and use them but once I import a backup to the
> database it becomes not useable.  I don't want to restart everything
> over again but if I can not get it to work once its imported then I am
> going to have to.  The data was backed up with MySQL Dumper but now it
> will not work because something with gzopen().  I will have to
> research more.
>

I had not realised you are trying to connect to an existing database.
To check GC is ok then open it and (if it does not open with the new
accounts file wizard) then use File New to start the wizard and run
through accepting he defaults to create a basic set of accounts.  Then
try and save that to the mysql server.  That will confirm that GC is
ok.  Also shut down GC and re-open and check you can access the db
again.

An easy way to move the data from one mysql server to another
(assuming that is what you are trying to do) is to open GC on the old
one and then save the file in XML format.  Move that file to the new
machine and open it in GC there, then save it as mysql to the new
server.

Colin

Colin