To be able to export or import a database to the server you need first to create folders where to export and from where to import db.
For me, it is the same folder…
Create a folder in the desired place on the server and grant it 777 privileges
After that set the upload and save directories to the phpmyadmin/config.inc.php file
On Linux machines
gedit /etc/phpmyadmin/config.inc.php
On CyberPanel
gedit /usr/local/CyberCP/public/phpmyadmin/config.inc.php
Finally, add an absolute path for both the ‘upload’ and ‘save’ directories:
$cfg['UploadDir'] = '/etc/phpmyadmin/upload';
$cfg['SaveDir'] = '/etc/phpmyadmin/save';