Archives for My Lazy and Forgetful Mind
Understanding the MySQL Import Command with Custom Parameters When importing large SQL dump files into MySQL, it is often necessary to adjust MySQL’s configuration parameters to handle large queries and improve performance. The following command is an example of importing a database dump while customizing MySQL’s memory settings and disabling foreign key checks: "D:\xampp\mysql\bin\mysql" –max_allowed_packet=512M […]
https://stackoverflow.com/questions/42244541/laravel-migration-error-syntax-error-or-access-violation-1071-specified-key-wa check if ‘mysql’ => [ …, …, ‘engine’ => env(‘DB_ENGINE’, ‘InnoDB’), ] or InnoDB ROW_FORMAT=DYNAMIC solve the problem, if still error, try accepted answer about Schema::defaultStringLength(191);
1. Find Composer Installation Path Windows Run the following command to check system paths: php -r "echo getenv('PATH');" Look for a path similar to: C:\ProgramData\ComposerSetup\bin\ Or search for "composer" in the output. linux no need to search phar, we can use which below 2. Run Composer Using a Specific PHP Version Windows Once you find […]
Option With a single xampp installation, you have 2 options: Run an older PHP version for only the directory of your old project: This will serve the purpose most of the time. You may have one or two old projects that you intend to run with an older PHP version. Just configure xampp to run […]