unix - Y Generation

&nbps;Home ✈️ Travel ⚾ Baseball 🛠 Tech 📘 Language 👨🏻 Politics About Y Generation 😈

👩🏼‍💻 tech-note

How to replace a string in a file using sed?

According to the answer over Stack Overflow, you must create a temporary file and mv it to the original file. For example: sed -e 'script

According to the answer over Stack Overflow, you must create a temporary file and mv it to the original file.

For example:

sed -e 'script script' index.html > index.html.tmp && mv index.html.tmp index.html

This is pretty daunting... I wish there were any alternatives...

-->

👩🏼‍💻 tech-note

How to drop all tables in MySQL?

It is simple enough if you don't care about permissions, etc..., which is true of my local test database. mysql -uUSER -p -e "drop dat

It is simple enough if you don't care about permissions, etc..., which is true of my local test database.

mysql -uUSER -p -e "drop database YOUR_DB;"
mysql -uUSER -p -e "create database YOUR_DB;"
mysql -uUSER -p YOUR_DB < SQL_FILE.sql

And now you get a refreshed DB.

If you don't mind getting