Re: [h2] CSVWRITE not escaping newlines

2015-04-03 Thread Thomas Mueller
Hi, H2 supports the standard CSV format as documented in Wikipedia, including RFC 4180, and much more. If MariaDB doesn't support that (are you sure it doesn't?), then I suggest to ask _them_ why they are not compliant. You should probably ask at StackOverflow.com. But yes, JSON export and import

Re: [h2] CSVWRITE not escaping newlines

2015-04-02 Thread Noel Grandin
On 2015-04-01 05:09 PM, Stephen Cprek wrote: I'm working on migrating a populated gerrit H2 database to mariadb and although I got this to work originally by using the H2 SCRIPT command and a script to modify the file to fit mysql syntax it's sloppy. A better solution I feel is to do a CSVWRI

[h2] CSVWRITE not escaping newlines

2015-04-01 Thread Stephen Cprek
Hi, I'm working on migrating a populated gerrit H2 database to mariadb and although I got this to work originally by using the H2 SCRIPT command and a script to modify the file to fit mysql syntax it's sloppy. A better solution I feel is to do a CSVWRITE on each table and import that directly