A mysql question
- From: <m.roth2006@xxxxxxx>
- Date: Tue, 31 Mar 2009 11:40:26 -0400 (EDT)
Anyone here have any idea how to set a system default for mysql? I'm trying to run confluence's full import, and I assume it just drops the d/b, rather than dropping its d/b table by table, and the system default when it recreates the d/b is a case-insensitive collation; meanwhile, in their docs, they're telling me to use case sensitive collation (and then they contradict themselves, but that's another story).
I set the collation, committed it, then ran the import (actually, it's rerunning it), and while that's running, I logged into mysql... and it's reset to case insensitive. I've grepped the backup that it's restoring from, and see no references to collation, so I assume it's a mysql default....
redhat-list mailing list