Framework: schema:dump error

Created on 11 Sep 2020  路  4Comments  路  Source: laravel/framework

  • Laravel Version: 8.0.4
  • PHP Version: 7.4.10
  • Database Driver & Version: MySQL 5.7.31

Description:

mysqldump: unknown variable 'set-gtid-purged=OFF'

Steps To Reproduce:

php artisan schema:dump

Most helpful comment

@vladislavtkachenko Are you using mysql-default-client a.k.a maria-db-client?
This error occurs because the --set-gtid-purged option does not exist in mariadb.

Try this:

wget https://repo.mysql.com/mysql-apt-config_0.8.15-1_all.deb -P /tmp \
  && dpkg -i /tmp/mysql-apt-config_0.8.15-1_all.deb \
  && apt-get update -y \
  && apt-get install mysql-client -y

All 4 comments

$this->getPdo()->getAttribute(PDO::ATTR_SERVER_VERSION) - returns '5.7.31'

I can't reproduce that on this version.

if you can't reproduce it, then there is no problem. ok :)

@vladislavtkachenko Are you using mysql-default-client a.k.a maria-db-client?
This error occurs because the --set-gtid-purged option does not exist in mariadb.

Try this:

wget https://repo.mysql.com/mysql-apt-config_0.8.15-1_all.deb -P /tmp \
  && dpkg -i /tmp/mysql-apt-config_0.8.15-1_all.deb \
  && apt-get update -y \
  && apt-get install mysql-client -y
Was this page helpful?
0 / 5 - 0 ratings

Related issues

ghost picture ghost  路  3Comments

gabriellimo picture gabriellimo  路  3Comments

felixsanz picture felixsanz  路  3Comments

RomainSauvaire picture RomainSauvaire  路  3Comments

SachinAgarwal1337 picture SachinAgarwal1337  路  3Comments