Difference between revisions of "MySQL"
Jump to navigation
Jump to search
(navbar & overview headers; moved query browser bugs to query browser page) |
(→How To) |
||
(19 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
− | + | <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]]. | [[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) | + | 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== | ==Articles== | ||
− | * ''' | + | * '''SQL Syntax''': |
− | ** [[ | + | ** [[/GROUP_CONCAT]] |
− | ** [[backing up | + | ** [[/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''': | * '''Components''': | ||
** [[MySQL Administrator]] | ** [[MySQL Administrator]] | ||
− | ** [[MySQL Query Browser]] | + | ** [[MySQL Query Browser]] - now replaced with Workbench |
− | + | ** [[MySQL Workbench]] | |
− | + | * [[/archive]]: older stuff that probably is no longer applicable | |
− | |||
− | |||
− | * | ||
− | * | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
==Links== | ==Links== | ||
− | * [http://mysql.com/ | + | ===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/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 | + | * {{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 [[ | + | * [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] | ||
+ | ** [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] |
Latest revision as of 14:35, 15 April 2024
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:
- Versions: stuff particular to specific versions
- Related
- 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
- Wikipedia
- HashMySQL wiki: official wiki of the unofficial-but-sanctioned #mysql IRC channel on freenode
How To
- repair munged tables
- 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.