Jump to content
Main menu
Main menu
move to sidebar
hide
Navigation
Main page
Recent changes
Random page
Help about MediaWiki
Special pages
Niidae Wiki
Search
Search
Appearance
Create account
Log in
Personal tools
Create account
Log in
Pages for logged out editors
learn more
Contributions
Talk
Editing
MySQL
(section)
Page
Discussion
English
Read
Edit
View history
Tools
Tools
move to sidebar
hide
Actions
Read
Edit
View history
General
What links here
Related changes
Page information
Appearance
move to sidebar
hide
Warning:
You are not logged in. Your IP address will be publicly visible if you make any edits. If you
log in
or
create an account
, your edits will be attributed to your username, along with other benefits.
Anti-spam check. Do
not
fill this in!
===Command-line interfaces=== A [[command-line interface]] is a means of interacting with a computer program where the user issues commands to the program by typing in successive lines of text (command lines). MySQL ships with many [[command line]] tools, from which the main interface is the {{Mono|mysql}} client.<ref name="mysql β The MySQL Command-Line Tool">{{Cite web |url=http://dev.mysql.com/doc/refman/5.6/en/mysql.html |title=mysql β The MySQL Command-Line Tool, MySQL Reference Manual |access-date=17 June 2015 |archive-date=17 June 2015 |archive-url=https://web.archive.org/web/20150617191142/http://dev.mysql.com/doc/refman/5.6/en/mysql.html |url-status=dead }}</ref><ref name="mysqladmin - the MySQL command-line tool">{{Cite web |url=http://dev.mysql.com/doc/refman/5.5/en/mysqladmin.html |title=mysqladmin β the MySQL command-line tool, MySQL Reference Manual |access-date=18 January 2013 |archive-date=12 January 2013 |archive-url=https://web.archive.org/web/20130112203324/http://dev.mysql.com/doc/refman/5.5/en/mysqladmin.html |url-status=dead }}</ref> MySQL Utilities is a set of utilities designed to perform common maintenance and administrative tasks. Originally included as part of the MySQL Workbench, the utilities are a stand-alone download available from Oracle. Percona Toolkit is a cross-platform toolkit for MySQL, developed in [[Perl]].<ref>{{cite web|url=http://www.percona.com/software/percona-toolkit |title=Percona Toolkit|publisher=Percona |access-date=26 March 2014}}</ref> Percona Toolkit can be used to prove replication is working correctly, fix corrupted data, automate repetitive tasks, and speed up servers. Percona Toolkit is included with several [[Linux]] distributions such as [[CentOS]] and [[Debian]], and packages are available for [[Fedora Linux|Fedora]] and [[Ubuntu]] as well. Percona Toolkit was originally developed as Maatkit, but as of late 2011, Maatkit is no longer developed. MySQL shell is a tool for interactive use and administration of the MySQL database. It supports JavaScript, Python or SQL modes and it can be used for administration and access purposes.<ref>{{Cite web|url=https://dev.mysql.com/downloads/shell/|title=MySQL :: Download MySQL Shell|website=dev.mysql.com|access-date=2019-03-09}}</ref>
Summary:
Please note that all contributions to Niidae Wiki may be edited, altered, or removed by other contributors. If you do not want your writing to be edited mercilessly, then do not submit it here.
You are also promising us that you wrote this yourself, or copied it from a public domain or similar free resource (see
Encyclopedia:Copyrights
for details).
Do not submit copyrighted work without permission!
Cancel
Editing help
(opens in new window)
Search
Search
Editing
MySQL
(section)
Add topic