How can I install phpmyadmin into espocrm Docker

[esforim]

Been too long so I can't remember. I'm starting 'afresh' again and I try to documents some of the step for the future generation. Also using AI to answer some of my question and concern so it helping progress without having to wait on forum for a kind helper and research through pages long tutorial and guide.

[victor]

@esforim

What kind of errors and about what "size" are you talking about?

[esforim]

victor my VPS experience was a failure of time and money probably not going to do it again. I been trying to slowly learn how to self host server, although it not as fast and as strong as Paid services.

But at least there is no limited and restrict on what we can do. Playing with Docker at the moment, but trying to find a way to move my data over from my host to my server.

I have manage to download backup and it seem to be quite error prone since it is big file size.

[victor]

esforim

For EspoCRM it is better to use a VPS. Shared Hosting has a lot of limitations and most likely you will not be able to use some of the commands that will be specifically limited by the Shared Hosting provider.

[esforim]

Thank you victor. Problem is my web hosting I won't have the ability to use those command I think, since it is a 'shared hosting'.

No way to do a "GET"?

[victor]

The documentation (for Docker installation) has recently been updated with a detailed description for EspoCRM files and for the database:https://docs.espocrm.com/administrat...nual-restore_1. It is designed specifically for Restore, but can also be used to migrate to a clean Docker installation. Don't forget about https://docs.espocrm.com/administrat...configurations.

[esforim]

Next step is learn how to transfer my Database to this Docker version

[esforim]

Thank you Victor. I use the default Compose from EspoCRM's documentation and added your myphpadmin setting; here is my edit for the future generation:

espocrm-phpmyadmin:
image: phpmyadmin/phpmyadmin
container_name: espocrm-phpmyadmin
links:
- espocrm-db
environment:
PMA_HOST: espocrm-db
PMA_PORT: 3306
PMA_ARBITRARY: 1
restart: always
ports:
- 8583:80

The only thing that was change was the Container name which is espocrm-db

To log in I use the following (default information)

[victor]

- It's very important to stop all containers you have running via the "docker-compose down -v" command before editing docker-compose.yaml.
- After that, make the changes I suggested in docker-compose.yaml and save the changes.
- After saving the changes in docker-compose.yaml you need to build your container with "docker-compose up -d --build" or "docker-compose up -d --build "$@"".

[victor]

I can access to phpmyadmin to control my database already.

Let's take my proposed docker-compose.yaml as an example, and that your server's IP is 192.168.1.50.
So, to login to your instance you need to use http://192.168.1.50:8582/. And to login phpMyAdmin, you need to use http://192.168.1.6:8583/.

Also you can use http://localhost:8582/ for instance and http://localhost:8583/ for phpMyAdmin.

[trungtvmso]

If you have everything working except phpMyAdmin, then just copy the part about espocrm-phpmyadmin into your docker-compose.yaml and specify the ports convenient for you:

Thank you Victor, now I can access to phpmyadmin to control my database already.

Thank you so much

[victor]

If you have everything working except phpMyAdmin, then just copy the part about espocrm-phpmyadmin into your docker-compose.yaml and specify the ports convenient for you:

[trungtvmso]

trungtvmso,

You can take the part about phpMyadmin from my docker-compose.yaml. The file is fully functional (I'm using it now).

thank you for sharing, do I need to config anything else for nginx to run this container, bro? I'm new on everything so that I'm very sorry if my question were stupid

[victor]

trungtvmso,

You can take the part about phpMyadmin from my docker-compose.yaml. The file is fully functional (I'm using it now).

[yuri]

I don't think it's the right place to get an answer about the phpmyadmin container. Maybe provide more input. Any errors?