MySQL

This article or section is a stub. It does not yet contain enough information to be considered a real article. In other words, it is a short or insufficient piece of information and requires additions.

Draft

## Definition[edit | edit source]

* 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:

* SQL
* SQL and MySQL tutorial

## Software[edit | edit source]

See WAMP (windows) and LAMP (Linux)

## Links[edit | edit source]

General

* Database management system
* Wikipedia MySQL article
* MySQL Main Web Site

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