MySQL is a popular database system used in the backend of a huge number of web applications. Just about every database driven PHP application I have seen has MySQL working alongside it. There are various tools available (usually provided by your web host) for managing MySQL databases online (phpMyAdmin for instance). I have found that having a desktop manager can be very useful. I’ve found it particularly useful when I need to manually edit data within a range of tables and records.
The following tools are worth checking out if a desktop MySQL manager is what you want:
OPEN SOURCE
- HeidiSQL (formally SQLFront — an old favorite of mine)
HeidiSQL is an easy-to-use interface and a “working-horse” for web-developers using the popular MySQL-Database. It allows you to manage and browse your databases and tables from an intuitive Windows® interface.
With HeidiSQL you will also be able to
- generate nice SQL-exports
- synchronize tables between two databases
- manage user-privileges
- import text-files
- export table-data as CSV, HTML and XML
- browse and edit table-data using a comfortable grid
- batch-insert ascii or binary files into tables
- write queries with syntax-highlighting (next version will have also code-completion)
- monitor and kill client-processes
- and much more
- MySQL Administrator and MySQL Query Browser (from the makers of MySQL)
Avaialble for Mac, Windows, and Linus
I find the Heidi system to be easier to use
COMMERCIAL APPLICATIONS
It’s important to backup content and databases we have online. Whether you run a blog (such as Wordpress) or other applications on a website, there are often many individual files to download if doing a backup manually via FTP. This can be slow and tedious if a quick backup is what you want (and why wouldn’t you?). phpMySQL has build in backup functions if you need them, although the following tools provide an easy one-stop solution.
Check out the following great tools for backing up your site content and MySQL databases.
- phpMyBackup Pro is a very easy to use, free, web-based MySQL backup application, licensed under the GNU GPL.
You can create scheduled backups, manage and restore them, download or email them and a lot more!
Major features:
- backup of one or several databases with or without data, table structure, …
- three types of compression (no compression, gzip or zip)
- scheduled backups (by a small PHP script which must be included in an existing PHP script)
- interface for management of the backups (viewing, restoring, downloading, deleting)
- backup directly onto FTP server and sending of backups by email
- platform independent - only webserver and PHP needed to run e.g. on MS Windows, Linux or Mac
- shell mode (to use manually or by cron script)
- backup of whole file directories (on a FTP server).
- backup databases from different accounts on several MySQL servers
- one installation can be used for all MySQL users of one MySQL server (used by webhosters)
- highest security through two alternative login methods (HTTP or HTML authentication)
- easy to use interface and very easy to install
- several language packages available
- PHP WebSite Backup
- PHP MySQL Backup
Published on March 26, 2006
in MySQL.
Here’s a great (free) tool for managing the backup and restoration of mySQL databases. It runs on your website, is accessed over HTTP, and is free. It works well as far as I can tell.
phpMyBackupPro - the MySQL backup tool :: Features
Welcome to phpMyBackupPro
Here on the offcial homepage you will find all informations about phpMyBackupPro (pMBP).
phpMyBackup Pro is a very easy to use, free, web-based MySQL backup application, licensed under the GNU GPL.
You can create scheduled backups, manage and restore them, download or email them and do a lot more!
Latest Comments