Page 1 of 1
Modify tmpdir
Posted: 18 Feb 2025, 07:42
by Rayos
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
Posted: 18 Feb 2025, 15:31
by CursaYang
Which web server are you using?
Re: Modify tmpdir
Posted: 20 Feb 2025, 09:53
by Rayos
Cursa wrote: ↑18 Feb 2025, 15:31
Which web server are you using?
I am using phpMyAdmin with MariaDB on a F2-212 Terramaster.
Re: Modify tmpdir
Posted: 20 Feb 2025, 14:18
by CursaYang
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.