Sequel Pro is a free MySQL management tool for Mac OS X.
It offers full table management (including indexes), supports MySQL views, imports/exports from SQL/CSV files & compatible with MySQL 3/4/5 databases.
The application supports SSH tunnel connections besides standard local & remote connections for reaching databases behind firewalls.
It can connect to multiple databases at the same time, offers automatic syntax highlighting for your custom queries, supports ~30 different encoding options & much more.
Mysql Ajax Table Editor is an open source web application for easily editing MySQL tables & creating admin pages almost instantly.
Besides the standard “add, edit, copy, delete, view” functionality, records can be paged, searched & exported to CSV.
It is possible to JOIN multiple tables to generate a custom view (+ apply any other functions on this view) with the help of a configuration file. Also, column names displayed can be customized for a better presentation.
Webyog, a company who creates innovative database tools.
- 3 SQLyog Enterprise – MySQL GUI ($99/each)
- 1 MONyog Unlimited Servers – MySQL Monitoring Tool ($999/value)
Details on “how to win the free licenses” can be found at the bottom of the post, but before that:
The following article is a list of MySQL Cheat Sheets & Quick Reference Guides for Web Designers, Web Programmers, Coders & for Web developers for Quick coding with MySQL. These are very helpful for those of us who haven’t memorized all of the MySQL commands. This compilation of MySQL cheat sheets should help speed up your web development. Please feel free to comment on MySQL quick reference guides that we have missed and / or even better yet submit your MySQL quick references guides & cheat sheets here.
Added Bytes : MySQL Cheat Sheets
The MySQL cheat sheet is designed to act as a reminder and reference sheet, listing useful information about MySQL. It includes a list of the available functions in MySQL, as well as data types. It also includes a list of MySQL functions available in PHP, and a list of useful sample queries to select data from a database. A description of what is on the cheat sheet follows, or if you are impatient, you can go straight to the full size MySQL cheat sheet.
CSE.edu : (My)SQL Cheat Sheet
Here are the most commonly used SQL commands and the most commonly used options for each. There are many more commands and options than listed here. In other words, the syntaxes as I have listed them are far from complete. See the links at the bottom for more complete syntaxes and more commands.
phpMyBackupPro is an open source application for taking scheduled backups of MySQL databases & FTP files.
It offers a flexible usage as backup jobs of multiple databases/files from multiple servers can be scheduled, completed & compressed.
Backups can be taken to any location including remote FTP servers.
Besides taking backups, phpMyBackupPro can restore & e-mail backups. As a third option, it is also possible to download them.
Almost every web designer/developer, one way or another, faces data loss & experiences the importance of taking regular backups.
Backup2Mail is a free PHP script which easily prevents this problem by automatically backing up MySQL databases & e-mailing them to a given address.
It requires PHP 4.1+ to run & for scheduling the script, cron jobs (Unix/Linux) or a scheduled task interface (Windows) is required.