User Tools

Site Tools


dba:tools:start

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
dba:tools:start [2025/11/20 16:08] – created mlivolsidba:tools:start [2025/11/30 17:14] (current) mlivolsi
Line 1: Line 1:
 +==== A tool to mimic SQL*PLus but for MySQL ====
  
 +  * The script below is called "msql" and the syntax: 
 +      * msql username/password@instance:schema
 +  * Location: /usr/local/bin
 +  * TNS File location: /etc/mysql/network/admin/tnsnames.mysql
  
 +** Usage **
  
 +<code>
 +msql <username>/<password>@entry:schema
 +</code>
  
  
 +** An example entry **
 +<code>
 +db01,db =
 +(
 +    (connect_data =
 +      (host = db1.mikelivolsi.com)
 +      (schema = some_schema)
 +      (port = 3306)
 +    )
 +)
 +</code>
  
- +** The code to make it all work **
- +
 <code> <code>
 #!/bin/bash #!/bin/bash
dba/tools/start.1763654880.txt.gz · Last modified: by mlivolsi