MySQL

Essential MySQL Server Management Commands

Reading Time: 5 minutesLearn how to manage your MySQL server from the command line. This beginner-friendly guide covers starting and stopping MySQL, creating users, managing databases, and performing backups and restores using real-world commands.

Essential MySQL Server Management Commands Read More »

MySQL Best Practices

Reading Time: 4 minutesDatabase operations often tend to be the main bottleneck for most web applications today. As programmers need to do our part by structuring tables properly, writing optimized queries and better code. Table Names By convention, the “snake case” in lowercase (no PascalCase – we’re not using Microsoft SQL Server here!), plural name of the class will

MySQL Best Practices Read More »

Useful Command Line Scripts

Reading Time: 2 minutesBelow is a list of very common linux commands that any linux person should know by heart. From gzipping files, to running backups this is my personal cheat sheet Compressing Files and Folders Unzip 7z Archive 7za x myfiles.7z gzip File gzip -9 file gzip Folder tar -zcvf archive-name.tar.gz directory-name Uncompress Gzip File gzip -d

Useful Command Line Scripts Read More »