List:General Discussion« Previous MessageNext Message »
From:Tim Johnson Date:April 8 2014 7:46pm
Subject:Re: Excluding MySQL database tables from mysqldump
View as plain text  
* hsv@stripped <hsv@stripped> [140407 23:09]:
> >>>> 2014/04/07 08:02 -0800, Tim Johnson >>>>
>   2)mysqldump forces all database names to lower case in the "CREATE
>   DATABASE" statement. I know, one shouldn't use upper case in
>   database names, but :) tell that to my clients. 
> <<<<<<<<
> Why not? That is not mentioned in the section devoted to mapping such names to the
> file-system.
  I found 'official' documentation here regarding Mac OS X:
  https://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html

  I had also found some reference to this having been a side effect
  of migrating files from older macs (of which I am not familiar)
  filesystems. 

  I don't find any reference in the mysqldump documentation at
  https://dev.mysql.com/doc/refman/5.1/en/mysqldump.html to any
  mechanism for overriding this.

  The incompatibility kicks in when trying to restore the databases
  on linux - and I presume FreeBSD, sun OS and other posix systems
  would show the same problem.

  Live and learn ...
-- 
Tim 
tim at tee jay forty nine dot com or akwebsoft dot com
http://www.akwebsoft.com, http://www.tj49.com
Thread
Excluding MySQL database tables from mysqldumpTim Johnson5 Apr 2014
  • Re: Excluding MySQL database tables from mysqldumpTim Johnson5 Apr 2014
    • Re: Excluding MySQL database tables from mysqldumpshawn l.green7 Apr 2014
      • Re: Excluding MySQL database tables from mysqldumpTim Johnson7 Apr 2014
        • Re: Excluding MySQL database tables from mysqldumphsv8 Apr 2014
          • Re: Excluding MySQL database tables from mysqldumpTim Johnson8 Apr 2014