Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-17591

Create MariaDB named commands

    XMLWordPrintable

Details

    • Task
    • Status: Closed (View Workflow)
    • Blocker
    • Resolution: Fixed
    • 10.4.6
    • OTHER
    • None

    Description

      MariaDB Server makes use of a lot of commands named mysql something. We should introduce mariadb names for the commands.

      Manual article examples (compare ease of reading)

      ALTERNATIVE 1a (change mysql to maria, preserve existing underscore)

      The mariadump client utility performs logical backups, producing a set of SQL statements. mariadump requires at least the SELECT privilege for dumped tables. mariadump output can include ALTER DATABASE statements that change the database collation. If your tables are primarily MyISAM tables, consider using the mariahotcopy instead, for better performance than mariadump of backup and restore operations. See Section “mariahotcopy — A Database Backup Program”. mariadump can retrieve and dump table contents row by row. There are in general three ways to use mariadump in order to dump a set of one or more tables.

      shell> mariadump [options] db_name [tbl_name ...]
      shell> mariadump [options] --databases db_name ...
      shell> mariadump [options] --all-databases
      

      mariadump is not to be confused with mariadumpslow, which is a tool to examine the slow query log. There are also mariaaccess and mariaadmin. And you will certainly find mariashow useful, and maybe even mariaslap. maria_secure_installation can be invoked without arguments, so can maria_upgrade.

      ALTERNATIVE 1b (change mysql to mariadb, preserve existing underscore)

      The mariadbdump client utility performs logical backups, producing a set of SQL statements. mariadbdump requires at least the SELECT privilege for dumped tables. mariadbdump output can include ALTER DATABASE statements that change the database collation. If your tables are primarily MyISAM tables, consider using the mariadbhotcopy instead, for better performance than mariadbdump of backup and restore operations. See Section “mariadbhotcopy — A Database Backup Program”. mariadbdump can retrieve and dump table contents row by row. There are in general three ways to use mariadbdump in order to dump a set of one or more tables.

      shell> mariadbdump [options] db_name [tbl_name ...]
      shell> mariadbdump [options] --databases db_name ...
      shell> mariadbdump [options] --all-databases
      

      mariadbdump is not to be confused with mariadbdumpslow, which is a tool to examine the slow query log. There are also mariadbaccess and mariadbadmin. And you will certainly find mariadbshow useful, and maybe even mariadbslap. mariadb_secure_installation can be invoked without arguments, so can mariadb_upgrade.

      ALTERNATIVE 2a (change mysql to maria, use dash, replace underscore to dash)

      The maria-dump client utility performs logical backups, producing a set of SQL statements. maria-dump requires at least the SELECT privilege for dumped tables. maria-dump output can include ALTER DATABASE statements that change the database collation. If your tables are primarily MyISAM tables, consider using the maria-hotcopy instead, for better performance than maria-dump of backup and restore operations. See Section “maria-hotcopy — A Database Backup Program”. maria-dump can retrieve and dump table contents row by row. There are in general three ways to use maria-dump in order to dump a set of one or more tables.

      shell> maria-dump [options] dbname [tblname ...]
      shell> maria-dump [options] --databases dbname ...
      shell> maria-dump [options] --all-databases
      

      maria-dump is not to be confused with maria-dump-slow, which is a tool to examine the slow query log. There are also maria-access and maria-admin. And you will certainly find maria-show useful, and maybe even maria-slap. maria-secure-installation can be invoked without arguments, so can maria-upgrade.

      ALTERNATIVE 2b (change mysql to mariadb, use dash, replace underscore to dash)

      The mariadb-dump client utility performs logical backups, producing a set of SQL statements. mariadb-dump requires at least the SELECT privilege for dumped tables. mariadb-dump output can include ALTER DATABASE statements that change the database collation. If your tables are primarily MyISAM tables, consider using the mariadb-hotcopy instead, for better performance than mariadb-dump of backup and restore operations. See Section “mariadb-hotcopy — A Database Backup Program”. mariadb-dump can retrieve and dump table contents row by row. There are in general three ways to use mariadb-dump in order to dump a set of one or more tables.

      shell> mariadb-dump [options] dbname [tblname ...]
      shell> mariadb-dump [options] --databases dbname ...
      shell> mariadb-dump [options] --all-databases
      

      mariadb-dump is not to be confused with mariadb-dump-slow, which is a tool to examine the slow query log. There are also mariadb-access and mariadb-admin. And you will certainly find mariadb-show useful, and maybe even mariadb-slap. mariadb-secure-installation can be invoked without arguments, so can mariadb-upgrade.

      Attachments

        Issue Links

          Activity

            People

              ratzpo Rasmus Johansson (Inactive)
              ratzpo Rasmus Johansson (Inactive)
              Votes:
              1 Vote for this issue
              Watchers:
              12 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.