Phpmyadmin

[oleg_maccen11890]

Hello
What folder is phpmyadmin. How to make it possible to download the database more than (Max: 1,024MiB). The database size is 30 megabytes.

 

[admin]

Hi Oleg,

Just to confirm, is your database 30 MB or 30 GB?

There are couple of options to take backup of database.

Option1:
If your database is big like 30GB then best option is to make backup using `mysqldump` command.
1. Login into your SSH terminal
2. Run this command

mysqldump -u <db-username-here> -p --single-transaction --compact --no-tablespaces <db-name-here>| gzip > /path-to-store-db/filename.sql.gz

Option 2:
Use our in-built Backup Manage.
Guide article: https://zeslecp.com/docs/backup-manager/database-backup

Option 3:
You can access PhpMyAdmin from your User Area.
1. Login into user account (not admin account).
2. Navigate to Databases > Access PhpMyAdmin (there you can download databases as you like)

Thanks

 

[oleg_maccen11890]

What folder is phpmyadmin. I want to add the ability to select files for import on the disk (server).

 

[admin]

It's located here /usr/local/zesle/phpmyadmin, Your changed might be replaced on next update

 

[oleg_maccen11890]

When importing a 40 megabyte database, I get 504 Gateway Time-out

how to make remote access to the database from a specific ip only. Through a program such as mySQLWorkbench

 

[admin]

have you looked at errors logs /var/log/zesle or /var/log/zeslesrv
If you want to enable remote access, You need to change listen ip address to 0.0.0.0 or server ip address mysql config file