Unable to convert gnucash to mysql after upgrading to 16.04

[John Ralls]

> 
> On May 2, 2016, at 10:06 PM, Lewis Balentine <lewis at keywild.com> wrote:
> 
> If I may add two-cents:
> 
> SQLite is rock-solid. It is in fact the backend DB for a number of well known commercial applications
> ... the DB encryption may be proprietary.
> 
> SQLite has other advantages particularly for a single user database.
> 
> 1) The biggest of these is that backups are simple: just copy the data file. That also allows you to try all kinds of "what ifs". If it works out good, if not just revert to the saved copy.
> 
> 2) Install SQLIte ODBC or JDBC and you can establish a connection to the DB your office suite.  Then you can build a query in the Squite DBase manager and merge the results into you office application (Documents, Spreadsheet or Presentation). This methodology can be used for custom reports and integration of data from multiple entities (the latter still being a complex operation).
> 
> 3) SQLite Command Line can be used to import and export data from the DB to CSV or HTML files. If you screw up your data see number 1 above.
> 
Thanks for sharing that, but unless you copy the list you're preaching to the converted. ;-)

Regards,
John Ralls


> 
> On 05/01/2016 12:43 PM, John Ralls wrote:
>>> On May 1, 2016, at 9:48 AM, Colin Law <clanlaw at gmail.com> wrote:
>>> 
>>> On 1 May 2016 at 14:21, Lewis Balentine <lewis at keywild.com> wrote:
>>>> see this ....
>>>> http://stackoverflow.com/questions/9192027/invalid-default-value-for-create-date-timestamp-field
>>> You are right, that is the problem, thanks.  Ensuring that the server
>>> is configured with NO_ZERO_DATE not set fixes the problem.  I wrongly
>>> discounted this initially as the problem only started with mysql 5.7,
>>> and the original question was four years ago.
>>> 
>> 
>> Which reinforces yet again the fundamental rule of using GnuCash with a server-based database: The user is expected to be an expert DBA for the server of choice or to hire one. It's harder than it seems and novices risk data loss.
>> 
>> Yes, I know that many Linux distros use MySQL/Maria for administrative databases. I think it's stupid, both because it requires an otherwise unnecessary resource-hungry process and because it requires expertise of the user, most of whom are casual (especially in the case of Ubuntu which aspires to be a desktop OS competing with Microsoft and Apple for the technically unsophisticated user). SQLite3 works as well or better for all of those administrative tasks without the overhead.
>> 
>> Regards,
>> John Ralls
>> 
>> 
>