MySQL: Difference between revisions

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Woozle (talk | contribs)
Bureaucrats, Interface administrators, interwiki, Administrators, trusted
20,099 edits
VisualWikitext
No edit summary
 
 
(40 intermediate revisions by 3 users not shown)
Line 1: Line 1:
{{software|MySQL}}{{seed}}[[MySQL]] is a [[FOSS]] database engine and server. It fills roughly the same niche as [[Microsoft SQL Server]].
<hide>
[[page type::article]]
[[thing type::software]]
[[software type::database engine]]
[[license::libre/open source]]
</hide>
[[category:needs update]]
==About==
[[MySQL]] is a [[FOSS]] database engine and server. It fills roughly the same niche as [[Microsoft SQL Server]].


The MySQL package (at least in Linux) comes with a number of helper utilities, including [[MySQL Administrator]] and [[MySQL Query Browser]]. The Administrator utility is useful for making backups, and the Query Browser serves as a front-end for interacting with databases. The Query Browser is, however, somewhat buggy as of version 4.
The MySQL package (at least in Linux) has a number of helper utilities available, including [[MySQL Workbench]] (a combination of the former [[MySQL Administrator]] and [[MySQL Query Browser]] applications).
==Working Notes==
==Articles==
* To work around the Query Browser bug which won't let you edit a blank table, create the first entry using MySQL's command line interface:
* '''SQL Syntax''':
** [[/GROUP_CONCAT]]
** [[/INSERT]]
* '''Versions''': stuff particular to specific versions
** [[/version/5.7]]
* '''Related'''
** [[MS Access and MySQL]]
* '''How-To''':
** [[/migration]]: backing up and restoring
** [[/notes]]: disorganized information, mostly how-to
* '''Components''':
** [[mysqlcheck]]
** [[mysqldump]]
** [[MySQL Workbench]]
* [[/archive]]: older stuff that probably is no longer applicable


woozle@camilla:~ $ mysql -h''yourhost'' -u''yourusername'' -p''yourpassword''
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 12531702 to server version: 4.1.13-standard
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use ''yourdatabasename''
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> insert into urole (''fieldname'') values("''sample value''");
Query OK, 1 row affected (0.05 sec)
mysql>
...where ''yourhost'' is the name of your MySQL server, and can be anything that can resolve to an IP address, e.g. localhost, yourmachinename, yourserverdomain.com, or an actual IP address (I think).
==Links==
==Links==
* [http://mysql.com/ MySQL] Home Page
===Reference===
* [[URL::http://mysql.com/|official site]]
** [http://dev.mysql.com/doc/refman/5.1/en/ Version 5.1 Manual]
** [http://dev.mysql.com/doc/refman/4.1/en/ Version 4.1 Manual]
** [http://dev.mysql.com/doc/refman/4.1/en/ Version 4.1 Manual]
* {{wikipedia}}
* [http://hashmysql.org/ HashMySQL wiki]: official wiki of the unofficial-but-[http://dev.mysql.com/doc/refman/5.1/en/irc.html sanctioned] #mysql [[IRC]] channel on [[freenode]]
===How To===
* '''repair munged tables''': see [[mysqlcheck]]
* '''data recovery'''
** [http://dev.mysql.com/doc/refman/5.5/en/backup-and-recovery.html Chapter 7. Backup and Recovery]
** [https://web.archive.org/web/20200712010317/https://egil.biz/how-to-recover-mysql-data-from-innodb/ How to recover MySQL data from Innodb?] - if you have a copy of /var/www/lib/mysql but MySQL can't see the data
*** The important thing to remember is that not all of the data is in the *.fr? files.
===News===
* '''2016-05-13''' [https://medium.com/@adamhooper/in-mysql-never-use-utf8-use-utf8mb4-11761243e434 In MySQL, never use "utf8". Use "utf8mb4".]
* '''2007-06-21''' [http://www.computerworld.com/action/article.do?command=viewArticleBasic&articleId=9025427&pageNumber=1 MySQL's architect discusses open source, database in a cloud, other IT issues]
==Archive==
These two apps have been merged into [[MySQL Workbench]]:
* [[MySQL Admin]]istrator
* [[MySQL Query Browser]]

Latest revision as of 14:55, 6 November 2024

<hide> page type::article thing type::software software type::database engine license::libre/open source </hide>

About

MySQL is a FOSS database engine and server. It fills roughly the same niche as Microsoft SQL Server.

The MySQL package (at least in Linux) has a number of helper utilities available, including MySQL Workbench (a combination of the former MySQL Administrator and MySQL Query Browser applications).

Articles

Reference

How To

News

Archive

These two apps have been merged into MySQL Workbench:

Retrieved from "https://htyp.org/mw/index.php?title=MySQL&oldid=28985"