Here’s a nice AJAX file manager. It’s still pretty slim of features in my opinion. For instance, it does not support compressing files and directories in a zip/gzip file before downloading, which is particularly what I was looking for. Otherwise it’s a nice to use file manager for web sites.
Archive for March, 2007
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)
- 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
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
COMMERCIAL APPLICATIONS
- Navicat — avaialble for Mac, Windows, and Linux
- EMS SQL Manager for MySQL
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
On Outlook Express it is not obvious where your data files are actually stored on the computer. Here’s two ways to find them:
- Via Outlook Express
- Start Outlook Express
- Go into TOOLS menu
- Click on OPTIONS
- Go to Maintenance tab
- Click on STORE FOLDER button
- Via Windows Explorer (useful if you can’t run/open Outlook Express for some reason)
- Start Windows Explorer
- Right-click “My Computer” on your desktop and select Explore
- Fast way — Hold down the Windows key on your keyboard (key to the left of spacebar with a flying window icon on it) and then the “E” key (whilst still holding the flying window key). Explorer will start.
- Make sure show hidden files is enabled under Windows Explorer. Go to Tools (Menu) -> Folder Options (menu item) -> Views (a tab) -> Show Hidden Files and Folders (a selector in the list you can see)
- In XP go to C:\Documents and Setting\[User Name]\Local Settings\Application Data\Identities\[GUID number, a long number]\Microsoft\Outlook Express\
- In older versions of Windows (non-XP) –> C:\Documents & Setting\[Your Username]\Application Data\Identities\[GUID number, a long number]\Microsoft\Outlook Express\
Latest Comments