New answers tagged

1

It should be as simple as set -e mysql -h localhost -D test -ppassword <<-RENAME || true SET FOREIGN_KEY_CHECKS=0; RENAME TABLE $table TO $table\_keep; SET FOREIGN_KEY_CHECKS=1; RENAME or you could put it in an if statement set -e if mysql -h localhost -D test -ppassword <<-RENAME SET FOREIGN_KEY_CHECKS=0; ...


3

SQL queries can an are often written on several lines as they can easily get lengthy. So the newline character in SQL is just another form of whitespace and queries have to be terminated by a semi-colon (;). So until you enter that ;, the query is not terminated and if you press Enter, mysql reminds you so by issuing a secondary prompt.


1

You've run in to this note from the MySQL documentation (see https://dev.mysql.com/doc/refman/8.0/en/select-into.html): As of MySQL 8.0.17, the umask for file creation is 0640; you must have sufficient access privileges to manipulate the file contents. Prior to MySQL 8.0.17, the umask is 0666 and the file is writable by all users on the server host. So ...


-1

I've never used Freeradius, and I'm not a BSD expert. This answer just states the obvious based on the error reported in your output. There's an error listed at the end of the output: ...queries.conf[197]: Failed parsing expanded string: ...queries.conf[197]: %{tolower:type.%{Acct-Status-Type}.query} ...queries.conf[197]: ^ Unknown module A ...


0

From the MySQL documentation, it looks like mysql_multi should not be used anymore: Because systemd has the capability of managing multiple MySQL instances on platforms for which systemd support is installed, mysqld_multi and mysqld_multi.server are unnecessary and are not installed. This is true as of MySQL 5.7.13 for RPM platforms, 5.7.19 for ...


Top 50 recent answers are included