MySQL: Difference between revisions
Jump to navigation
Jump to search
m (→Links) |
m (→Links) |
||
| (9 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 == | == Software == | ||
| Line 38: | Line 40: | ||
* Sample chapter of [http://www.webdatabasebook.com/ Web Database Applications with PHP and MySQL] website | * 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 | ; Tutorial - MySQL | ||
| Line 43: | Line 47: | ||
* [http://dev.mysql.com/doc/refman/5.1/en/tutorial.html MySQL Tutorial] (at mysql.com) | * [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]] | [[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