Difference between revisions of "MySQL"
Jump to navigation
Jump to search
(→How To) |
|||
| 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] | ||
| − | ** [ | + | ** [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. | ||
Revision as of 14:35, 15 April 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
- SQL Syntax:
- Versions: stuff particular to specific versions
- Related
- How-To:
- /porting/data: backing up and restoring
- /notes: disorganized information, mostly how-to
- Components:
- MySQL Administrator
- MySQL Query Browser - now replaced with Workbench
- MySQL Workbench
- /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.