Difference between revisions of "MySQL"

Revision as of 16:37, 19 May 2021

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

SQL Syntax:
- /GROUP_CONCAT
- /INSERT
Versions: stuff particular to specific versions
- /version/5.7
Related
- MS Access and MySQL
How-To:
- /porting/data: backing up and restoring
- /notes: disorganized information, mostly how-to
Components:
- MySQL Administrator
- MySQL Query Browser - now replaced with Workbench
- MySQL Workbench
/archive: older stuff that probably is no longer applicable

Links

Reference

official site
- Version 5.1 Manual
- Version 4.1 Manual
Wikipedia
HashMySQL wiki: official wiki of the unofficial-but-sanctioned #mysql IRC channel on freenode

How To

repair munged tables
- 4.5.3 mysqlcheck — A Table Maintenance Program
data recovery
- Chapter 7. Backup and Recovery
- 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 In MySQL, never use "utf8". Use "utf8mb4".
2007-06-21 MySQL's architect discusses open source, database in a cloud, other IT issues

@@ Line 10: / Line 10: @@
 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==
+* '''SQL Syntax''':
+** [[/GROUP_CONCAT]]
+** [[/INSERT]]
+* '''Versions''': stuff particular to specific versions
+** [[/version/5.7]]
 * '''Related'''
 ** [[MS Access and MySQL]]
 * '''How-To''':
-** [[backing up MySQL data]]
+** [[/porting/data]]: backing up and restoring
-** [[MySQL notes]]: any loose notes not ready to be an article yet
+** [[/notes]]: disorganized information, mostly how-to
 * '''Components''':
 ** [[MySQL Administrator]]
-** [[MySQL Query Browser]]
+** [[MySQL Query Browser]] - now replaced with Workbench
-* [[/notes]]: disorganized information
+** [[MySQL Workbench]]
 * [[/archive]]: older stuff that probably is no longer applicable
 ==Links==
 ===Reference===
@@ Line 26: / Line 32: @@
 ** [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]]
+* [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'''
+** [https://dev.mysql.com/doc/refman/5.5/en/mysqlcheck.html 4.5.3 mysqlcheck — A Table Maintenance Program]
 * '''data recovery'''
 ** [http://dev.mysql.com/doc/refman/5.5/en/backup-and-recovery.html Chapter 7. Backup and Recovery]
 ** [http://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]