Each time after updating or installing Laravel Homestead I take these steps. (Step 1) Add Homestead to Firefox & Chrome (Step 2) Fix Max Packet Size MySQL (Step 3) Disable strict database date settings in MySQL (Step 4) Import and configure Postgres databases (Step 5) Set the max upload size of nginx. (Step 6) Set […]
SSH is a very repetitively used tool in development. Save time and keystrokes with these tips and tricks. SSH Config Having an SSH config file is a great way to speed along the process of tunneling into a server by remembering the more exceptional connection details for you and supplying autocomplete for the ssh command. […]
If you are using MySQL 8 or 5.7, on Laravel Forge, for example, use the command sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf. The options file /etc/mysql/conf.d/mysql.cnf is not the .cnf file we are using in this particular instance. Then add the sql_mode options you need and wrap them in quotes under the [mysqld] group. The sql_mode options needed […]
There are many ways to export and import data from a database. You can use a Mac client like Sequal Pro for MySQL, for example. You can do the same for PostgreSQL, though I have not settled on a Mac client for PostgreSQL. Mac clients aside, you need can import and export your database SQL […]
Backing up files and storing them in a remote location should be done on a regular basis. Backups are vital. They ensure your code and assets are available if your server is hacked, destroyed and when your data is lost or corrupted. In WordPress, you could use a plugin like BackupBuddy to manage your backups. […]