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';