Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    Regular Coder
    Join Date
    Sep 2010
    Posts
    122
    Thanks
    6
    Thanked 0 Times in 0 Posts

    xampp mysql table name not case sensitve table names

    hi

    i have instolled xampp 1.6.3a

    when i restore mysql data bases i have getting every table name as simple letters

    i want to do table names as case sensitive.

    how do i do that

    this is my my.cnf file

    //////////////////
    # Example MySQL config file for small systems.
    #
    # This is for a system with little memory (<= 64M) where MySQL is only used
    # from time to time and it's important that the mysqld daemon
    # doesn't use much resources.
    #
    # You can copy this file to
    # D:/xampp/mysql/bin/my.cnf to set global options,
    # mysql-data-dir/my.cnf to set server-specific options (in this
    # installation this directory is D:/xampp/mysql/data) or
    # ~/.my.cnf to set user-specific options.
    #
    # In this file, you can use all long options that a program supports.
    # If you want to know which options a program supports, run the program
    # with the "--help" option.

    # The following options will be passed to all MySQL clients
    [client]
    # password = your_password
    port = 3306
    socket = mysql

    # Here follows entries for some specific programs

    # The MySQL server
    [mysqld]

    port= 3306

    socket= "/xampp/mysql/mysql.sock"

    basedir="D:/xampp/mysql"
    tmpdir="D:/xampp/tmp"
    datadir="D:/xampp/mysql/data"


    port = 3306
    socket = mysql

    old-passwords
    character-set-server = latin1
    collation-server = latin1_general_ci

    skip-locking
    key_buffer = 16K
    max_allowed_packet = 1M
    table_cache = 4
    sort_buffer_size = 64K
    read_buffer_size = 256K
    read_rnd_buffer_size = 256K
    net_buffer_length = 2K
    thread_stack = 64K

    # Don't listen on a TCP/IP port at all. This can be a security enhancement,
    # if all processes that need to connect to mysqld run on the same host.
    # All interaction with mysqld must be made via Unix sockets or named pipes.
    # Note that using this option without enabling named pipes on Windows
    # (using the "enable-named-pipe" option) will render mysqld useless!
    #
    #skip-networking
    server-id = 1

    # Uncomment the following if you want to log updates
    #log-bin=D:/xampp/mysql/data/mysql-bin

    # Uncomment the following if you are NOT using BDB tables
    skip-bdb

    skip-innodb
    # Uncomment the following if you are using InnoDB tables
    #innodb_data_home_dir = D:/xampp/mysql/data/
    #innodb_data_file_path = ibdata1:10M:autoextend
    #innodb_log_group_home_dir = D:/xampp/mysql/data/
    #innodb_log_arch_dir = D:/xampp/mysql/data/
    # You can set .._buffer_pool_size up to 50 - 80 %
    # of RAM but beware of setting memory usage too high
    #set-variable = innodb_buffer_pool_size=16M
    #set-variable = innodb_additional_mem_pool_size=2M
    # Set .._log_file_size to 25 % of buffer pool size
    #set-variable = innodb_log_file_size=5M
    #set-variable = innodb_log_buffer_size=8M
    #innodb_flush_log_at_trx_commit=1
    #set-variable = innodb_lock_wait_timeout=50
    lower_case_table_names=0

    [mysqldump]
    quick
    max_allowed_packet=16M

    [mysql]
    no-auto-rehash
    # Remove the next comment character if you are not familiar with SQL
    #safe-updates

    [isamchk]
    key_buffer = 8M
    sort_buffer_size = 8M

    [myisamchk]
    key_buffer = 8M
    sort_buffer_size = 8M

    [mysqlhotcopy]
    interactive-timeout

    [WinMySQLadmin]
    Server="D:/xampp/mysql/bin/mysqld.exe"
    #user=root
    #password=


    plz help me to sort out this

  • #2
    Supreme Master coder! Old Pedant's Avatar
    Join Date
    Feb 2009
    Posts
    25,184
    Thanks
    75
    Thanked 4,341 Times in 4,307 Posts
    Table names can *NOT* be made case sensitive on Windows.

    That's because MySQL uses the table name as the name of a file on Windows, and Windows file names are never case sensitive.

    I'm assuming this is on windows, since I see Server="D:/xampp/mysql/bin/mysqld.exe" in there.
    An optimist sees the glass as half full.
    A pessimist sees the glass as half empty.
    A realist drinks it no matter how much there is.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •