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 …
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 …
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 …
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!
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.
