Import file size limit in PHPMyAdmin/mariadb

Using Web Server, PHP, MySQL, MariaDB.
Post Reply
User avatar
Omarco
Posts: 5
Joined: 27 Jan 2026, 14:26
Netherlands

Import file size limit in PHPMyAdmin/mariadb

Post by Omarco »

I finally managed to get this NAS working properly and installed WordPress via the web server. Along the way I kept running into problems, but I managed to solve them one by one, until I reached the point of importing the database.
My database is 80 MB, and that’s where I’m now hitting a wall. On a normal PC, I know I can increase the maximum upload size by editing the PHP configuration file in the Apache folder, but on this NAS I have no idea how to change this, since I can’t find the Apache directory.
Can anyone help me with this step?
Thanks in advance!
User avatar
CursaYang
TM Support
Posts: 740
Joined: 06 Jan 2025, 16:34
China

Re: Import file size limit in PHPMyAdmin/mariadb

Post 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.
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)
User avatar
Omarco
Posts: 5
Joined: 27 Jan 2026, 14:26
Netherlands

Re: Import file size limit in PHPMyAdmin/mariadb

Post by Omarco »

I successfully managed to change the database size, but now I am running into another issue, this time related to PHP8.0.
My current website is running on the latest version of WordPress (6.9) with PHP 8.3 on Hostinger. I am trying to migrate or run the same setup on my TerraMaster NAS.
From the TerraMaster Community App Center, I installed the PHP app Apache83. I am now trying to figure out how to replace the current PHP 8 setup with PHP 8.3. However, in the web server Virtual Host settings, I only see Default (PHP 8.0) available, and there is no option to select PHP 8.3.
This is my first real NAS, so I am still learning how TerraMaster handles PHP and web server configurations. I hope the community will be patient with me as I continue learning step by step.
If someone could help me with this or point me in the right direction, I would really appreciate it.

*I have read that upgrading PHP 8.0 to the latest PHP version is not a straightforward process. TerraMaster will need to develop a solution that allows this to be done through a user-friendly interface, especially for users without a technical background. Updates like these should be rolled out quickly, rather than waiting for a completely new firmware release, such as TOS 7, for example, by pushing updates in the future.

In this way, you attract more customers to the NAS and build a stronger community.
User avatar
CursaYang
TM Support
Posts: 740
Joined: 06 Jan 2025, 16:34
China

Re: Import file size limit in PHPMyAdmin/mariadb

Post by CursaYang »

We have not yet released an application for PHP 8.3. The community provides PHP 8.1: viewtopic.php?t=2925&start=10
Thank you for your suggestion; we will continue to optimize.
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)
User avatar
Omarco
Posts: 5
Joined: 27 Jan 2026, 14:26
Netherlands

Re: Import file size limit in PHPMyAdmin/mariadb

Post by Omarco »

Yesterday I was figuring out how to bypass all of this and work with Docker container I have to say that it works perfectly. PHP 8.5 and WordPress 6.9 run smoothly; everything is fast and you have full control. The only thing that was a bit challenging for me was working with SSH. But ChatGPT guided me through every step.

The next step is to figure out how I can take advantage of my NVMe and 64gb RAMs and speed wordpress up using caching. This is purely for experimental purposes.
User avatar
sydneybarrett
Posts: 1
Joined: 31 Mar 2026, 11:45
United States of America

Re: Import file size limit in PHPMyAdmin/mariadb

Post by sydneybarrett »

Nice work getting it running with Docker-that’s definitely a solid approach and gives you much more flexibility 👍

For speeding things up with your NVMe and 64GB RAM, you might want to look into enabling object caching (like Redis) and a page cache plugin on WordPress. Also, tuning PHP-FPM settings and enabling OPcache can give a noticeable performance boost.

Since you’re already using Docker, it should be fairly straightforward to spin up a Redis container and connect it. Curious to see what results you get—keep us posted!
Post Reply

Return to “Web Server/PHP/MySQL/MariaDB”