MySQL: Difference between revisions

The educational technology and digital learning wiki
Jump to navigation Jump to search
 
(16 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 MSQL article]
* [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)
* Yank, Kevin (2002). [http://www.databasejournal.com/features/mysql/article.php/138359 Build Your Own Database Driven Website Using PHP & MySQL: Pt. 1], ''[http://www.databasejournal.com Database Journal]]''.
 
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.
 
* Yank, Kevin (2002). [http://www.databasejournal.com/features/mysql/article.php/138359 Build Your Own Database Driven Website Using PHP & MySQL: Pt. 1], ''[http://www.databasejournal.com Database Journal]''.
 
* Yank, Kevin (2002). [http://www.databasejournal.com/features/mysql/article.php/1384211 Build Your Own Database Driven Website Using PHP & MySQL: Pt. 2], ''[http://www.databasejournal.com Database Journal]''.
 
* Yank, Kevin (2002). [http://www.databasejournal.com/features/mysql/article.php/1402121 Build Your Own Database Driven Website Using PHP & MySQL: Pt. 3], ''[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)


* Yank, Kevin (2002). [http://www.databasejournal.com/features/mysql/article.php/1384211 Build Your Own Database Driven Website Using PHP & MySQL: Pt. 2], ''[http://www.databasejournal.com Database Journal]]''.
; 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 !


* Yank, Kevin (2002). [http://www.databasejournal.com/features/mysql/article.php/1402121 Build Your Own Database Driven Website Using PHP & MySQL: Pt. 3], ''[http://www.databasejournal.com Database Journal]]''.
; 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)


* 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]]''.
The bottom line for checking is:
mysqlcheck -c your_data_base_name -u root -p




[[Category:technologies]]
[[Category:databases]]
[[Category: AMP]]

Latest revision as of 15:04, 29 April 2013

Draft

Definition

  • 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.

  • Williams, Hugh, E. (2002). Tips for Building Web Database Applications with PHP and MySQL, onLamp article (O'Reilly Databases). HTML
Tutorial - MySQL
The MysQL Command line tools.
Repairing tables using mysqlcheck

The bottom line for checking is: 

mysqlcheck -c your_data_base_name -u root -p
Retrieved from "https://edutechwiki.unige.ch/mediawiki/index.php?title=MySQL&oldid=43320"