• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 315
  • 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

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

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