• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 321
  • Last Modified:

change logfile location MYSQL

Hello,
  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
0
SiemensSEN
Asked:
SiemensSEN
  • 2
2 Solutions
 
johanntagleCommented:
http://dev.mysql.com/doc/refman/5.5/en/innodb-parameters.html#sysvar_innodb_log_group_home_dir

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
0
 
SiemensSENAuthor Commented:
Thanks but what happens to the current logs [logfile0, logfile1]

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

Thanks
0
 
johanntagleCommented:
they will be recreated.  you can also try moving them or just delete them once the new ones have been created.
0
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.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now