MySQL Replication on Linux

Question

I am doing MysqlReplication on Linux/Debian I have installed mysql.

Now the first setp for mysql replication is to edit the /etc/mysql/my.cnf file. But that is not available in the location.

So how can I edit that ?

Any Idea?

Thanks.

mugen kenichi · Answer 1 · 2010-07-30 13:05:15Z

I suggest you run:

updatedb
locate my.cnf

If you installed mysql manually the files may be installed under the PREFIX directory. That is usually /usr/local or the location you chose.

which mysql

Maybe helps finding the prefix dir.

If there is still no my.cnf to be found you can find a lot of example my.cnf files for nearly every possible case on the googlenet.

Janne Pikkarainen · Answer 2 · 2010-07-30 11:33:52Z

up vote 0 down vote

Just create the file with the text editor of your choice.

answered Jul 30 '10 at 11:33

	It is instructed to edit It means already that has to be available.I can create and can write only those content those are available to edit. What about other those are by default. – sjain Jul 30 '10 at 11:46
	Just copy an example my.cnf from /usr/share/doc/mysql-server-5.0/examples directory. Pick the one that seems most appropriate for you. Please note that the examples are gzip archives by default, so you need to ungzip them for example with gzip -d some_conf_file.cnf.gz – Janne Pikkarainen Jul 30 '10 at 12:04
	Thanks for reply I have installed MySQL using .tar.gz file.This may be the reason that /usr/share/doc/.... directory is not available.Is there any other location for the my.cnf file when using the tar.gz installation. – sjain Jul 30 '10 at 12:19
	ok. If that tar.gz approach is not necessary for you, command apt-get install mysql-server mysql-client will set the basics up for you. – Janne Pikkarainen Jul 30 '10 at 12:38
	Thanks I will move that but I dont get the information about all the installed directory, That's why I didnot want to move for apt-get command.One more thing I want to ask : Does apt-get command automaticall create /etc/init.d/mysql startup script or we have to write? Thanks – sjain Jul 30 '10 at 12:56

feedback

2 Answers