How to set timeout to dump in database.php?

Asked

Viewed 70 times

0

I need to increase the timeout of MySQL for the execution of a dump bank.

'mysql' => [
            'driver' => 'mysql',
            'host' => env('DB_HOST', 'localhost'),
            'port' => env('DB_PORT', '3306'),
            'database' => env('DB_DATABASE', 'forge'),
            'username' => env('DB_USERNAME', 'forge'),
            'password' => env('DB_PASSWORD', ''),
            'charset' => 'utf8',
            'collation' => 'utf8_unicode_ci',
            'dump_command_timeout' => 60 * 20, // 5 minute timeout
            'dump_using_single_transaction' => true,
            'prefix' => '',
            'strict' => true,
            'engine' => null,
         ],

I’m using the dump_command_timeout package spatie/Laravel-backup, but it doesn’t work if the server falls into 60 seconds. I looked into it and I couldn’t find anything about it.

Someone uses this package and knows how to set up database.php?

mysql laravel laravel-5 laravel-eloquent

  • This database of yours is big?

  • @Virgilionovic yes, 1.1 GB and will grow....

  • So that’s it @Marcelogomes, the Server has a timely run of a Script and this backup with this plugin I believe is for much smaller banks.

  • @Virgilionovic knows some tool or component that can help me in this work?

  • I’m looking for something and then if I find any answer for you, but so far nothing! the bank is very large and then runs a little away from the script because it depends on the server, but, let’s try

  • OK if I can, I’ll do the same. Thank you

Show 1 more comment
No answers

Browser other questions tagged mysql laravel laravel-5 laravel-eloquent

You are not signed in. Login or sign up in order to post.