Snippets about mariadb

4 snippets

Back to all snippets

  1. SNP140

    Create a database user in MariaDB

    One user per application, with only the rights it needs.

    6 lines of sql in 2 blocks, 6 lines of explanation.

    #925 sql mariadb

  2. SNP077

    Delete duplicate rows but keep one

    Clean up a table after finding the duplicates, keeping the oldest of each.

    10 lines of sql in 3 blocks, 6 lines of explanation.

    #396 sql mariadb

  3. SNP039

    MariaDB in Docker for local development

    A database for the project that you can throw away and recreate in a second.

    17 lines of yaml and sh in 2 blocks, 4 lines of explanation.

    #952 docker sql mariadb

  4. SNP033

    Dump and restore a MariaDB database

    Backups, moving a database to another server, or copying production to your machine.

    4 lines of sh in 3 blocks, 6 lines of explanation.

    #953 sql mariadb cmd