Hi Jakub,
Am I correct in assuming these are MySQL dumps you are seeking to load as is
into Virtuoso ? As there are DDL differences between MySQL and Virtuoso so I
would not expect this to work as is, unless the dumps are pure SQL-92 ?
Virtuoso replication would probably be the best way to load from MySQL to
Virtuoso, although replication is not part of Virtuoso open source as it is a
commercial only feature ...
Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc. // http://www.openlinksw.com/
Weblog -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter -- http://twitter.com/OpenLink
Google+ -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers
Begin forwarded message:
> From: Jakub Káňa <jakubk...@gmail.com>
> Subject: [Virtuoso-users] LOADing SQL dump from POD
> Date: 22 April 2014 20:30:00 BST
> To: virtuoso-users@lists.sourceforge.net
>
> Hello,
>
> I am having following problem with LOADing a SQL dump to VIrtuoso. I am using
> open-source version 7.1.
>
> And source dump is downloaded from POD -
> http://www.product-open-data.com/download/
>
> I am adding screens from log. Second screen is error after commenting those 3
> lines according to advice here
> http://stackoverflow.com/questions/6265891/sql-syntax-what-is-this
>
> http://www.jakubkana.chytrak.cz/Error.jpg
>
> http://www.jakubkana.chytrak.cz/Error2.jpg
>
> I would be grateful for any advice that would help me properly load that data.
>
>
> Best regards
> Jakub Káňa
> ------------------------------------------------------------------------------
> Start Your Social Network Today - Download eXo Platform
> Build your Enterprise Intranet with eXo Platform Software
> Java Based Open Source Intranet - Social, Extensible, Cloud Ready
> Get Started Now And Turn Your Intranet Into A Collaboration Platform
> http://p.sf.net/sfu/ExoPlatform_______________________________________________
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Begin forwarded message:
> From: Jakub Káňa <jakubk...@gmail.com>
> Subject: [Virtuoso-users] Fwd: LOAD TO VIRTUOSO (SQL DUMP)
> Date: 22 April 2014 20:14:54 BST
> To: virtuoso-users@lists.sourceforge.net
>
> ---------- Forwarded message ----------
> From: Jakub Káňa <jakubk...@gmail.com>
> Date: 2014-04-22 20:45 GMT+02:00
> Subject: LOAD TO VIRTUOSO (SQL DUMP)
> To: virtuoso-users@lists.sourceforge.net
>
>
> Hello,
>
> I am having following problem with LOADing a SQL dump to VIrtuoso. I am using
> open-source version 7.1.
>
> And source dump is downloaded from POD -
> http://www.product-open-data.com/download/
>
> I am adding screens from log. Second screen is error after commenting those 3
> lines according to advice here
> http://stackoverflow.com/questions/6265891/sql-syntax-what-is-this
>
> http://www.jakubkana.chytrak.cz/Error.jpg
>
> http://www.jakubkana.chytrak.cz/Error2.jpg
>
> I would be grateful for any advice that would help me properly load that data.
>
> Cheers
> Jakub Kana
>
> ------------------------------------------------------------------------------
> Start Your Social Network Today - Download eXo Platform
> Build your Enterprise Intranet with eXo Platform Software
> Java Based Open Source Intranet - Social, Extensible, Cloud Ready
> Get Started Now And Turn Your Intranet Into A Collaboration Platform
> http://p.sf.net/sfu/ExoPlatform_______________________________________________
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
------------------------------------------------------------------------------
Start Your Social Network Today - Download eXo Platform
Build your Enterprise Intranet with eXo Platform Software
Java Based Open Source Intranet - Social, Extensible, Cloud Ready
Get Started Now And Turn Your Intranet Into A Collaboration Platform
http://p.sf.net/sfu/ExoPlatform
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users