• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • Support for BIND DNS has been removed from Plesk for Windows due to security and maintenance risks.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS.

Need to recover website's database from server backups

X

XCore

New Pleskian
The domain for this website was deleted (in error) which also deleted the files and database.
I readded the domain and the database all with same names and paths.
I have the server backups which have the MySQL database files for the website. All the files are 'frm', 'MYD' and 'MYI' files. I have no idea how to restore the database from these files.
I have tried simply copying the files to the newly created database folder at '/var/lib/mysql/user_db' (same name as before the deletion) but many of the tables "don't exist" when I try to access them via phpmyadmin.

Any help is greatly appreciated.
- Plesk v12.5.30_build1205150826.19 os_CentOS 6
- MySQL 5.1.73-5.el6_6

Thanks!
 
You must log in or register to reply here.

Similar threads

M
Issue Can't restore specific database from backup
Replies
5
Views
872
Kaspar
K
SacAutos
Question restore backup not owner
Replies
1
Views
411
SacAutos
SacAutos
A
Question How to extract the MySQL dump of Docker based DB from and old server backup?
Replies
2
Views
1K
anatol
A
S
Question Is there any way to get backup after expired license key?
Replies
2
Views
812
sakii
S
F
Issue Server Error 500 Plesk\Exception\Database
Replies
3
Views
635
scsa20
scsa20
Back
Top