Hello sir,
We are trying to export our database from phpmyadmin but it only we export 30 MB database and exclude others can you provide a solution fo this.
Welcome @Mehul Happy you are here
Check this out 4 - Change Upload Limit for phpMyAdmin - 08 - Server - CyberPanel Community
Dont forget to run the command systemctl restart lscpd after following said tutorial
The problem he specified was exporting from phpmyadmin and not importing… The solution you showed works for importing but the issue he is referring to is an ongoing issue that was never resolved or properly addressed. phpmyadmin backup problem
A workaround is to use mysqldump but that is only a workaround and not a solution to a main feature. If anyone does not know about this issue, their backups would be in a mess as I would have learnt the hard way. There should be a solution and this issue should be address by the devs. I am yet to find a proper working “solution” and not a workaround.
Another workaround (Without the need for constantly using SSH to mysqldump) is to set the save path in your phpmyadmin config file /usr/local/CyberCP/public/phpmyadmin/config.inc.php
$cfg[‘UploadDir’] = ‘/home/sql’;
You can then create a directory to store your backups (User must be set in order for phpmyadmin to be able to save to the directory or set to permission 777)
mkdir /home/sql
chown -R lscpd:lscpd /home/sql
From there you can access FTP to download.
https://docs.phpmyadmin.net/en/latest/config.html#web-server-upload-save-import-directories
If its just an export then see this Steps to change PHP version in right way - #11 by josephgodwinke this the quickest way for you users to get their dumps. Ideally your customer should be given favorable ways to get their data and the best way is to make backups mandatory so that the dumps go to their backup directories and get synced to their cloud. You cannot compare the download speed of an s3 compliant backup/gdrive/mega etc and your server downloads