Over on Two simple ways to version control your MariaDB schema changes I learned a neat hack you can use to check for database schema revisions by reporting off the binlog.
The example command given was:
$ mysqlbinlog --no-defaults -R -u foo -p -d foodb -h db.home.arpa mysqld-bin.000001 > foodb.txt
Here’s some good info for configuring ODBC for MariaDB on Ubuntu for use from LibreOffice Base: LibreOffice Base and MariaDB. The same article also has some info about how to use ENGINE=CONNECT for importing JSON from web services.
So my `mysqldump` script wasn’t backing up views. I found a good solution using information_schema on Stack Overflow: Backing Up Views with Mysql Dump.
Here’s some info about Dovecot SASL. I integrate this facility for Postfix authentication too. So my SMTP system has a dependency on my IMAP/POP3 system. In the backend it’s a MySQL database…
Here’s some good documentation on PHP prepared statements and stored procedures including how to call stored procedures with output parameters.