# Database insert memory **URL:** \ **Category:** Support\ **Created:** [October 10, 2024, 5:44pm UTC](https://community.localwp.com/t/database-insert-memory/44960 "2024-10-10T17:44:53Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![giorgoskey](https://avatars.discourse-cdn.com/v4/letter/g/f19dbf/32.png) [@giorgoskey](https://community.localwp.com/u/giorgoskey)\ **Post date:** [October 10, 2024, 5:44pm UTC](https://community.localwp.com/t/database-insert-memory/44960/1 "2024-10-10T17:44:53Z")
### What issue or error are you experiencing? I am trying to insert a DB that is about 250MB, the limit is 1GB. The process stops unsuccessfully and I get the message: ] **Fatal error** : Allowed memory size of 268435456 bytes exhausted (tried to allocate 259310400 bytes) in **C:\Users\User\AppData\Local\Programs\Local\resources\extraResources\adminer\adminer.php** on line **100** I increased all memories at my conf/php/php.ini but the problem remains. any help? ## thanks Giorgos ### System Details ## nginx MySQL 8.0.16 WP 6.4.3 [local-logs.zip](https://community.localwp.com/uploads/short-url/moAwrbsHKharFeSAGrsuqAYvZ10.zip) (5.1 KB) ---
**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:** [October 10, 2024, 5:57pm UTC](https://community.localwp.com/t/database-insert-memory/44960/2 "2024-10-10T17:57:00Z")
Hey @giorgoskey! This is a known limitation in Local at the moment. We have a feature request here to allow adjustments for this value. Feel free to upvote, comment or follow along. In the meantime your best bet will be to manually import the database as a workaround. Details at the bottom of this post: > [@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).… ---
**Author:** ![giorgoskey](https://avatars.discourse-cdn.com/v4/letter/g/f19dbf/32.png) [@giorgoskey](https://community.localwp.com/u/giorgoskey)\ **Post date:** [October 11, 2024, 8:51am UTC](https://community.localwp.com/t/database-insert-memory/44960/3 "2024-10-11T08:51:03Z")
Hello Nick, I do as the troubleshooting asks: 1. move my sql to app/public 2. site shel this command: wp db import sites5\_proinos.sql and I get the error: Error: Failed to get current SQL modes. Reason: ERROR 2003 (HY000): Can’t connect to MySQL server on ‘localhost’ (10061) Then I run the Local program as administrator and still got the same issue. I read more and I change the wp config options as suggested to: define( ‘DB\_HOST’, ‘localhost:10005’ ); 10005 is my localhost and now I get the message: ERROR 1045 (28000): Access denied for user ‘sites5\_proinos’@‘localhost’ I am a bit confused here… ---
**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:** [October 12, 2024, 1:19pm UTC](https://community.localwp.com/t/database-insert-memory/44960/4 "2024-10-12T13:19:58Z")
Hey @giorgoskey Just to check a few things here that could be getting in the way: - Do you have any antivirus, security, or firewall applications that could be blocking Local? If so, can you try temporarily disabling them or see if they have a setting that will “allow” Local to proceed? - Can you check if your Hosts File is read only? [Help! I’m running into an EPERM error with the hosts file on Windows](https://community.localwp.com/t/help-im-running-into-an-eperm-error-with-the-hosts-file-on-windows/3508) - Are you running other developer applications simultaneously? That could also cause similar issues. Apps like MAMP, XAMPP, or Docker for example. - Lastly, if you’re still having trouble does the issue persist when downgrading your Local version? [Downgrade Local Version - Local](https://localwp.com/help-docs/troubleshooting/downgrade-local-version/) ---
**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:** [January 10, 2025, 1:20pm UTC](https://community.localwp.com/t/database-insert-memory/44960/5 "2025-01-10T13:20:11Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.