Hello and welcome to our community! Is this your first visit?
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
    Thanked 0 Times in 0 Posts

    xampp mysql table name not case sensitve table names


    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
    # password = your_password
    port = 3306
    socket = mysql

    # Here follows entries for some specific programs

    # The MySQL server

    port= 3306

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


    port = 3306
    socket = mysql

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

    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!
    server-id = 1

    # Uncomment the following if you want to log updates

    # Uncomment the following if you are NOT using BDB tables

    # 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
    #set-variable = innodb_lock_wait_timeout=50


    # Remove the next comment character if you are not familiar with SQL

    key_buffer = 8M
    sort_buffer_size = 8M

    key_buffer = 8M
    sort_buffer_size = 8M



    plz help me to sort out this

  2. #2
    Supreme Master coder! Old Pedant's Avatar
    Join Date
    Feb 2009
    Thanked 4,947 Times in 4,908 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.
    Be yourself. No one else is as qualified.


Posting Permissions

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