My Cyberpanel was showing disk usage problems so I SSH’d into the server to follow some guides and obviously did something wrong as none of my websites or Cyberpanel admin screen connnect!
I was able to SFTP in using Filezilla to get at my Wordpress files but now that’s refusing to connect. All I really want are my websites intact and recoverable, so even if I have to bin Cyberpanel and reinstall another, that’s fine, but I’m struggling to know where to begin.
I have been able to get back into SFTP using my phone’s hotspot so I assume the server had blacklisted my IP address.
I’m not really too worried about getting cyberpanel up and running, it’s the websites I have in there which I can see in the /home folder plus the databases stored in var/lib/mysql although they are all frm/ibd files that I don’t know much about.
Is there a way to dump the entire server into a downloadable form or else some kind of GUI filemanager that would allow me to get at those files. Or I could just download them through the FTP as well, it’s whether they’re restorable with those database files?
Reinstall cyberpanel or MySQL? I’m guessing now that Cyberpanel is actually OK and the problem is the inability to restart the database - but without being able to backup/get at the database files, I’m not sure what to do next as don’t want to lose what’s stored in them.
Thanks very much for your help! That throws up this return:
mysqldump: Got error: 2002: "Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")" when trying to connect
Mariabackup writes the backup files the target directory. If the target directory doesn’t exist, then it creates it. If the target directory exists and contains files, then it raises an error and aborts.