Re: [xwiki-users] Database information about xwiki

On Wed, Feb 11, 2009 at 2:11 AM, Hervé Agnoux < herve.agnoux(a)diaam-informatique.com&gt; wrote: I've found it useful to use http://www.quest.com/toad-for-mysql/ to explore the database created by Xwiki.... I use Toad by setting up an SSH tunnel ( \cygwin\bin\ssh.exe -L 3306:localhost:3306 user(a)server.com "echo '^C to quit' ; exec cat > /dev/null" ) from the windows box running Toad-for-Mysql to the Linux machine running Tomcat & the Mysql db (which is bound only to localhost for security reasons). http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Database+Administration… http://www.dbvis.com/products/dbvis/download/install.jsp -- is it worth setting up and learning this new tool over toad?? How would I use it remotely via a tunnel (firewalls, security, etc)? Speaking of databases, does anybody see anything wrong with the database-surgery I had to perform -- see http://nielsmayer.com/whatididtopoorsql.txt -- apparently I was allowed to create documents with embedded '.' or '/' characters which ultimately were misinterpreted when given as a URL -- thus leaving me with documents I could neither delete nor rename (let alone access). It is probably a bug to allow such names to be entered w/o validation. --Niels http://nielsmayer.com