MySQL

Draft

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:

• SQL
• SQL and MySQL tutorial

Software

See WAMP (windows) and LAMP (Linux)

Links

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