Fork me on GitHub
Jason Antman's Blog
  • About Me
  • AWS
  • Software
  • Hardware
  • DIY / Home Automation / Security
  • Miscellaneous
  • Tags
  • Archives

Migrating Kodi to MariaDB, with locked-down permissions and no import/export

Date Sun 28 March 2021 Tags kodi / osmc / database / mysql / mariadb

Instructions for migrating Kodi from SQLite to MySQL/MariaDB, without giving root database permissions or needing import/export of media.

more ...

Simple Diagrams of MySQL Schema

Date Wed 04 May 2011 Tags database / db / diagram / mysql / sql

Jess Robinson’s SQL-Translator CPAN module translates and parses SQL statements. The SQLfairy project has some nice binaries that, among other things, use GraphViz or GD to draw pseudo-ER diagrams from SQL CREATE statements. Drawing a diagram of an SQL schema is as easy as sqlt-diagram --db=MySQL …

more ...

MySQL General Query Log and Awk Trimming Columns

Date Tue 21 December 2010 Tags awk / database / logging / mysql

So today I started to implement a number of complex regex-based rules and templates to get rsyslog to parse ISC DHCPd logs in realtime. Unfortunately one of my templates must have been wrong, because I started seeing some errors about a field that cannot be blank in /var/log/messages …

more ...

  • Recent Posts

    • Migrating Kodi to MariaDB, with locked-down permissions and no import/export
    • Simple Diagrams of MySQL Schema
    • MySQL General Query Log and Awk Trimming Columns
  • Latest Tweets

    Tweets by j_antman
  • GitHub Repos

    Status updating...

    @jantman on GitHub
  • Links

    • Homepage
    • Resume

© 2021 Jason Antman · Powered by pelican-bootstrap3, Pelican, Bootstrap

Back to top