Support the ongoing development of Laravel.io →
Database Eloquent
Last updated 1 year ago.
0

Thanks for sharing this tips. I like it very much.

0

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.

0

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.

0

Sign in to participate in this thread!

Eventy

Your banner here too?

Moderators

We'd like to thank these amazing companies for supporting us

Your logo here?

Laravel.io

The Laravel portal for problem solving, knowledge sharing and community building.

© 2024 Laravel.io - All rights reserved.