MySQL

From Site5Wiki

MySQL is the only database structure that we use. Its official site offers 10 excellent reasons why it is our choice.

The current version installed is v.4.1.21.

InnoDB Warning: Some servers in the Site5 fleet offer InnoDB tables. InnoDB is not the normal (default) table type used within MySQL. Due to incompatibility with our backup/restore process, InnoDB-based databases are not currently backed up. Customers are able to use InnoDB at their own risk and are responsible for backing up their InnoDB databases.

Subpages:

Contents 1 Learning about MySQL/seeking answers 2 Using MySQL with other programming languages 2.1 Books We Recommend 3 Using MySQL with other languages 4 Using MySQL at Site5 5 Examples of MySQL functionality

[edit] Learning about MySQL/seeking answers

• our scripts and programming subforum
  

• Official Freshmeat page
  • freshmeat/~MySQLBuildTeam

• reference manuals and plugins available from the official site
  • languages for these manuals and plugins: English; Chinese; German; French; Japanese; Portuguese ( ); Russian; Spanish
  • available formats:
    • HTML
    • plugin for Eclipse
    • PDF, in both A5 and A4 paper sizes ( cheat sheet for common paper sizes in .pdf format as well, for easy print-out of the MySQL manual, should you choose to do so — direct link to .pdf file)
    • RPM
    • CHM
    • Unix and Linux man pages
      

• MySQL.com provides example databases to use for learning purposes, so that you don't have to learn as you go with your own, valuable data. You can download a zipped .sql database of world information, and toy with it as a learning tool.
• Learn SQL by Using PHPMyAdmin, by Marc Delisle:

This tutorial is aimed at programmers, analysts, and designers of dynamic Web sites who want to learn the basics of SQL. I will use the MySQL database server and its powerful phpMyAdmin interface. The latter is an excellent tool for learning SQL.

• MySQL cheatsheet thanks to ilovejackdaniels.com — also on Flickr ( feed for all of his cheatsheets)

[edit] Using MySQL with other programming languages

--aka, integrating it and expanding it, using other programming languages available to Site5 customers:

• Using MySQL with Perl

• Using MySQL with PHP
  • PHPMyEdit:

    Instant MySQL Table Editor and PHP Code Generator

    • download
    • download documentation
• codegrrl.com -- help with PHP and MySQL

  taking the grr out of coding!

• Using MySQL with Python

• Using MySQL with Ruby, Rails, and Ajax

• Open Tools for MySQL Administrators by Baron Schwartz -- includes PHPMyAdmin in his article

[edit] Books We Recommend

Core Web Application Development with PHP and MySQL, by Marc Wandschneider ISBN 9780131867161 :

• Find this book at O'Reilly
• Find this book at Barnes & Noble
• Find this book at BooksPrice
• Find this book at InformIT
• Find this book at Powells' Books

[edit] Using MySQL with other languages

--aka, localization:

• MySQL character collation: the languages available for actual database storage/data
• PHPMyAdmin interface languages: languages available for PHPMyAdmin, MySQL's GUI interface/control panel

[edit] Using MySQL at Site5

• Add, remove, or modify databases, and/or database users, using SiteAdmin or WHM
• Add, remove, or modify databases, and/or database users, using a remote method
  

[edit] Examples of MySQL functionality