change logfile location MYSQL

  I install mySQL 5.5 on Suse linux 11. I would like to move the log file [ib_logfile0, ib_logfile1] to a new partition. The database [ibdata1] should stay in the current partition.

How can this be done..

Thanks in advance for your help
Who is Participating?
johanntagleConnect With a Mentor Commented:

Basically edit your my.cnf and add/edit this line:

innodb_log_group_home_dir = /path/to/where/you/want/the/log/files

Restart MySQL
SiemensSENAuthor Commented:
Thanks but what happens to the current logs [logfile0, logfile1]

Do I have to move it? or will it be recreated.

johanntagleConnect With a Mentor Commented:
they will be recreated.  you can also try moving them or just delete them once the new ones have been created.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.