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

Web sites that help you manage and collect data easily with databases and online forms.

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