Solved

change logfile location MYSQL

Posted on 2013-01-11
3
303 Views
Last Modified: 2013-01-12
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
Comment
Question by:SiemensSEN
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 24

Accepted Solution

by:
johanntagle earned 270 total points
ID: 38769242
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
 

Author Comment

by:SiemensSEN
ID: 38769286
Thanks but what happens to the current logs [logfile0, logfile1]

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

Thanks
0
 
LVL 24

Assisted Solution

by:johanntagle
johanntagle earned 270 total points
ID: 38769339
they will be recreated.  you can also try moving them or just delete them once the new ones have been created.
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction In this installment of my SQL tidbits, I will be looking at parsing Extensible Markup Language (XML) directly passed as string parameters to MySQL 5.1.5 or higher. These would be instances where LOAD_FILE (http://dev.mysql.com/doc/refm…
I use MySQL for many of my development projects in a Windows environment. To manage my databases (and perform queries) for years I used a tool called MySQL administrator.  This tool has since been replaced by MySQL Workbench. So I decided to m…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question