Results 1 to 5 of 5

Thread: mysql config file in MySQL

  1. #1
    Join Date
    Mar 2010

    mysql config file in MySQL


    I am in trouble to get some concepts regarding the database file and why and where it locates in the computer system and what type of changes can possibly be made on this.

    I am working with MySQL database and have this query for Mysql config file .Have you any idea..?


  2. #2
    Join Date
    Apr 2008

    mysql config file in MySQL

    Every database contains some file with the extension of the conifg or conf.It is not only in the case of application software.

    There are a lot of changes made upon the system software to manage the system using that file and the files are located at specific place where only administrator id allowed to go and change the contents of the files.

    The files are working as a command for system,It contains some parameters which is followed and scanned by the system during startup of the database system or system software.

  3. #3
    Join Date
    May 2008

    mysql config file in MySQL

    Like other system,the mysql config file is used to manage the whole system from hardware to system specific level.

    It's very similar that the primary task of the administrator will need to undertake is accurate configuration and management of MySQL's configuration file. This file, as extension suggested my.cnf, contains default startup parameters for both the server and for clients. accurate configuration of this file can go a long way towards optimizing MySQL, as different memory buffer configuration and other needed options can be configured here.

  4. #4
    Join Date
    Apr 2008

    mysql config file in MySQL

    Mysql configuration file named as my.cnf is stored into $MYSQL_DATA directory.There are no any particular parameters to be configure for the replication from oracle to mysql databases.

    There is only need is having dbreader user in mysql database.

    1. How to create user dbreader
    2. Just make sure dbreader username and password are entitled in the property file for connection with mysql and oracle databases from java codes.

  5. #5
    Join Date
    May 2008

    Creating MySQL configuration file (my.cnf)

    Creating MySQL configuration file:

    If you always find yourself in requirement to setup some MySQL configurations and you are using the MAMP server on Mac OS X,then in this case, you can create a new my.cnf file using the below suggested command :

    sudo cp  /Applications/MAMP/Library/share/mysql/my-medium.cnf /Applications/MAMP/Library/my.cnf
    Now,you have created a manual file for own named my.cnf file where you can set up needed configurations.

Similar Threads

  1. Replies: 4
    Last Post: 13-01-2011, 01:08 AM
  2. Import sql file in mysql
    By Zool in forum Software Development
    Replies: 3
    Last Post: 18-11-2009, 11:34 AM
  3. Replies: 3
    Last Post: 07-11-2009, 09:36 PM
  4. Help me with MySQL file permissions
    By giorgos in forum Software Development
    Replies: 3
    Last Post: 31-07-2009, 10:13 PM
  5. Import txt file to mysql
    By Holt in forum Software Development
    Replies: 2
    Last Post: 21-04-2009, 12:48 PM

Posting Permissions

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