Tools & Utilities Database Tools

Using cron, mysqldump (included with MySQL) and gzip, this script will take daily weekly and monthly backups of your MySQL databases. Daily and Weekly backups are automatically rotated. Output log can be emailed to whoever is resposible for maintaining the backups. Can create a single backup file for all databases on a server or a seperate backup file for each backup. Plus a number of other features. See changelog in the script for full change history. Rememebr to rate it.....
(show more)
(show less)

WebMerge generates static HTML pages from your exported database. Build catalogs, ezines, contact lists, image galleries and more, quickly and easily. Works with output from nearly any database or spreadsheet, including Microsoft Access, FileMaker Pro, Panorama, AppleWorks, and Excel. Use your favorite HTML editor to design custom templates for your index and details pages. WebMerge also lets you save its settings to a file that can start generating pages by just opening it, completely automating your workflow....
(show more)
(show less)

I've faced issues in the past, particularly with free or eBay webhosts, where the server just "disappears," leaving me with little or no data from my website. As a lesson learned from these mishaps, I've created a set of scripts to ensure that my data is always backed up. This shell script backs up any or all of your databases and emails and/or FTPs them over to you. With cron, you can have this process automated, leaving you with regular backups, as well as a piece of mind....
(show more)
(show less)

EMS SQL Manager for MySQL is a powerful tool for MySQL Database Server administration and development. MySQL Manager works with any MySQL versions from 3.23 to 5 and supports all of the latest MySQL features including views, stored procedures and functions, InnoDB foreign keys, user-definable functions, transaction-safe tables, new MySQL 5 Authentication Protocol, MySQL 4.x user privilege extensions, charsets and collations support for databases and tables. It offers plenty of powerful tools for experienced users such as Visual Database Designer, Visual Query Builder, and BLOB viewer/editor to satisfy all their needs. MySQL Manager has a new state-of-the-art graphical user interface with well-described wizard system, so clear in use that even a newbie will not be confused with it....
(show more)
(show less)

Navicat MySQL GUI is a leading MySQL management tool which features an intuitive interface and provides a set of useful tool to manage and develop MySQL. This Lite version supports SSH and HTTP Tunnel for remote database connection. Navicat full version includes these features: backup/ restore, import/ export data, create report, synchronize database and connect to remote MySQL server, etc. Navicat major features: - Visual Query Builder - - Database transfer from server to server - Data and Structure Synchronization - Data backup and restore - Import/ Export of most popular data formats to and from MySQL - Reporting - Tasks Scheduling and Easy-to-use wizards tool Navicat supports MySQL 5.0 or above and available for Windows, Mac OS X and Linux. Navicat for PostgreSQL is also available at: http://pgsql.navicat.com...
(show more)
(show less)

This tutorial will give you the steps to follow in order to setup a MySQL database replication based on a master-slave scenario.

DBFView - the most popular DBF editor and viewer for Win9x/NT/2000/XP in the world! DBFView is a compact but powerful tool for viewing, editing, and printing DBF-format databases. It supports dBase, Clipper, FoxPro, Visual FoxPro and other DBF formats. In contrast to many analogues, DBFView is completely a Windows9x/NT/2000/XP program. The user friendly graphic makes working with databases simple. Most important parts of DBFView code are written in Assembler, therefore the basic operations performs fast and the .exe file is very small. DBFView uses its own database access tools and does not require external drivers for connection to databases (such as ODBC or BDE) or additional libraries (.OCX, .DLL). The program allows you to add, delete, recall, sort, zap, pack records, view and edit files in DOS or Windows character sets, get detailed database information, export to txt/html/csv/xls/xlsx format, and search in a file. DBFView comes with Installer/Uninstaller, documentation in HTML....
(show more)
(show less)

DBACentral for MySQL is a unique solution for database administration, development and data management. DBACentral for MySQL provides you with easy-to-use graphical user interface for executing all database operations: database structure management, table data manipulation, server administration, PHP forms generation and many more....
(show more)
(show less)

FlySpeed SQL Query is an easy data handling tool for all database users and developers. It allows you to build queries on different database servers without needing deep knowledge of SQL syntax. It performs wide range of data manipulations, such as data export, printing and saving to PDF format. Handy for professionals and essential to newbies, FlySpeed SQL Query includes everything to make your work with data more productive than ever before!...
(show more)
(show less)

Databrid is a browsing, retrieval and manipulation tool designed for the novice to the expert user. Databrid works on MySql and Oracle Database (versions 8 and above although not all functionality in the Browser is available for the lower versions). The core functionality of Databrid revolves around the tabbed areas within the Databrid application. The four main tabs in the main screen of Databrid are: SQL Editor, Browser, File and Jobs....
(show more)
(show less)

Active BI Portal is business intelligence software that provides an integrated solution for designing and deploying reports and web forms over the internet and intranet. Active BI Portal consists of two parts Active BI Portal Manager which works on Windows only and server part which is collection of PHP scripts and can be run on Windows, UNIX or Linux. Active BI Portal works with all major commercial and open source databases....
(show more)
(show less)

Data Loader is a simple yet powerful tool to import and export Data between many common formats. Current Data Loader Ver.3.0 supports MS-SQL, MySQL, Oracle, MS Access, FoxPro, DBF's, CSV & Delimited Files. You can use Data Loader to transfer data from one database format to another database format.Filter columns and specify WHERE conditions. It supports Long Data types. Transfer data without any coding. Now you can also save and Schedule Sessions...
(show more)
(show less)

Universal SQL Editor is a powerful, yet easy-to-use graphical query tool for all database developers. It allows you connect any ODBC compliant databases, such as Oracle, DB2, SQL Server, Sybase, etc., and edit SQL queries and scripts with Intellisense-like code completion, parameter hinting, syntax highlighting, SQL formatting, plus other useful features that allow you to work more efficiently. In additional, query results returned by this query tool supports grouping, filtering, searching, and can also be exported to Excel spreadsheet or as a set of SQL statements....
(show more)
(show less)

SQL Password is a full-featured password recovery solution for MS SQL Server 2000, 2005, 2005 express and MSDE 2000. It can either recover your original password using a number of password recovery methods, such as Brute Force Attack, Dictionary Attack or Smart Force Attack, or the password can be instantly reset to a known one (though the original password will remain unknown)....
(show more)
(show less)

Compare Access Databases with AccessDiff. AccessDiff compares objects with the same name between two databases. It also detects missing objects in either the source or destination. Records are compared by the primary key or the Natural Key. The differences can be printed out in a report or exported to Excel. AccessDiff compares forms, reports, macros, code modules, queries, tables and records. Download a free trial today....
(show more)
(show less)

This script will examine a MySQL database and create a file full of statements to execute on an identically structured database. This will bring the target database into syncronization with the source. It does NOT sync any changes to the database structure. It does check to see if the same record has been changed on the source and destination and gives the option of forcing overwrites or aborting the change to conflicted records. Any changes aborted are written to the error log. Inserts and deletes are also synced. Heavily commented. Read the notes in the code....
(show more)
(show less)