MySQL: Difference between revisions
Jump to navigation
Jump to search
m (using an external editor) |
m (→Links) |
||
| (15 intermediate revisions by 2 users not shown) | |||
| Line 6: | Line 6: | ||
* MySQL is the most popular DBMS open source community and it is part of the so called [[LAMP]] sofware bundle. | * MySQL is the most popular DBMS open source community and it is part of the so called [[LAMP]] sofware bundle. | ||
See also: [[SQL]] | See also: | ||
* [[SQL]] | |||
* [[SQL and MySQL tutorial]] | |||
== Software == | |||
See [[WAMP]] (windows) and [[LAMP]] (Linux) | |||
== Links == | == Links == | ||
| Line 12: | Line 18: | ||
; General | ; General | ||
* [http://en.wikipedia.org/wiki/Database_management_system Database management system] | * [http://en.wikipedia.org/wiki/Database_management_system Database management system] | ||
* [http://en.wikipedia.org/wiki/Mysql Wikipedia | * [http://en.wikipedia.org/wiki/Mysql Wikipedia MySQL article] | ||
* [http://www.mysql.com/ MySQL Main Web Site] | * [http://www.mysql.com/ MySQL Main Web Site] | ||
; Tutorials | ; Tutorials (MySQL - PHP) | ||
See also [[SQL]]. It has a list of SQL tutorials. | |||
* Merall,G. [http://www.hotwired.com/webmonkey/99/21/index2a.html?tw=frontdoor PHP/MySQL Tutorial], Hotwired. | * Merall,G. [http://www.hotwired.com/webmonkey/99/21/index2a.html?tw=frontdoor PHP/MySQL Tutorial], Hotwired. | ||
| Line 26: | Line 34: | ||
* Yank, Kevin (2002). [http://www.databasejournal.com/features/mysql/article.php/1402281 Build Your Own Database Driven Website Using PHP & MySQL: Pt. 4], ''[http://www.databasejournal.com Database Journal]''. | * Yank, Kevin (2002). [http://www.databasejournal.com/features/mysql/article.php/1402281 Build Your Own Database Driven Website Using PHP & MySQL: Pt. 4], ''[http://www.databasejournal.com Database Journal]''. | ||
* [http://blazonry.com/scripting/linksdb/ MySQL PHP Web Database Tutorial] (1999). Simple table, by web.blazonry | |||
* Williams, Hugh, E. (2002). Tips for Building Web Database Applications with PHP and MySQL, onLamp article (O'Reilly Databases). [http://www.onlamp.com/pub/a/onlamp/2002/04/04/webdb.html HTML] | |||
* Sample chapter of [http://www.webdatabasebook.com/ Web Database Applications with PHP and MySQL] website | |||
* Full text book from O'Reilly : DUBOIS, Paul. ''MySQL cookbook : solutions and examples for MySQL database developers'' [online]. [S.l.] : O'Reilly, 2002. [http://pc1968.com/estudio/MYSQL/MySQL_Cookbook.PDF http://pc1968.com/estudio/MYSQL/MySQL_Cookbook.PDF] (accessed 10.02.2010) | |||
; Tutorial - MySQL | |||
* [http://dev.mysql.com/doc/refman/5.1/en/tutorial.html MySQL Tutorial] (at mysql.com) | |||
; The MysQL Command line tools. | |||
* [http://dev.mysql.com/doc/refman/5.0/en/mysql.html 4.5.1. mysql — The MySQL Command-Line Tool] (at mysql.com). See also this link for mysqladmin, mysqlcheck, etc. | |||
* [http://www.developer.com/db/article.php/3725901 Secrets of the MySQL Client Command Line]. Knowing how to use the command line is important since you may not always have a GUI client installed. Web clients can't do everything, i.e. some dumps/uploads fail due to script execution and memory limits ! | |||
; Repairing tables using mysqlcheck | |||
* [http://www.thegeekstuff.com/2011/12/mysqlcheck/ How to Check and Repair MySQL Tables Using Mysqlcheck], by Ramesh Natarajan on December 21, 2011 | |||
* [http://stackoverflow.com/questions/7082043/how-can-you-repair-all-tables-in-all-databases-from-the-mysql-command-prompt-whe How can you repair all tables in all databases from the MySQL command prompt when MYI file is corrupted or missing?] (Stackoverflow) | |||
The bottom line for checking is: | |||
mysqlcheck -c your_data_base_name -u root -p | |||
[[Category:databases]] | [[Category:databases]] | ||
[[Category: AMP]] | |||
Latest revision as of 15:04, 29 April 2013
Definition
- MySQL is a SQL Database management system (DBMS).
- MySQL is the most popular DBMS open source community and it is part of the so called LAMP sofware bundle.
See also:
Software
See WAMP (windows) and LAMP (Linux)
Links
- General
- Tutorials (MySQL - PHP)
See also SQL. It has a list of SQL tutorials.
- Merall,G. PHP/MySQL Tutorial, Hotwired.
- Yank, Kevin (2002). Build Your Own Database Driven Website Using PHP & MySQL: Pt. 1, Database Journal.
- Yank, Kevin (2002). Build Your Own Database Driven Website Using PHP & MySQL: Pt. 2, Database Journal.
- Yank, Kevin (2002). Build Your Own Database Driven Website Using PHP & MySQL: Pt. 3, Database Journal.
- Yank, Kevin (2002). Build Your Own Database Driven Website Using PHP & MySQL: Pt. 4, Database Journal.
- MySQL PHP Web Database Tutorial (1999). Simple table, by web.blazonry
- Williams, Hugh, E. (2002). Tips for Building Web Database Applications with PHP and MySQL, onLamp article (O'Reilly Databases). HTML
- Sample chapter of Web Database Applications with PHP and MySQL website
- Full text book from O'Reilly : DUBOIS, Paul. MySQL cookbook : solutions and examples for MySQL database developers [online]. [S.l.] : O'Reilly, 2002. http://pc1968.com/estudio/MYSQL/MySQL_Cookbook.PDF (accessed 10.02.2010)
- Tutorial - MySQL
- MySQL Tutorial (at mysql.com)
- The MysQL Command line tools.
- 4.5.1. mysql — The MySQL Command-Line Tool (at mysql.com). See also this link for mysqladmin, mysqlcheck, etc.
- Secrets of the MySQL Client Command Line. Knowing how to use the command line is important since you may not always have a GUI client installed. Web clients can't do everything, i.e. some dumps/uploads fail due to script execution and memory limits !
- Repairing tables using mysqlcheck
- How to Check and Repair MySQL Tables Using Mysqlcheck, by Ramesh Natarajan on December 21, 2011
- How can you repair all tables in all databases from the MySQL command prompt when MYI file is corrupted or missing? (Stackoverflow)
The bottom line for checking is:
mysqlcheck -c your_data_base_name -u root -p