Difference between revisions of "MySQL"

Latest revision as of 14:55, 6 November 2024

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).

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:
/archive: older stuff that probably is no longer applicable

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.

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 22: / Line 22: @@
 ** [[/notes]]: disorganized information, mostly how-to
 * '''Components''':
+** [[mysqlcheck]]
+** [[mysqldump]]
 ** [[MySQL Workbench]]
 * [[/archive]]: older stuff that probably is no longer applicable
@@ Line 34: / Line 36: @@
 ===How To===
-* '''repair munged tables'''
+* '''repair munged tables''': see [[mysqlcheck]]
-** [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]