Recover deleted db in a vps

[radiotounsi]

Hi,
the directory var/log/mysql was mistakenly deleted and i dont have backup for it.
Is there a way to recover files ?
I am on a vps with centos 7

[TrevorH]

Not reliably. The longer you leave the system online and writing to the disk that was on, the more difficult and less reliable any recovery will be. If you have not restarted mysql then there may be a bodge where you can access the files that the server still has open but your best bet is to break out your backups and restore...

[pjsr2]

/var/log/mysql contains the log files for the mysql server. Just recreate the directory and restart the mysql daemon. You may only have lost some log messages. The transaction logs for the database, which contain crucial information for the database contents, are in the /var/lib/mysql directory. Also, your database files are in /var/lib/mysql. So, as long as you did not delete anything under the /var/lib/mysql directory, you shouldn't have lost any information that was stored in the database.