Below is a list of very common MySQL/MariaDB commands that any developer should know by heart. Export MySQL Database mysqldump -u username -p database_name > dump.sql Import MySQL Database mysql -u username -p -h servername database-name < data.sql Login MySQL Database mysql -uusername -p Create MySQL Users CREATE USER ‘username’@’localhost’ IDENTIFIED BY ‘password’; GRANT ALL PRIVILEGES ON database . tablename […]
Useful MySQL Commands Read More »
Database 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 »
Below 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 »
The first in a new segment I will be creating will deal with PHP and MySQL tips and tricks. To start things off, we are going to look at how to find distance from one point on earth to another with just two zip codes!
Determining Distance With Latitude and Longitude in MySQL Read More »
Need to setup a server for locally developing PHP and MySQL web site and applications? Here is a step by step guide to installing your own local server.
Installing a Virtual LAMPP Server with VirtualBox and Ubuntu Read More »
