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

 

[oleg_maccen11890]

in which file to register another ip for remote access? My IP is static

 

[admin]

Please follow this guide article to enable remote login: https://www.digitalocean.com/community/tutorials/how-to-allow-remote-access-to-mysql

Thanks

 

[oleg_maccen11890]

nano /etc/mysql/mysql.conf.d/mysqld.cnf
add
bind-address = 0.0.0.0

add
sudo ufw allow from remote_IP_address to any port 3306

not work

 

[admin]

Could you please share server credentials over support ticket, We will look into it

Thanks,

 

[oleg_maccen11890]

write to support, I will be glad to help

 

[admin]

/etc/mysql/mysql.conf.d/mysqld.cnf
change bind-address to 0.0.0.0

and Now create new user replace 48.145.78.109 with remote ip address using to connect

CREATE USER 'root'@'48.145.78.109' IDENTIFIED BY 'fvE(Qa^W8zJ8';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'48.145.78.109';
FLUSH PRIVILEGES;