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 was playing with the export features in Plaxo. I was looking to invite/link from my address book to Facebook. The export was simple. I downloaded a vCard from Plaxo and then imported the contacts in the vCard directly to FB.

Then the import tool in Facebook made exceedingly simple to check who I know that was already on FB and send invites to everybody who wasn't. It was slick and easy.

Powered by Qumana