Re: [Web-erp-developers] case sensitive table problem mysql linuxwindows

[Stins, D. <DR...@Zi...>]

Phil,

Is it not important to have the best price performance hosting platform
(linux) be very compatible with world most used platform (windows)?

Some notes about this issue in the documentation is a good start.

With best regards,
Dick Stins
----- Original Message -----
From: "Phil Daintree" <ph...@du...>
To: <web...@li...>
Sent: Monday, April 19, 2004 1:48 AM
Subject: Re: [Web-erp-developers] case sensitive table problem mysql
linuxwindows


> Its only a snag when dumping a windows db and re-instating a *nix based=
 -
> case sensitive - db. Windows install works fine, *nix install works fin=
e.
> Only when windows install taken to *nix.
>
> I think a note in install.txt may confuse things a bit?
>
> Phil
> ----- Original Message -----
> From: "jesse" <je...@st...>
> To: <web...@li...>
> Sent: Monday, April 19, 2004 10:06 AM
> Subject: RE: [Web-erp-developers] case sensitive table problem mysql
> linuxwindows
>
>
> > Dick, please take a look at this:
> > http://dev.mysql.com/doc/mysql/en/Name_case_sensitivity.html
> >
> > The proper fix for this problem is listed there using the 'mysqld.
> lower_case_table_names' config option. I would say either 0 or 2 would
work.
> > This also alleviates changing all table names which would be a nightm=
are
> in the code, for upgrades, etc.
> >
> > Going forward the install docs need to reflect this caveat for window=
s
> mysql systems.
> >
> > how's that sound?
> >
> > -----Original Message-----
> > From: web...@li...
> [mailto:web...@li...]On Behalf Of Sti=
ns,
> Dick
> > Sent: Sunday, April 18, 2004 17:22
> > To: web...@li...
> > Subject: Re: [Web-erp-developers] case sensitive table problem mysql
> linuxwindows
> >
> >
> > Danie,
> >
> > Thanks for the tip, but the mysql windows server is storing all table=
s
in
> lowercase.
> > Dumping with quotes results still in lowercase table names (ofcourse
> between quotes).
> >
> > I still think that it is the best to transform all tablenames to
> lowercase. This will give 100% full compatibility at this issue between
> web-erp at windows an web-erp at linux.
> >
> > With best regards,
> >
> > Dick Stins
> > ----- Original Message -----
> > From: Danie Brink
> > To: Phil Daintree
> > Sent: Saturday, April 17, 2004 2:37 PM
> > Subject: Re: [Web-erp-developers] case sensitive table problem mysql
> linuxwindows
> >
> >
> > Hi Dick,
> > I have found this problem myself with MySQL , but found that by
exporting
> with quotes it solved the problem, you should ask mysqldump to to do th=
at,
> if I remember correctly you use the -Q command line option.
> >
> > This might help or Not as I have never tried working with the windows
> version.
> >
> > On Sat, 2004-04-17 at 10:19, Stins, Dick wrote:
> > Dear all,
> >
> > I have a very annoying problem.
> >
> > mysql at windows converts all table names to lower case.
> >
> > When you create a dump of the database, it's also converted to lowerc=
ase
> table names.
> >
> > When you import this at linux, it works fine except that all scripts
> expect case sensitive table names and are returning errors.
> >
> > After some study, I concluded that using only lowercase table names i=
n
> scripts and in the mysql database is the best solution to keep the mysq=
l
> data exchangeble between those platforms for all web-erp users.
> >
> > Another option is to create a seperate script to rename the tables at
the
> unix platform back to case sensitive, but that crashed the mysql server
> completely (bug).
> >
> > I suspect that this might be caused by circular references in the
foreign
> key definitions, but I am not sure about that.
> >
> > With best regards,
> >
> > Dick Stins
> >
> > p.s. I have a rename table script available for lowercase to uppercas=
e
> conversion, when someone is interested.
> >
> >
> >
> > -------------------------------------------------------
> > This SF.Net email is sponsored by: IBM Linux Tutorials
> > Free Linux tutorial presented by Daniel Robbins, President and CEO of
> > GenToo technologies. Learn everything from fundamentals to system
> > administration.http://ads.osdn.com/?ad_id=1470&alloc_id638&opk
> > _______________________________________________
> > Web-erp-developers mailing list
> > Web...@li...
> > https://lists.sourceforge.net/lists/listinfo/web-erp-developers
> >
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: IBM Linux Tutorials
> Free Linux tutorial presented by Daniel Robbins, President and CEO of
> GenToo technologies. Learn everything from fundamentals to system
> administration.http://ads.osdn.com/?ad_id=3D1470&alloc_id=3D3638&op=3Dc=
lick
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers