Loading ...As a continuation to a previous blog post last week and inspired by Kedar I have created a small script to export tables, stored procedures, functions and views into their respective file. It works for multiple databases where you can specify a list of databases too and although things like events, triggers and such are [...]
Archive for the ‘Mac OS’ Category
mysqldump each object separately
Posted: 12th August 2010 by Darren Cassar in Linux, Mac OS, MySQL, OS, SolarisTags: dump, mysqldump, stored procedures
0
Make Mac Finder sort folders on top
Posted: 16th December 2009 by Darren Cassar in Mac OS, OSTags: Finder, folders, Mac, sort
Once every so often something bugs me enough to look up and here is today’s bugger! Sorting files and folders in Mac’s Finder by type, folders first! In essence: 1. Select Finder, click on Go from the menu bar and select Go to Folder 2. From the dialog box that opens, type: /System/Library/CoreServices/ and press [...]
Circular Replication Implementation / Testing using MySQL Sandbox
Posted: 28th January 2009 by Darren Cassar in Databases, Intermediate, Linux, Mac OS, MySQL, SolarisTags: circular replication, replication, sandbox
This is a simple mysql circular replication implementation on a single machine (just a proof of concept) which can easily be done on a broader scale. Just be aware of the cons of circular replication which mainly gets down to: once a node freaks out or stops for one reason or the other, it’s a [...]
MySQL Installing: Binary tarball (.tar.gz) *nix based platforms
Posted: 5th January 2009 by Darren Cassar in Beginner, Intermediate, Linux, Mac OS, MySQL, SolarisTags: installation, MySQL, securing
Installing MySQL is quite an easy thing to do, especially when done using pkgs, dmgs or exes. It gets just a tad more time consuming and brain intensive when installing a .tar.gz binary package. It is when you’re compiling MySQL source directly that you’ll need some planning and playing, but the latter is only done [...]