# How to increase Adminer memory? It doesn't use allocated memory!

**URL:** <https://community.localwp.com/t/how-to-increase-adminer-memory-it-doesnt-use-allocated-memory/45888>\
**Category:** Support\
**Created:** [December 5, 2024, 10:36am UTC](https://community.localwp.com/t/how-to-increase-adminer-memory-it-doesnt-use-allocated-memory/45888 "2024-12-05T10:36:09Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![EvgeniyO](https://avatars.discourse-cdn.com/v4/letter/e/6de8d8/32.png) [@EvgeniyO](https://community.localwp.com/u/EvgeniyO)\
**Post date:** [December 5, 2024, 10:36am UTC](https://community.localwp.com/t/how-to-increase-adminer-memory-it-doesnt-use-allocated-memory/45888/1 "2024-12-05T10:36:09Z")

</div>

Running some MySQL queries I get an error

`Fatal error: Allowed memory size of 268435456 bytes exhausted...`

According to [this post](https://community.localwp.com/t/how-to-increase-the-php-memory-limit-beyond-256mb-for-adminer-on-macos/36971), I edited /Local Sites/…/conf/php/php.ini.hbs - and see change in php.info, as on screenshot.

 ![2024-12-05_112715](https://us1.discourse-cdn.com/flex019/uploads/lwpforums/original/3X/7/6/764949edfdab3425c10b4402bd0add5f892a40b1.jpeg)

But the error still there - and Adminer doesn’t use the allocated memory limit! Allowed memory size is the same, as before change from default 256MB to 1024MB.

Where can I edit Adminer memory limitation so it has an effect?

Here logs for the case are useful:  
[local-logs.zip](https://community.localwp.com/uploads/short-url/zpA4mFBQviT2yGefDwNIq9Uuysl.zip) (31.1 KB)

---

<div class="post-metadata">

**Author:** ![Nick-B](https://sea1.discourse-cdn.com/flex019/user_avatar/community.localwp.com/nick-b/32/16140_2.png) [@Nick-B](https://community.localwp.com/u/Nick-B)\
**Post date:** [December 5, 2024, 1:25pm UTC](https://community.localwp.com/t/how-to-increase-adminer-memory-it-doesnt-use-allocated-memory/45888/2 "2024-12-05T13:25:47Z")

</div>

Hey @EvgeniyO

We have a feature request for this below. Currently, the limit is hard coded in and can’t be adjusted, so manual DB Imports are the way to go for an alternative.

> [@Allow Users to Raise the Memory Upload Limit for Adminer](https://community.localwp.com/t/allow-users-to-raise-the-memory-upload-limit-for-adminer/42787):
>
> Currently, the Memory Limit for Adminer is hard-coded at 256 MB which means if you’re importing a large database you might get an error like these: A note that this is not related to the PHP Memory value set in php.ini which you can edit to a larger value. Steps for this are included at the bottom of our [Troubleshooting Performance Issues help article here](https://localwp.com/help-docs/troubleshooting/troubleshooting-performance-issues-in-local/). The workaround for the Adminer error is to manually import the database file as mentioned in our [Manually Importing a Local Site guide](https://localwp.com/help-docs/getting-started/how-to-import-a-wordpress-site-into-local/#Manually-Import-a-Local-site).…

---

<div class="post-metadata">

**Author:** ![system](https://sea1.discourse-cdn.com/flex019/user_avatar/community.localwp.com/system/32/1_2.png) [@system](https://community.localwp.com/u/system)\
**Post date:** [March 5, 2025, 1:26pm UTC](https://community.localwp.com/t/how-to-increase-adminer-memory-it-doesnt-use-allocated-memory/45888/3 "2025-03-05T13:26:04Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.