cd /var/www/vhosts/example.com/httpdocs


mysqldump --add-drop-table -u admin -p`cat /etc/psa/.psa.shadow` dbname > dbname.sql




importing the database 


mysql -f -u admin -p`cat /etc/psa/.psa.shadow` dbname < dbname.sql



remove definer from dump 


sed -i 's/DEFINER=[^*]*\*/\*/g' mydump.sql