Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
Accidentally did rm -rvf /var/lib/mysql [SOLVED]
View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index Networking & Security
View previous topic :: View next topic  
Author Message
audiodef
Watchman
Watchman


Joined: 06 Jul 2005
Posts: 6308
Location: /usr/lib64/lv2

PostPosted: Mon Oct 09, 2017 5:17 pm    Post subject: Accidentally did rm -rvf /var/lib/mysql [SOLVED] Reply with quote

I just did rm -rvf /var/lib/mysql.

Yes, I know. I am an absent-minded moron and I typed this command mistakenly in a terminal when I thought I was somewhere else where this command would not have affected anything serious. As it was, this was on my production server.

I am ready to @#$%$ing kill myself. This blew multiple live projects out of the water.

How can I fix this? I made mysqldump backups of all my databases right before I did this, as I was getting ready to duplicate my mysql server elsewhere.
_________________
Gentoo Studio: A Gentoo-based, professional digital audio workstation OS.


Last edited by audiodef on Mon Oct 09, 2017 9:42 pm; edited 1 time in total
Back to top
View user's profile Send private message
pjp
Administrator
Administrator


Joined: 16 Apr 2002
Posts: 17764

PostPosted: Mon Oct 09, 2017 5:39 pm    Post subject: Reply with quote

Do you have OS backups which include other files under /var/lib/mysql? I can't remember what is there, but I'm thinking there may be other useful files.

Otherwise I'd test creating a db to see if it will work, and if not, resintall mysql to get /var/lib/mysql properly recreated. Then I'd restore from the dump files. I don't have the scripts I used readily available, but this ought to get you started.
_________________
I honestly think you ought to sit down calmly, take a stress pill, and think things over.
Back to top
View user's profile Send private message
audiodef
Watchman
Watchman


Joined: 06 Jul 2005
Posts: 6308
Location: /usr/lib64/lv2

PostPosted: Mon Oct 09, 2017 5:52 pm    Post subject: Reply with quote

Crisis mostly averted. Was able to restore my mysqldumps.

Goddammit. I'm sending my brain to jail.
_________________
Gentoo Studio: A Gentoo-based, professional digital audio workstation OS.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Networking & Security All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum