Difference between revisions of "MySQL"

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Jump to navigation Jump to search
 
(3 intermediate revisions by the same user not shown)
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]]
+
** [[mysqlcheck]]
−
** [[MySQL Query Browser]] - now replaced with Workbench
+
** [[mysqldump]]
 
** [[MySQL Workbench]]
 
** [[MySQL Workbench]]
 
* [[/archive]]: older stuff that probably is no longer applicable
 
* [[/archive]]: older stuff that probably is no longer applicable
Line 35: 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]
−
** [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.
  
Line 45: Line 45:
 
* '''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]]

Latest revision as of 14:55, 6 November 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

Links

Reference

How To

News

Archive

These two apps have been merged into MySQL Workbench:

Retrieved from "https://htyp.org/mw/index.php?title=MySQL&oldid=28985"