web-erp-developers

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

[jesse <je...@st...>]

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.=20
This also alleviates changing all table names which would be a nightmare =
in the code, for upgrades, etc.

Going forward the install docs need to reflect this caveat for windows =
mysql systems.

how's that sound?

-----Original Message-----
From: web...@li... =
[mailto:web...@li...]On Behalf Of =
Stins, 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 tables =
in lowercase.=20
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 -----=20
From: Danie Brink=20
To: Phil Daintree=20
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 that, 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:=20
Dear all,
=20
I have a very annoying problem.
=20
mysql at windows converts all table names to lower case.
=20
When you create a dump of the database, it's also converted to lowercase =
table names.
=20
When you import this at linux, it works fine except that all scripts =
expect case sensitive table names and are returning errors.
=20
After some study, I concluded that using only lowercase table names in =
scripts and in the mysql database is the best solution to keep the mysql =
data exchangeble between those platforms for all web-erp users.
=20
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).=20
=20
I suspect that this might be caused by circular references in the =
foreign key definitions, but I am not sure about that.
=20
With best regards,
=20
Dick Stins
=20
p.s. I have a rename table script available for lowercase to uppercase =
conversion, when someone is interested.=20

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

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

Jesse,

Thanks, but I read also the user comments. This scared me off. And it is
dependend of the configuration of mysql, so you keep the problem when the
mysql database is configured with different parameters.

Changing the table names is independent of everything and solves this iss=
ue
for ever (although I was surprised that mysql uses lowercase. Oracle uses
standard uppercase, but this will be compatible with unquoted tablenames =
in
create table scripts.).

For changing the scripts, I hoped that you are a wizard with unix shell
scripting and convert the table names to lowercase within a few minutes f=
or
all scripts.

For renaming tablenames in the database is a little harder. I think we ne=
ed
to do:
- backup the database
- dump the data separately from the create table scripts.
- Rename the table names in this script with the unix shell scripting tri=
ck.
- drop all tables
- create tables (with lowercase names) like a new installation (complete
empty tables + constraints)
- insert the data

With best regards,

Dick Stins

p.s. I tried the the rename table statement, but that crashed the complet=
e
mysql server process.

----- Original Message -----
From: "jesse" <je...@st...>
To: <web...@li...>
Sent: Monday, April 19, 2004 12: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 wo=
rk.
This also alleviates changing all table names which would be a nightmare =
in
the code, for upgrades, etc.

Going forward the install docs need to reflect this caveat for windows my=
sql
systems.

how's that sound?

-----Original Message-----
From: web...@li...
[mailto:web...@li...]On Behalf Of Stins=
,
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 tables in
lowercase.
Dumping with quotes results still in lowercase table names (ofcourse betw=
een
quotes).

I still think that it is the best to transform all tablenames to lowercas=
e.
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 that=
,
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 lowercase
table names.

When you import this at linux, it works fine except that all scripts expe=
ct
case sensitive table names and are returning errors.

After some study, I concluded that using only lowercase table names in
scripts and in the mysql database is the best solution to keep the mysql
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 uppercase
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&op=3Dick
_______________________________________________
Web-erp-developers mailing list
Web...@li...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

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

[Phil D. <ph...@du...>]

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 fine.
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 nightmare
in the code, for upgrades, etc.
>
> Going forward the install docs need to reflect this caveat for windows
mysql systems.
>
> how's that sound?
>
> -----Original Message-----
> From: web...@li...
[mailto:web...@li...]On Behalf Of Stins,
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 tables 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 that,
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 lowercase
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 in
scripts and in the mysql database is the best solution to keep the mysql
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 uppercase
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_id70&alloc_id638&opk
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>

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