Sequel Pro: Free MySQL Management Tool For Mac OS X

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.
sequel-pro

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.

Continue reading

Free Open Source Ajaxed MySQL Table Editor, easy to create admin pages.

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.

mysql-table-editor

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.

Continue reading

Useful List of of MySQL Cheat Sheets & Free Quick Reference Guides, Best of designers, developers & programmers,

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

wwwaddedbytescom_cheat-sheets_mysql-cheat-sheet_

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

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.

Continue reading

Open Source Application for taking scheduled backups of MySQL databases & FTP files

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.

phpMyBackupPro

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.

Continue reading

Backup2Mail: Now Easily Backup And E-Mail MySQL Databases Automatically

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.

Backup2mail

It requires PHP 4.1+ to run & for scheduling the script, cron jobs (Unix/Linux) or a scheduled task interface (Windows) is required.

Continue reading