👩🏼💻 tech-note How to update any cells in MySQL? I forgot about it so, so frequently that I decided to jot down the syntax. For example, to make all the posts unpublished in Ghost: update p
👩🏼💻 tech-note How to rename a database in MySQL? Take the following steps: mysqldump -uUSERNAME -p DBNAME > FILENAME.sql mysql -uUSERNAME -p -e "create database NEW_DBNAME;" my
👩🏼💻 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 data
👩🏼💻 tech-note Where is the MySQL socket file in macOS and Ubuntu? In macOS: /tmp/mysql.sock In Ubuntu: /var/run/mysqld/mysqld.sock
👩🏼💻 tech-note How to backup MySQL database on Compute Engine? If you are looking for how to backup your MySQL database that is hosted over a cloud instance, it shall be better to use Cloud SQL or someth