I have spent many hours dealing with this on my own so I figured I would write down the solution so I wouldn’t have to research everything again. If you are running a 64 bit system and need to use *.MDB drivers you need to make sure the following is set:
run: “regsvr32 odbcconf.dll” from c:\windows\Syswow64\
Edit ODBC using: C:\WINDOWS\SysWOW64\odbcad32.exe
That will save you many hours of frustration with x64 systems
I have had to do this a lot lately with all the database work I have been doing so I figured I would write this down before I forgot about it.
If you need to restore a database from a .sql file here is the command:
mysql -h hostname -u username -pthepassword databasename < dumpfile.sql
If you need to dump a database to a file (for automated backup purposes) you can use this command:
mysqldump -h hostname -u username -pthepassword databasename > backup-file.sql
These can be very helpful when doing database work
Below are some (7) Database web sites that you can use to easily create forms and collect data online. I am a huge fan of Zoho Creator and currently use that to manage my work log at work as it is quick and dirty and anything is better than Access!
Blist’s goal is to fool you into forgetting that underneath the glossy interface, there’s a relational database that the average user doesn’t know much about. I’ve always though that a great interface with average features is better than an app with great features and an average interface. I’m not talking aesthetics, either—but if something is designed well enough that it saves me both time and stress, I’m happy.
In terms of interface, Blist works somewhat like everyone’s favorite basic database, the spreadsheet. Displays are filtered using what’s called a lens—that and the form designer make it clear that Blist’s goal is to create “the database for the rest of us.”
Wufoo isn’t so much about a database that you populate: it’s a service that allows you to create quite attractive HTML forms so you can collect information from visitors to your site, without needing to learn a programming language to do it.
The advantages of an easy-to-use form designer is obvious in business when you wish to collect as much information from customers and clients as possible. In your personal life, a variety of applications exist but my favorite was when a friend used a web form to allow his Gmail contacts to fill in their address book entry for him after he lost their phone numbers.
Zoho Creator basically allows you to create simple database applications using a flashy AJAX interface and a lot of wizard goodness. It comes with plenty of templates, so you don’t need to start from scratch. There are free options, though they’re pretty limited—on the free Personal account, you can only create up to five applications, but that may suit your needs for a long time to come.
Some of the best features of Zoho Creator include the ability to embed your application in your Web site, and if you’re an advanced user, you can go beyond the wizard-style database designer using Zoho’s Deluge scripting language.
Coghead is another offering that allows you to visually build web applications and goes far beyond simple forms. Of course, without becoming a programmer you can’t create any new web app that pops in your head, but Coghead makes it possible to realize quite a broad range of applications—especially databases for a variety of purposes—using the simple power of drag and drop.
Coghead also has start applications, like Zoho’s templates, including issue trackers and a CRM that you can expand on. Don’t reinvent the wheel.
Coghead features a great visual workflow editor that allows you to add functionality beyond data capture without using a scripting language. This is an excellent choice for those who want powerful business-oriented applications with a certain level of complexity but aren’t interested in programming at all.
Dabble DB is another easy database application builder, with a reputation for being quick and easy to use—you can have a finished application ready in minutes flat. I didn’t have any trouble getting an app ready in minutes with the other web sites I tried, but Dabble DB’s process did seem to flow a little faster even if it didn’t quite have the same aesthetic pizzaz.
If you’re looking for a free service, give Dabble DB a skip. The only free option makes your content Creative Commons and visible to everyone and there’s nothing inherently wrong with that, but if you’re looking to build a database application chances are it’s to store private information like your friends’ or clients’ contact details.
TrackVia has a strong focus on taking your spreadsheets from Excel or what have you, and allowing you to turn them into powerful databases with its web service. It then allows you to create web forms and run email marketing campaigns from within its web app, so it’s got a very strong emphasis on business.
Furthering the suspicion that TrackVia is not for the personal user is the fact that there are no free accounts on offer. The cheapest plan with a monthly fee of $30 does offer quite a bit of room for your money—150,000 database records and 1 GB of file storage.
WyaWorks is certainly not the prettiest web app on the block, but it has a slightly different focus on essentially the same thing that many of these start-ups are tackling: WyaWorks is about creating database applications for collaboration.
That focus on collaborative work is a definite plus and could be a selling point for many businesses, but for anyone to take it seriously, the programmers behind this app need to put more thought into the way it looks. The design is bad, but the interface is worse—if there’s one thing that this thing needs, it’s a coat of paint and a more usable and intuitive layout. Nobody would buy products from a handwritten catalogue, after all, and the web is no different (especially when you’re after business customers).
FormAssembly is a form designer with a bunch of great features that are useful for the personal user, the business user and everyone in between. It provides email and RSS notifications, statistics including graphical charts and Excel export, as well as e-commerce features such as PayPal and Salesforce integration. You can use FormAssembly for just about anything that involves forms, including order forms.
While the focus on form designer apps is to get information from others, there’s nothing stopping you from using a FormAssembly or Wufoo form as a pseudo-database where you use the form to create records yourself.
There is a free version, though your forms will be ad-supported and there’s no auto-responder, secure forms nor file upload. In short, the features that business-oriented users will want to shell out for—I think the free plan works fine for the average user.
Sometimes I find myself coming across strange file formats I want to convert and converters aren’t always free. It just so happens this one is and has no limit on the lines you want to convert. It will take a .DBF file and convert it to .TXT, .XLS, .CSV and a bunch of others. This came in super handy especially for our statistics project. Here is their official web page
Kexi 
There have been a lot of people over the last few months who have been quite clear in stating that they do not feel Open Office Base is a solid replacement for Microsoft’s Access. My answer to these individuals is to look into Kexi instead. It offers a solid, consistent UI, an active community of users and a future that looks pretty darn bright to me. I see this cross-platform data management application as a means of freeing your company from an otherwise expensive alternative.
VirtualDub
Video editing for Windows is certainly not limited to the Windows Movie Maker. VirtualDub allows its users a clean, user –friendly tool to capture, edit and produce their videos without sacrificing quality or spending any money on an application with unneeded features. Thanks to VirtualDub, which rovides decent documentation and frequent revisions, this is one of the better, yet lesser known open source video editing applications for the Windows OS.
WinMerge 
Personally, I am shocked that this program is not OEM released into every Windows desktop released from the factory floor. WinMerge does a fantastic job at helping to manage projects, making sure that the data inside the file is always the newest, not just the file itself. For example, take two of the same files and use the program to compare them. You’ll see, instantly, using colors to guide you, which syntax has changed and which is missing from one file vs. another. This is a have must for programmers and web designers.
Pentaho BI Suite 
Business intelligence is not a minor issue for most companies – having a solid open source application that can legitimately compete with the big boys is nothing to sneeze at. Pentaho Open BI Suite provides businesses with enterprise class tools to help in this critical data gathering. Reporting, analysis, dashboards and process management: the Pentaho suite does it all.
I have not heard of this before until today where they have made some headlines in the blogs that I read. This is an open source business intelligence tool that includes a server, developer, and an ETL tool. Of course the have the paid model which allows you some support and access to some developed applications to run this stuff but this sounds like a solid idea that might take off really well. It has a J2EE background and a JBoss server behind it.
This is a great front end to MySQL and imports and exports super easy. Navicat
So this is the best third party apps I know about for MySQL, MS-SQL Server, Postgre, and Firebird if you are into the third party apps for Windows. I like these because they have code completion which makes writing SQL much faster and accurate. All are free applications from http://www.sqlmanager.net/
EMS mySQL lite
EMS SQL Server lite
Well after learning from about 3 months of setting up web servers and all the applications to run a decent website I finally stumbled on this one. This program is awesome it is an all enclusive Apache, MySql, PHP, and Perl installer. Hense the name the x stands for cross platform it runs on linux, windows, solaris. Some pretty nerdy stuff but cool check it out. XAMPP
