HELP! Import MySQL dbs from dead Plesk panel

[7eo]

My Plesk panel was crushed when I tried update PHP (Ubuntu 12.04).
So now I can't enter admin panel https://109.120.165.138:8443/smb/

I have another VPN with Plesk so I'd like to import my sites with MySQL databases in it.
How could I reach MySQL dbs from old Plesk on Ubuntu 12.04?

I can download dbs from /var/lib/mysql but how can I import them to new VPS account with Plesk?

Is there another ways to import content (site folders and MySQL dbs) from old account?

Thanks in advance!

 

[ipilipenko]

Hello,


If MySQL server is running:

It is necessary to backup all databases using the following command:


# mysqldump -uadmin -p`cat /etc/psa/.psa.shadow` --all-databases > all_db.sql

And restore them on the destination server


# mysql -uadmin -p`cat /etc/psa/.psa.shadow` «psa» < all_db.sql


If MySQL is stopped, please create a ticket using this link https://cscontact.plesk.com/form/32/?Product=Plesk

Regards