The tables should start with capital letters SS but in local are small!

my web hosting is unix. I have the tables the ss in capital. When I export
from remote server to local server the letters from capital become very
small!
I would have to insert parameter to lower_case_table_names=0 in my.ini.
i don't have this file in my computer.

I can modify directly the tables here database_structure xml file?

my o.s. is windows xp
i have installed:
phpmyadmin
easyphp version 1.8

how I can resolve this problem?

thanks

Re: The tables should start with capital letters SS but in local are small!

> my web hosting is unix. I have the tables the ss in capital. When I export
> from remote server to local server the letters from capital become very
> small!
> I would have to insert parameter to lower_case_table_names=0 in my.ini.
> i don't have this file in my computer.
>
> I can modify directly the tables here database_structure xml file?
>
> my o.s. is windows xp
> i have installed:
> phpmyadmin
> easyphp version 1.8
>
> how I can resolve this problem?

Double check the output of a phpinfo() page and check what php.ini file it
claims to be using, if the file it claims it is using does not exist then
you can create 1 and put the setting you mentioned it by itself. If a
php.ini file does not exist php uses default settings.

Re: The tables should start with capital letters SS but in localare small!

peter wrote:
>> my web hosting is unix. I have the tables the ss in capital. When I export
>> from remote server to local server the letters from capital become very
>> small!
>> I would have to insert parameter to lower_case_table_names=0 in my.ini.
>> i don't have this file in my computer.
>>
>> I can modify directly the tables here database_structure xml file?
>>
>> my o.s. is windows xp
>> i have installed:
>> phpmyadmin
>> easyphp version 1.8
>>
>> how I can resolve this problem?
>
> Double check the output of a phpinfo() page and check what php.ini file it
> claims to be using, if the file it claims it is using does not exist then
> you can create 1 and put the setting you mentioned it by itself. If a
> php.ini file does not exist php uses default settings.
>
>

my.ini relates to MySQL, not PHP. See the documentation pages at:
http://dev.mysql.com/doc/refman/5.1/en/installing.html

Here you will find info on my.ini setup during installation, should tell
you where my.ini should be.

Re: The tables should start with capital letters SS but in localare small!

Tyno Gendo wrote:
> my.ini relates to MySQL, not PHP. See the documentation pages at:
> http://dev.mysql.com/doc/refman/5.1/en/installing.html
>
> Here you will find info on my.ini setup during installation, should tell
> you where my.ini should be.

Just to add to this, more specifically,
http://dev.mysql.com/doc/refman/5.1/en/windows-create-option -file.html

Re: The tables should start with capital letters SS but in local are small!

"peter" ha scritto nel messaggio
news:evkll9$um7$1@aioe.org...

> Double check the output of a phpinfo() page and check what php.ini file it
> claims to be using, if the file it claims it is using does not exist then
> you can create 1 and put the setting you mentioned it by itself. If a
> php.ini file does not exist php uses default settings.


this is my phpinfo
http://www.ilbazardeidesideri.it/prova/phpinfo.php


Thanks for your help

Re: The tables should start with capital letters SS but in local are small!

> my.ini relates to MySQL, not PHP. See the documentation pages at:
> http://dev.mysql.com/doc/refman/5.1/en/installing.html
>
> Here you will find info on my.ini setup during installation, should tell
> you where my.ini should be.

Oops just in from nightshift when i posted should have read it more
thoroughly :>