• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 601
  • Last Modified:

Recover Database From Mistake Dropped CentOS

Hello there, is there any way i can recover dropped database from CentOS Linux ?
0
DjZoC
Asked:
DjZoC
2 Solutions
 
gambithCommented:
are there any backups?
0
 
DjZoCAuthor Commented:
the backup is from 3 weeks ago ... but is not all ... is anyway to i can recover the db ?
0
 
gambithCommented:
Basically, Hardly.

DROP DATABASE drops all tables in the database and deletes the database.

now for the undelete part,  it will be quite hard to undelete the files.

There's a full tutorial on how to undelete EXT3 (http://www.xs4all.nl/~carlo17/howto/undelete_ext3.html)

if you manage to recover the files, do a recover from file to your mysql server.
0
 
Joe WoodhousePrincipal ConsultantCommented:
Adding to the above, even if you can recover the underlying files (and remember you don't have a direct relationship between files and databases - depending on your Sybase product, databases are defined on devices or dbspaces, and you have files for those)... that's still no guarantee you'll get the database back.

File system buffering may mean the underlying files are not what the database engine is looking for.

If you don't have database backups then it's pretty much gone. If your last backup is from three weeks ago then

1) that's what you can restore to, and
2) time to start running more frequent backups.
0
 
leonstrykerCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now