Tag Archives: tutorials

Importing a large .sql database file into MAMP

This article written by www.fatheaddesign.com helped me out so much and is cleanly written I had to re-share it. Full props go to Fatheadesign.

The original article can be found here http://www.fatheaddesign.com/808/importing-large-sql-files-into-phpmyadmin-under-mamp/

If you are struggling to import a larger database using MAMP you may have seen this image below, if you have you now how frustrating this can be.

I can across this when trying to copy my works WordPress install and set up a local server.

Below is copy and pasted directly from http://www.fatheaddesign.com/808/importing-large-sql-files-into-phpmyadmin-under-mamp/



Screen shot 2013-01-11 at 4.50.43 PM

This happens to me quite often, and I finally found a workaround for this within my local MAMP dev environment.

1. Open up the config.inc.php file within the phpmyadmin dir with your favorite code editor. In your local MAMP environment, it should be located here:

Hard Drive » Applications » MAMP » bin » config.inc.php

2. Do a search for the phrase $cfg[‘UploadDir’] – it’s going to look like this:

$cfg['UploadDir'] = '';

3. Change it to look like this:

$cfg['UploadDir'] = 'upload';

4. Then, within that phpmyadmin dir, create a new folder & name it upload.

5. Take that large .sql file that you’re trying to import, and put it in that new upload folder.

6. Now, solidsthe next time you go to import a database into phpMyAdmin, you’ll see a new dropdown field right below the standard browse area in your “File to Import” section, like this:

Screen shot 2013-01-11 at 5.21.45 PM

Select that dropdown, and your file will show up right there. Hilight the db, and hit “Import” – and you’re golden!

How to Export a Squarespace blogs data and import it into a WordPress.com blog


EDIT:  After a massive response to this post i have a few people to do this for them as they do not know how to install servers or dont have the time, so if you have a need for this then get in contact with me and we can work it out. Thanks for all the responses!

I was recently asked to export a clients blog posts and data from a squarespace account and import it into a WordPress.com blog. I was thinking this would be a easy job but not knowing how to do it i turned to google for the answer, I found, i thought, what i was looking for.

I easily exported the squarespace data and went to the wordpress site to import, it seemed to work but nothing would actually import,it just sort of hung there.

After a lot! of googling I still could not find any reason for this not to work and no one seemed to have a answer.

After many failed attempts and yet seeing ( on youtube ) people easily importing Sqaurespace data it  occurred to me that maybe WordPress.com blogs and WordPress.ORG blogs were very different animals and perhaps Wordpress.COM blogs simply are not able to import the blog data from a Squarespace account

Finally, after not finding anyone with the answer I came to this slightly complicated but workable solution to get Squarespace data out and into a WordPress.com blog

Below is a brief step by step of what I did, if you understand all the steps already, great!, if not check back soon and as I will be posting a detailed tutorial with screenshots as soon as I can.

  • Log in to your Squarespace account and download you blog data ( see Sqaurespace tutorials )
  • Install and start Mamp or another internal/test server 
  • Create a Mysql database for WordPress
  • Download, install and create a Wordpress blog, any details will do ( you can delete this blog straight after )
  • Log in to the WordPress blog that you have just created on your test server
  • Go to Dashboard and select Tools>Import
  • Click ok to install import plugin and select the import Movable Type and TypePad option
  • Select the downloaded Squarespace blog data file and select import
  • Check Posts to confirm the all the blog data has imported correctly, each post will be listed if successfully imported
  • Export the Wordpress( on test server ) blog data as a WordPress data file type ( Tools>Export )
  • Log back into your Wordpress.COM blog
  • Import the newly exported Wordpress data ( from test server )
  • All Done.

I hopes this helps at least one person out there, Let me know if thats you and post a comment.

Or even better if im totally wrong and you have a better way please let me know


How to change the loading screen of a Kenwood DNX4210BT


To change the loading screen on the kenwood DNX4210BT make sure that you are on the main menu and that you have a USB flash drive plugged into the usb cable or port, on the USB drive you will need the image you want to use saved in the Root folder, by that I mean that the image must not be in any folders it has to be on the main part of the disk, you will also need a pick or something else with a sharp end like a bit of wire or paper clip

The image needs to be a minimum size of 480px horizontal by 234px vertical, the images can be bigger as the kenwood system will shrink it for you

The images must be also be in ‘jpg’ or ‘bmp’ or filetype With the USB plugged in and at the main menu, press and hold the ‘TEL’ and the ‘MENU’ buttons, then while holding click with your pick the red downward facing triangle above the ‘menu’ button

Keep hold of the ‘TEL’ and ‘MENU’ buttons and wait for the red triangle and the screen to flash( a grey flash ), then release the buttons Select ‘OEM’ from the list then select the image you want to load

Select ‘WRITE’ and wait for the file to be written

Then click the red triangle once more to reset the system While its resetting you can remove your USB drive

Watch the screen for you new loading image