Phpmyadmin

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

Administrator
Staff member
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
Code:
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
 

admin

Administrator
Staff member
It's located here /usr/local/zesle/phpmyadmin, Your changed might be replaced on next update
 
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

Administrator
Staff member
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
 

admin

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

Thanks,
 

admin

Administrator
Staff member
/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;
 
Top