Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

phpMyAdmin import db size #2344

Closed
akhalid4493 opened this issue Oct 28, 2019 · 9 comments
Closed

phpMyAdmin import db size #2344

akhalid4493 opened this issue Oct 28, 2019 · 9 comments
Labels

Comments

@akhalid4493
Copy link

when creating new droplet with Docker 5:19.03.1~3 on 18.04 and change laradock .env mysql version from latest to 5.7
after use :
docker-compose up -d --build
docker-compose up -d nginx phpmyadmin mysql workspace

I can't import database sql file large than 2 MB.
how can I increases the phpmyadmin importing database limit !!

Screen Shot 2019-10-28 at 3 04 30 PM

@slamgundam
Copy link

I also have the same issue.

@llioor
Copy link

llioor commented Nov 13, 2019

I changes almost any php.ini file I have from outside the containers and inside the containers. Still 2M limit
+1

@bharatgupta99
Copy link
Contributor

same issue.

@llioor
Copy link

llioor commented Nov 21, 2019

same issue.

I logged into the container of phpmyadmin and mysql and I changed to properties of max post size and upload file manually to a bigger size.

@lrotermund
Copy link

+1

bestlong added a commit to bestlong/laradock that referenced this issue Nov 30, 2019
@jfm-dnd
Copy link

jfm-dnd commented Dec 17, 2019

Hi, I had the same issue and have found a workaround with adding ./php-ini/php.ini:/usr/local/etc/php/php.ini to pma volumes section.
I use docker4php, so pma section in docker-compose.yml file looks like:

pma:
    image: phpmyadmin/phpmyadmin
    container_name: "${PROJECT_NAME}_pma"
    environment:
      PMA_HOST: $DB_HOST
      PMA_USER: root
      PMA_PASSWORD: $DB_ROOT_PASSWORD
    labels:
      - "traefik.http.routers.${PROJECT_NAME}_pma.rule=Host(`pma.${PROJECT_BASE_URL}`)"
    volumes:
      - /sessions
      - ./php-ini/php.ini:/usr/local/etc/php/php.ini

Then create a dir /php-ini with a php.ini file at the same level of the docker-compose.yml. Adding post_max_size=400M to it and restart override phpmyadmin, and it works.
I recently made a reminder from the result of my research, with a structure in example https://github.com/jfm-dnd/docker4php-multiproject. (sorry I did it in french).

NetBT pushed a commit to NetBT/opdock that referenced this issue Jan 17, 2020
@stale
Copy link

stale bot commented Mar 16, 2020

Hi 👋 this issue has been automatically marked as stale 📌 because it has not had recent activity 😴. It will be closed if no further activity occurs. Thank you for your contributions ❤️.

@stale stale bot added the Stale label Mar 16, 2020
@stale
Copy link

stale bot commented Apr 6, 2020

Hi again 👋 we would like to inform you that this issue has been automatically closed 🔒 because it had not recent activity during the stale period. We really really appreciate your contributions, and looking forward for more in the future 🎈.

@stale stale bot closed this as completed Apr 6, 2020
@ntuanphuc
Copy link

same here

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

7 participants