On Wed, Feb 11, 2009 at 2:11 AM, Hervé Agnoux < [email protected]> wrote: > > See perhaps > http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Database+Administration > and the out of date schema at > http://platform.xwiki.org/xwiki/bin/view/DevGuide/DatabaseSchema > > 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 [email protected] "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+Administrationrecommends 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 _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
