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?
This database of yours is big?
– novic
@Virgilionovic yes, 1.1 GB and will grow....
– Marcelo Gomes
So that’s it @Marcelogomes, the Server has a timely run of a
Scriptand this backup with this plugin I believe is for much smaller banks.– novic
@Virgilionovic knows some tool or component that can help me in this work?
– Marcelo Gomes
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
– novic
OK if I can, I’ll do the same. Thank you
– Marcelo Gomes