I have recently messed up my debian server and I have only sftp access for my files. I rescue almost everything except of my database.
I have no longer direct ssh access, other than in rescue mode, which I cant use mysqldump etc.
Is there any way to backup my database from sftp? I copied and pasted the directory /var/lib/mysql/db to my new server. phpMyAdmin lists the tables but when you click on the it says that they do not exist. how to get my database back if the server is no longer accessible via terminal?