• Stars
    star
    140
  • Rank 261,473 (Top 6 %)
  • Language
  • Created over 11 years ago
  • Updated almost 8 years ago

Reviews

There are no reviews yet. Be the first to send feedback to the community and the maintainers!

Repository Details

A collection of scripts to help MySQL DBAs

dbahelper

A collection of scripts to help MySQL DBAs

There are install files available for 5.5, 5.6 and 5.7 respectively. To load these, you must position yourself within the directory that you downloaded to, as these top level files SOURCE individual files that are shared across versions in most cases (though not all).

For instance if you download to /tmp/dbahelper/ you should:

cd /tmp/dbahelper/
mysql -u user -p < ./ps_helper_<version>.sql

Or if you would like to log in to the client:

cd /tmp/dbahelper/
mysql -u user -p 
SOURCE ./ps_helper_<version>.sql

Alternatively, you could just choose to load individual files based on your needs, but beware, certain objects have dependencies on other objects.