On 04/17/2014 10:18 AM, max_allan wrote: > Hello, > > I can only find one suggestion about migrating between databases, it's from > 2006 that refers to an export tool that only works in Firefox. > Is there a better way yet? I've got quite a lot of content and users and > more importantly than the volume of data I'd like to retain "ownership" > metadata and history etc.. > > But then read a bit about it and thought "Do I need to migrate". I'm > assuming if the wiki is not being accessed then a simple filesystem backup > will be consistent and recoverable? > > Should there be any extra indexes or anything else to do for performance > tweaks? > Would MySQL give me any advantage over HSQLDB? > (I'm on 5.0.3 and want to update to 5.4.4 soon.) > > I distrust a database if I haven't got a whole pile of command line tools I > can poke at it with... > > Max
Personally I'm thinking of going the other way around. Although MySQL is probably the most popular RDBMS, HSQLDB is faster, closer to SQL standards, has more features, offers better support for Unicode and variable length fields, and many other advantages... The reason why XWiki recommends MySQL is that there is more knowledge about it, thus it's easier to find guides, or to find a sysadmin that can set up a database. However, it is true that the default HSQLDB database shipped with XWiki is NOT optimized for performance, and it doesn't support larger volumes of data. -- Sergiu Dumitriu http://purl.org/net/sergiu _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
