Category Archives: Mysql Development

Mysql enhancements, shortcuts and practise.

MAMP v2.0+ and Apache Virtual Host Set Up

A colleague of mine was having some trouble setting up virtual host’s with his new installation of MAMP recently. So I decided to sit down …

View more

Tagged: Leave a Comment

Opening Up For Advice

Over the last year I’ve been constantly if not more than constantly trying to ask myself, are we doing things the right way? There are …

View more

Tagged: Leave a Comment

Connecting To Server With Putty Using SSH Keys & Port Forwarding

Quick and dirty tutorial to connecting to a remote server with ssh keys and putty. Firstly you need to download putty and puttygen which can …

View more

Tagged: Leave a Comment

Mysql Dump Ignore Tables And Rsync To Remote Server

Not having had huge experience working with mysql dumping and rsync. This afternoon I was faced with the task of taking a backup of one …

View more

Tagged: 4 Comments

Mysql Dumping / Uploading a file or files via terminal and SSH

Just something I found myself looking up today so that I can do everything from the comfort of my little terminal window. I wanted to …

View more

Tagged: Leave a Comment

How to find duplicate rows of a table in sql

This is a nice quick easy way to find duplicate rows in your database based on one field. So say for instance id like to …

View more

Tagged: 1 Comment

One line unzip and mysql dump to database

After some advice on my last post I thought id make another post with a revised version of my other post about the same topic. …

View more

Tagged: Leave a Comment