Welp. That just happen. I just deleted my live production database and I don't have a backup.
Yesterday I completed my new website Logname and de...
For further actions, you may consider blocking this person and/or reporting abuse
Before you smack the enter button on a dangerous command, add a space to the start.
It will make sure the command isn't saved in history.
I didn't know this was a thing....ty!
this is gold!!!
I wish I know this earlier. Thanks!
Ouch! 😥 Lots of us know this feel all too well. Welcome to the club. 🤭
Here is a song to commemorate this thing you learned today....
"Everybody's gotta learn some time..."
youtu.be/gkH3LpvOo0U
haha thanks.
BTW that movie is one of my favourite.
I had a client come to me years ago who had done this same thing after a product launch and a heavy round of user registrations. I was able to reproduce a significant amount of registration data by parsing it out of the request logs generated by the framework they were using and the proxy in front of it. We were able to get usernames and email addresses, recreate the accounts and send an email asking everyone to reset their passwords.
You may be able to do something similar depending on your stack. Good Luck.
Never thought about using the log. Will try and see what I can salvage. At the very least I can email them individually.
Thanks!
Oh man. That suuuuuucks. I'm sorry that happened! 😟 Especially right after posting about it on Reddit etc, that must've been quite the gut punch.
It's a super easy mistake to make - I think all you can do is learn from it to double check what's in the terminal before smoshing Enter but I think sometimes that sort of thing just happens.
On that note, I highly recommend Digital Ocean for hosting your apps when you're getting to the stage where you are now, as you're clearly moving into production.
Heroku is fun and easy to set up for hobbyist projects, but isn't cost effective in the long term if you plan on scaling Logname upwards as a business.
I mention DO in particular is because I love their automatic weekly backups service on Databases, especially because of the super clear pricing whereby the backups cost a flat 20% on top of your basic rate.
Shamelessly plugging my referral link: m.do.co/c/31c29b0c4e37 <-- You get $100 USD in DO credits using this link.
Good luck out there.
I actually used DO before but I found Heroku much easier to start with. I agree the price is expensive when you scale up but I have never need to do it in the first place.
Hopefully that will change soon!.
Thanks for the referral link. Will keep that when I used DO the next time.
Is the project open sourced?
Is there a way to contribute?
Unfortunately no. I'm not sure what to do with the project yet but I will let you know if it is open sourced.
For anything important, I recommend Google Cloud SQL. Has restore options and many other features available.
I was very concerned with using Postgresql provided by Heroku because Heroku would often move the database out on top of their fairly expensive pricing and low transparency what is going on in your DB. I looked at other solutions and Google was the most comprehensive. I'm using it for my website scala-algorithms.com (PG 13)
I'm sorry this happened to you. But at the same time, you learned with it. Nothing I write here will drive the feeling away from you though.
Wishing luck for you and Logname! PS: I love it and I'll probably start using it ;)
Yeah I one time deleted my production database because my ORM configuration (copied from Stack Overflow) had a setting to wipe the database (since it assumed it was an in-memory development instance lol). Luckily AWS had automatic backups but I’m pretty sure I almost had a heart attack.
Yeah I definitely know the feeling!
You live and you learn...
True!
Amazing experience you have in your life as developer 😆. Good luck!
One of many!
Sorry for you, mate. I guess this was your last time without automatic backup. You’ve definitely learned the lesson in a hard way.
Yeah. As the other commenter said "You live and you learn".
😂😂 happens to me once a year.
But after the first one I had working backups.
Also don't forget to test your backups if you do some. One incomplete backup is not enough. Happened once too...
Will do. Thanks for the tip!
Arf, try object storage for files. Pretty easy to use and reliable. Versioning and confirmation to delete will save believe me.
🙄🤔😒😀😄😀😀
Seems similar to this one
youtu.be/X6NJkWbM1xk
Came here from Indiehackers op, hope you're doing well now.
Still better than rm -rf.
Cheer up and hae a backup plan nex time
Thanks yeah. Since it was just day 1 I never setup the backup.
Not easy. It's sometimes not recommended to use CTRL+R to find a previously used command, as you may choose the wrong command.
I know I did!