I am not strong with the command line. As such, I rely on PHPMyAdmin to get things done in MySQL quickly. One of the big problems with PHPMyAdmin are the import limitations and timeout issues. In my case, my host's implementation of PHPMyAdmin doesn't even include the import function. In my last post, on upgrading to D6, I described a situation where I really needed to import a database, that I had performed the update on my laptop.

I used PHPMyAdmin to export the database on my live site and plopped it on my desktop. I fired up MAMP and went to MySQL. I created a new database and granted all to a new user on the blank database. I *tried* to import my database--which currently is about 56--and had no joy. I increased the file size and timeout length, but that didn't help me out--I could only get two out of 88 tables to import.

I needed a different solution. In comes BigDump.

I am on a quest for good customer relationship management software. My preference is to find an opensource solution. There are Drupal and Joomla based solutions like Civi-CRM. At some point I'll sit down and set up Civi-CRM and see what I think about it. However, a few days ago I downloaded SugarCRM CE (Community Edition) and created a local install of it. I've started the process of evaluating it.

If you are interested in setting up a local install, in many ways it is similar to setting up a Drupal install. First you need to have MAMP (for a Mac), WAMP (for a Windows box), or LAMP (for Linux) set up on your computer. Do a Google search and you'll find plenty of information on any one of these. Basically, it stands for Mac-Windows-Linux, Apache, MySQL,and PHP.

Next, download SugarCRM HERE.

Next...