MySQL

<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:
  • /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

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: see mysqlcheck
• 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:

• MySQL Administrator
• MySQL Query Browser