I found the problem, all solutions above work, the issue comes from database config in config/database.php. I set it:
'production' => [
'driver' => 'mysql',
'host' => env('DB_HOST', 'pro.cm.com'),
'database' => env('DB_DATABASE', 'importer'),
'username' => env('DB_USERNAME', 'myacc'),
'password' => env('DB_PASSWORD', 'mypass'),
'charset' => 'utf8',
'collation' => 'utf8_unicode_ci',
'prefix' => '',
'strict' => false,
]
But it seems does not work with env setting, I remove all env. It become:
'production' => [
'driver' => 'mysql',
'host' => 'pro.cm.com',
'database' => 'importer',
'username' => 'myacc',
'password' => 'mypass',
'charset' => 'utf8',
'collation' => 'utf8_unicode_ci',
'prefix' => '',
'strict' => false,
]
Then it works now.
Try taking backup using "Cloudbacko software" i have experience of using CloudBacko software for my MYSQL database backup. Currently, i am using the same software because it gives me full security and protection to my data. Backup of a large 100GB MySQL Database can be finished overnight. Fast multi-thread MySQL Database backup. Block level incremental hot backup with zero downtime. MySQL Database backup pre-requisites checking guarantees restorability. Multi-destination concurrent backup. Directly restore from backup to original database. Service is very good so i would like to suggest you to have CloudBacko software for your backup plan.
Sign in to participate in this thread!
The Laravel portal for problem solving, knowledge sharing and community building.
The community