# Can't import 130mb database
**URL:** https://community.kinsta.com/t/cant-import-130mb-database/483
**Category:** Application Support
**Created:** [March 9, 2021, 12:28pm UTC](https://community.kinsta.com/t/cant-import-130mb-database/483 "2021-03-09T12:28:01Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@ulziibat.n](https://community.kinsta.com/u/ulziibat.n)
#### Post date: [March 9, 2021, 12:28pm UTC](https://community.kinsta.com/t/cant-import-130mb-database/483/1 "2021-03-09T12:28:01Z")
Hello guys.
Today i’m first time using this awesome development tool.
I have little probelm when import database.
My database size is 130mb.
I got this error message.
```
Fatal error
```
: Allowed memory size of 134217728 bytes exhausted (tried to allocate 138225832 bytes) in
/var/www/html/adminer.php
on line
95
---
### Author:  [@melissa](https://community.kinsta.com/u/melissa)
#### Post date: [March 9, 2021, 3:38pm UTC](https://community.kinsta.com/t/cant-import-130mb-database/483/2 "2021-03-09T15:38:01Z")
Hi @ulziibat.n 👋 Welcome to the community!
It does indeed sound as if the memory limit isn’t able to handle the database import of that size, I’m going to discuss this with our development team further and will update you as soon as I can. As a workaround you may wish to try uploading it via command line instead:
```
docker exec -i devkinsta_db mysql -u root -p [DB name] < [path/to/sql/file]
```
That should avoid any PHP limitations that are in place 🤞 Let us know how it goes!
---
### Author:  [@jasmink](https://community.kinsta.com/u/jasmink)
#### Post date: [April 2, 2021, 10:15am UTC](https://community.kinsta.com/t/cant-import-130mb-database/483/4 "2021-04-02T10:15:00Z")
Hi Melissa.
Just here to add that I had the same error. Our database is 168mb.
---
### Author:  [@michael](https://community.kinsta.com/u/michael)
#### Post date: [April 2, 2021, 4:19pm UTC](https://community.kinsta.com/t/cant-import-130mb-database/483/5 "2021-04-02T16:19:19Z")
Hi @jasmink . Welcome to DevKinsta and apologies for the trouble. Does the above workaround work for you?
---
### Author:  [@jasmink](https://community.kinsta.com/u/jasmink)
#### Post date: [April 4, 2021, 8:50am UTC](https://community.kinsta.com/t/cant-import-130mb-database/483/6 "2021-04-04T08:50:48Z")
Hey Michael. No problem. It didn’t, but there’s a good chance it’s because of user error - it’s been a while since I used terminal. I’ll post an update if I get around to trying again however I might just revert to SFTP for now.
---
### Author:  [@nemanjac](https://community.kinsta.com/u/nemanjac)
#### Post date: [April 8, 2021, 3:39pm UTC](https://community.kinsta.com/t/cant-import-130mb-database/483/7 "2021-04-08T15:39:44Z")
DevKinsta has a default limitation on 128MB file upload.
In order to get that increased you will need to access shell.
It can be done by running
`docker exec -it devkinsta_fpm bash`
This will bring you to the terminal of the application server.
Depending on version of PHP you are using, file is located in
`/etc/php/7.4/fpm/conf.d/tuning.ini`
This is for version 7.4. If you need to edit file for different version you can simply change 7.4 in path with PHP version used.
3 values should be changed:
upload\_max\_size = 128M
post\_max\_size = 128M
upload\_max\_filesize = 128M
You can put 256M for all 3, restart DevKinsta, and you are done.
---
### Author:  [@system](https://community.kinsta.com/u/system)
#### Post date: [April 30, 2021, 4:14pm UTC](https://community.kinsta.com/t/cant-import-130mb-database/483/8 "2021-04-30T16:14:07Z")
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.