View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000367 | MySQL v5 for OS/2 & eComStation | Bug | public | 2009-07-31 08:07 | 2020-08-24 03:14 |
| Reporter | subhuman_bob | Assigned To | psmedley | ||
| Priority | normal | Severity | trivial | Reproducibility | always |
| Status | closed | Resolution | unable to reproduce | ||
| Summary | 0000367: unable to change tmpdir setting in MySQL 5.1.36 | ||||
| Description | Both methods specified here http://dev.mysql.com/doc/refman/5.1/en/cannot-create.html fail; MySQL 5.1.36 always tries to create temp files in \var\temp (default location) regardless of specifying a different directory. If \var\temp does not exist, MySQL encounters various errors while running. How to reproduce: run MySQL on a drive that does not have a \var\temp directory; use either command-line option or my.cnf option to specify different tmpdir- MySQL still tries to create files in \var\temp resulting in errors during runtim. Workaround: ensure that a \var\temp directory exists on the same drive that MySQL is installed to | ||||
| Additional Information | In my specific case, MySQL is on E:\ and I was trying to make it use my "generic" temp directory of c:\var\temp with no luck. | ||||
| Tags | No tags attached. | ||||
|
|
Actually, this seems to be the same issue as reported at http://mantis.smedley.info/view.php?id=203 |
|
|
Mysql will use %TMP% or %TEMP% by default on Win32 and OS/2 On my system - c:\var\temp _is_ used even though mysql is run from e:\internet\mysql51 as that's what's specified in config.sysfor %TEMP% |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2009-07-31 08:07 | subhuman_bob | New Issue | |
| 2009-07-31 08:10 | subhuman_bob | Note Added: 0001386 | |
| 2010-07-31 10:41 | psmedley | Note Added: 0001686 | |
| 2010-07-31 10:41 | psmedley | Assigned To | => psmedley |
| 2010-07-31 10:41 | psmedley | Status | new => feedback |
| 2011-10-22 23:40 | psmedley | Status | feedback => resolved |
| 2011-10-22 23:40 | psmedley | Resolution | open => unable to reproduce |
| 2020-08-24 03:14 | psmedley | Status | resolved => closed |
