Modify tmpdir
Modify tmpdir
Hello, I am trying to create a fulltext index on a large (around a million rows) table, but the location my tmpdir is set to does not contain enough space. How do I modify the tmpdir to a different directory so that I can create this index?
Re: Modify tmpdir
Which web server are you using?
To contact our team, please send email to following addresses, remember to replace (at) with @
Technical team: support(at)terra-master.com(for technical support)
Service team: service(at)terra-master.com(for purchasing, return, replacement, RMA service)
Technical team: support(at)terra-master.com(for technical support)
Service team: service(at)terra-master.com(for purchasing, return, replacement, RMA service)
Re: Modify tmpdir
The configuration file for MariaDB is usually `my.cnf` or `my.ini`. Find the `tmpdir` configuration option and set it to the path of the new directory.
[mysqld]
tmpdir = /path/to/new/tmpdir
After modifying the configuration file, you need to restart the MariaDB service for the changes to take effect.
[mysqld]
tmpdir = /path/to/new/tmpdir
After modifying the configuration file, you need to restart the MariaDB service for the changes to take effect.
To contact our team, please send email to following addresses, remember to replace (at) with @
Technical team: support(at)terra-master.com(for technical support)
Service team: service(at)terra-master.com(for purchasing, return, replacement, RMA service)
Technical team: support(at)terra-master.com(for technical support)
Service team: service(at)terra-master.com(for purchasing, return, replacement, RMA service)