Bill Haofei Gong x-magic

## mariadb_tzdata.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                x-magic
                / mariadb_tzdata.md
            
            
              Last active
              October 8, 2023 12:54
                — forked from brianburridge/gist:11298396
            
              
                How to load MySQL/MariaDB time zone tables from macOS tzdata files
              
          
    The easiest way to load the MySQL Time Zone tables from your macOS tzdata is via this command:
mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql

Once the file is imported, you'll need to restart MySQL or MariaDB:
# Determine if you have MySQL or MariaDB
brew list


## ikea_open_close_remote.yaml
blueprint:
  name: IKEA Open/Close Remote
  description: 'Control your roller blind with an IKEA 2 button square remote which comes with "Fytur" or " Kadrilj" roller blinds.'
  domain: automation
  input:
    remote:
      name: Remote
      description: IKEA remote to use
      selector:
        device:
	blueprint:
	name: IKEA Open/Close Remote
	description: 'Control your roller blind with an IKEA 2 button square remote which comes with "Fytur" or " Kadrilj" roller blinds.'
	domain: automation
	input:
	remote:
	name: Remote
	description: IKEA remote to use
	selector:
	device: