Category: Laravel

Disable MySQL Strict Mode and NO_ZERO_DATE Errors in Laravel Homestead

Post author By Kevin
Post date December 18, 2018
No Comments on 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 […]

Laravel Servers SQL Web

Import and Export MySQL and PostgreSQL

Post author By Kevin
Post date October 7, 2016
No Comments on 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 […]