MySQL Forums
Forum List  »  General

mysql 5.6 temp files?
Posted by: Robert Gunther
Date: September 01, 2015 02:09AM

I installed a copy of mysql 5.6 on windows, using a 100 gig boot disk and 2tb data drive.

mysql is starting as a service, running under Network Service.

I modified my.ini to move the the location of a number of files, including:

innodb_data_home_dir
datadir
relay_log
relay_log_index
log_bin
log_bin_index

Then I attempted to restore a 100 gig database. Took a few hours but the restore stopped due to disk full. A bit of research shows at 74gig temp file filled up my drive.

The location of the file was:

c:\windows\serviceprofiles\networkservice\appdata\local\temp

My reading about mysql temp folders (http://dev.mysql.com/doc/refman/5.6/en/temporary-files.html) never mentions this folder.

I am assuming this is mysql putting data here, how do I prevent it... I need all the data on the d: due to the space issues.

Options: ReplyQuote


Subject
Written By
Posted
mysql 5.6 temp files?
September 01, 2015 02:09AM
September 01, 2015 11:28AM
September 02, 2015 02:53AM
September 02, 2015 03:12PM
September 02, 2015 10:39PM
September 03, 2015 02:09AM
September 02, 2015 02:51AM
September 05, 2015 06:28PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.