Breaking News: Grepper is joining You.com. Read the official announcement!

composer require spatie/laravel-backup

NN answered on August 12, 2024 Popularity 3/10 Helpfulness 1/10

answer composer require spatie/laravel-backup

composer require spatie/laravel-backup

Comment

******problem : column-statistics not found
******solution: 
1. stop the column-statistics in mysql dump command 
for to do that go config/database.php change the it like 
'mysql' => [
            'driver' => 'mysql',
            'host' => env('DB_HOST', '127.0.0.1'),
            'port' => env('DB_PORT', '3306'),
            'database' => env('DB_DATABASE', 'forge'),
            'username' => env('DB_USERNAME', 'forge'),
            'password' => env('DB_PASSWORD', ''),
            'unix_socket' => env('DB_SOCKET', ''),
            'charset' => 'utf8mb4',
            'collation' => 'utf8mb4_unicode_ci',
            'prefix' => '',
            'strict' => true,
            'engine' => null,
            'dump' => [            ///definging the dump setting
                'dump_binary_path' => env('DB_DUMP_PATH', ''),
                'use_single_transaction' => true,
                'timeout' => 60 * 5,
                'add_extra_option' => '--column-statistics=0',
            ],
2. add the DB_DUMP_PATH to the .env

DB_DUMP_PATH='C:/laragon/bin/mysql/mysql-8.0.30-winx64/bin/'     //this path is where the mysqldump.exe situated
BACKUP_ARCHIVE_PASSWORD=''

Popularity 3/10 Helpfulness 1/10 Language php

Source: Grepper

Tags: php require

Link to this answer
Share Copy Link

Contributed on Aug 12 2024

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

composer require spatie/laravel-backup

Contents

More Related Answers

composer require spatie/laravel-backup

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.