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
simone [ Mi, 11 April 2007 17:48 ] [ ID #1684581 ]

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.
Peter [ Do, 12 April 2007 09:04 ] [ ID #1685844 ]

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.
Tyno Gendo [ Do, 12 April 2007 10:22 ] [ ID #1685845 ]

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
Tyno Gendo [ Do, 12 April 2007 10:23 ] [ ID #1685846 ]

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 :>
Peter [ Do, 12 April 2007 20:09 ] [ ID #1685847 ]

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

"peter" <submit [at] flexiwebhost.com> ha scritto nel messaggio
news:evkll9$um7$1 [at] 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
simone [ Do, 12 April 2007 20:08 ] [ ID #1685848 ]
PHP » alt.php.sql » The tables should start with capital letters SS but in local are small!

Vorheriges Thema: $_GET request -> variable -> object? -> function
Nächstes Thema: Help learning php/mysql