MySQL: Difference between revisions
from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
No edit summary |
|||
| Line 5: | Line 5: | ||
[[license::libre/open source]] | [[license::libre/open source]] | ||
</hide> | </hide> | ||
[[category:needs update]] | |||
==About== | ==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]]. | ||
| Line 18: | Line 19: | ||
** [[MS Access and MySQL]] | ** [[MS Access and MySQL]] | ||
* '''How-To''': | * '''How-To''': | ||
** [[/ | ** [[/migration]]: backing up and restoring | ||
** [[/notes]]: disorganized information, mostly how-to | ** [[/notes]]: disorganized information, mostly how-to | ||
* '''Components''': | * '''Components''': | ||
** [[MySQL Workbench]] | ** [[MySQL Workbench]] | ||
* [[/archive]]: older stuff that probably is no longer applicable | * [[/archive]]: older stuff that probably is no longer applicable | ||
| Line 45: | Line 44: | ||
* '''2016-05-13''' [https://medium.com/@adamhooper/in-mysql-never-use-utf8-use-utf8mb4-11761243e434 In MySQL, never use "utf8". Use "utf8mb4".] | * '''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] | * '''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]] | |||
Revision as of 16:37, 4 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
- SQL Syntax:
- Versions: stuff particular to specific versions
- Related
- How-To:
- /migration: backing up and restoring
- /notes: disorganized information, mostly how-to
- Components:
- /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.
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
Archive
These two apps have been merged into MySQL Workbench:
