MySQL - Revision history

Woozle: /* How To */

2024-11-06T14:55:59Z

How To

← Older revision		Revision as of 14:55, 6 November 2024
Line 36:		Line 36:

	===How To===		===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'''		* '''data recovery'''
	** [http://dev.mysql.com/doc/refman/5.5/en/backup-and-recovery.html Chapter 7. Backup and Recovery]		** [http://dev.mysql.com/doc/refman/5.5/en/backup-and-recovery.html Chapter 7. Backup and Recovery]

Woozle: /* Articles */

2024-11-06T14:53:14Z

Articles

← Older revision		Revision as of 14:53, 6 November 2024
Line 22:		Line 22:
	** [[/notes]]: disorganized information, mostly how-to		** [[/notes]]: disorganized information, mostly how-to
	* '''Components''':		* '''Components''':
			** [[mysqlcheck]]
			** [[mysqldump]]
	** [[MySQL Workbench]]		** [[MySQL Workbench]]
	* [[/archive]]: older stuff that probably is no longer applicable		* [[/archive]]: older stuff that probably is no longer applicable

Woozle at 16:37, 4 November 2024

2024-11-04T16:37:58Z

← Older revision		Revision as of 16:37, 4 November 2024
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''':
	** [[/~~porting/data~~]]: backing up and restoring		** [[/migration]]: backing up and restoring
	** [[/notes]]: disorganized information, mostly how-to		** [[/notes]]: disorganized information, mostly how-to
	* '''Components''':		* '''Components''':
	** [[MySQL Administrator]]
	** [[MySQL Query Browser]] - now replaced with Workbench
	** [[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]]

Woozle: /* How To */

2024-04-15T14:35:37Z

How To

← Older revision		Revision as of 14:35, 15 April 2024
Line 39:		Line 39:
	* '''data recovery'''		* '''data recovery'''
	** [http://dev.mysql.com/doc/refman/5.5/en/backup-and-recovery.html Chapter 7. Backup and 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		** [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.		*** The important thing to remember is that not all of the data is in the *.fr? files.

Woozle: /* Reference */

2021-05-19T16:37:29Z

Reference

← Older revision		Revision as of 16:37, 19 May 2021
Line 32:		Line 32:
	** [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 [[~~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===		===How To===
	* '''repair munged tables'''		* '''repair munged tables'''

Woozle at 16:06, 27 October 2019

2019-10-27T16:06:45Z

← Older revision		Revision as of 16:06, 27 October 2019
Line 11:		Line 11:
	==Articles==		==Articles==
	* '''SQL Syntax''':		* '''SQL Syntax''':
			** [[/GROUP_CONCAT]]
	** [[/INSERT]]		** [[/INSERT]]
	* '''Versions''': stuff particular to specific versions		* '''Versions''': stuff particular to specific versions

Woozle at 01:06, 26 October 2019

2019-10-26T01:06:39Z

← Older revision		Revision as of 01:06, 26 October 2019
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).		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==
	* ''Versions''': stuff particular to specific versions		* '''SQL Syntax''':
			** [[/INSERT]]
			* '''Versions''': stuff particular to specific versions
	** [[/version/5.7]]		** [[/version/5.7]]
	* '''Related'''		* '''Related'''

Woozle: v 5.7

2018-12-25T02:00:49Z

v 5.7

← Older revision		Revision as of 02:00, 25 December 2018
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).		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==
			* ''Versions''': stuff particular to specific versions
			** [[/version/5.7]]
	* '''Related'''		* '''Related'''
	** [[MS Access and MySQL]]		** [[MS Access and MySQL]]

Woozle: /* News */

2018-04-04T11:33:53Z

News

← Older revision		Revision as of 11:33, 4 April 2018
Line 37:		Line 37:

	===News===		===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]		* '''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]

Woozle: /* Articles */ updating page links

2017-03-20T10:21:25Z

Articles: updating page links

← Older revision		Revision as of 10:21, 20 March 2017
Line 13:		Line 13:
	** [[MS Access and MySQL]]		** [[MS Access and MySQL]]
	* '''How-To''':		* '''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''':		* '''Components''':
	** [[MySQL Administrator]]		** [[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		* [[/archive]]: older stuff that probably is no longer applicable

	==Links==		==Links==
	===Reference===		===Reference===