Categories
Laravel Servers Web

How I configure Laravel Homestead after installing it on Mac

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 […]

Categories
Servers Web

SSH Tips and Tricks

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. […]

Categories
Fix Laravel Servers SQL Web

Disable MySQL Strict Mode and NO_ZERO_DATE Errors in Laravel Homestead

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 […]

Categories
Laravel Servers SQL Web

Import and Export MySQL and PostgreSQL

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 […]

Categories
Servers Web

Server Level CRON Backups

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. […]