vkovic / laravel-commando

Collection of handy Laravel artisan commands that most projects needs
MIT License
60 stars 10 forks source link

--no-tablespaces required in recent MySQL update #13

Open vkovic opened 2 years ago

vkovic commented 2 years ago

Breaking change introduced in minor MySQL update, use --no-tablespaces option in mysqldump from now on (recommended) or add the global PROCESS privilege to the user running the command.

DbDumpCommand::handle() should now add "--no-tablespaces" flag to the command to finally look something like this:

$command = "mysqldump --no-tablespaces -h $host -u$user -p$password $database $removeDefiner $removeDbPrefix > $destination";