links - mysql

MySQL is an SQL-based relational database management system (DBMS) that runs under many operating systems. MySQL can be accessed through a command-line client, web client such as phpmyadmin, or os-based client.

It can also be accessed through any program that you write, in any programming language that has database capabilities. PHP and Perl are the two most widely-used programming languages for using with MySQL today.

Tutorials

Getting Started with MySQL http://dev.mysql.com/tech-resources/articles/mysql_intro.html mysql.com : 2007

MySQL 5 Tutorial at MySQL Ref Manual http://dev.mysql.com/doc/refman/5.0/en/tutorial.html Basics of MySQL MySQL : 2008

MySQL Basics http://www.analysisandsolutions.com/code/mybasic "A guide for new MySQL users, providing a reference of very basic, step by step, instructions on how to get started. This MySQL help page also gives more advanced users assistance in upgrading and running multiple versions of MySQL on a computer at the same time". Focus on MSWindows, but applies everywhere. Analysis and Solutions : 2006

MySQL Tutorial - code examples http://www.java2s.com/Tutorial/MySQL/CatalogMySQL.htm Very nice clear tutorials for doing things in MySQL Java2s.com : 2008

MySQL Tutorial - from the beginning http://www.astutecomputing.com/tutorials/mysql/ The basics of using php with mysql. Astute Computing : 2008

MySQL Tutorial at Tizag http://www.tizag.com/mysqlTutorial/ Pretty clear beginning tutorials for MySQL Tizag : 2008

Main Sites

MySQL http://www.mysql.com/ Home of MySQL. Ifyou are using for development, you probably want to download the 'community server' version mysql.com : 2006

MySQL 5.0 Reference http://dev.mysql.com/doc/refman/5.0/en/ Everything, including installing, backup, etc, as well as basics. With a tutorial mysql.com : 2008

MySQL at SourceForge http://sourceforge.net/projects/mysql/ MySql project at SourceForge, with downloads, project info. sourceforge.net : 2006

What is MySQL? A Visual Definition http://idealprogrammer.com/databases/mysql/what-is-mysql/ Introduction to MySQL with images and videos Ideal Programmer : 2007

backup

Backing Up With mysqldump http://www.sitepoint.com/article/backing-up-mysqldump The mysqldump utility comes with MySQL. Several examples using mysqldump, including the backup of your database to a file, another server, and even a compressed gzip file. Mitchell Harper : Feb 2002

Backing up with phpMyAdmin http://codex.wordpress.org/WordPress_Backups#Simple_Backup A tutorial with screenshots, for backing up your MySQL database through phpMyAdmin. This is written for WordPress, but applies to any MySQL database. WordPress Codex : 2009

clients

Client-side Overview http://www.mysql.com/doc/en/Client-Side_Overview.html Overview of the mysql program. mysql.com : ?

phpMyAdmin http://www.phpmyadmin.net/ web front end for mysql phpmyadmin.net : ?

rekall http://www.rekallrevealed.org/ KDE front end for databases rekallrevealed.org : ?

date and time

Date/time functions http://http://www.zend.com/tips/tips.php?id=97&single=1 Using unix_timestamp() for date comparisons nageld : 2000-04-13

Doing time with mysql http://www.unixreview.com/documents/s=8472/ur0308h/ Discussion and examples of mysql date/time functions Russell J.T. Dyer : 2003-08-01