Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



mysql config file in MySQL

Software Development


Reply
 
Thread Tools Search this Thread
  #1  
Old 18-03-2010
Member
 
Join Date: Mar 2010
Posts: 66
mysql config file in MySQL
  

Hello,

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..?

Thanks

Reply With Quote
  #2  
Old 18-03-2010
Member
 
Join Date: Apr 2008
Posts: 1,944
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.
Reply With Quote
  #3  
Old 18-03-2010
Member
 
Join Date: May 2008
Posts: 2,001
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.
Reply With Quote
  #4  
Old 18-03-2010
Member
 
Join Date: Apr 2008
Posts: 1,993
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.
Reply With Quote
  #5  
Old 18-03-2010
Member
 
Join Date: May 2008
Posts: 2,283
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 :

Code:
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.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "mysql config file in MySQL"
Thread Thread Starter Forum Replies Last Post
Unable to install MySQL and MySQL Workbench on Linux mint 10 Zared Windows Software 4 13-01-2011 12:08 AM
Import sql file in mysql Zool Software Development 3 18-11-2009 10:34 AM
Mysql Error : Can't connect to local mysql server through socket ' var lib mysql mysql.sock' 2 roshan45 Software Development 3 07-11-2009 08:36 PM
Help me with MySQL file permissions giorgos Software Development 3 31-07-2009 09:13 PM
Import txt file to mysql Holt Software Development 2 21-04-2009 11:48 AM


All times are GMT +5.5. The time now is 09:40 PM.