Posts tagged mysql

MySQL data dumps done right.

Apr 8th

Posted by dewaldbotha in linux

To dump data in MySQL command line is one of the easiest things to do.  All you have to do is follow these 3 easy steps in your linux command line:

1.  Dump the schema only.  This will  not contain any data, procedures or triggers, but only create info.  This will allow you to easily import your original schema later on.

mysqldump -uroot -proot -d --skip-triggers myDatabase > myDatabase_schema.sql

The -u specifies your username, and must be followed by your username e.g. -uroot. This is the same with your password, -proot.

The -d tells mysqldump to not dump any data in the schema and the More >

, , , , , ,

putting the ‘errrrrrr’ in erlang

Dec 10th

Posted by dewaldbotha in erlang

so for a while i’ve been trying to do a small something, anything in erlang.  got myself pragmatic programming in erlang, setup yaws on my ubuntu machine and downloaded an erlang web framework called erlyweb that seemed to glow with potential.

so, its been about 2 weeks, my fascination with erlang was as short lived as a teenage holiday romance.  the concurrent language which would probably topple all others if the overheads weren’t so much.  erlang has a huge learning curve, don’t think just cause you dabble in a bit of ruby you will pick up this language in one go

i’m sure it will More >

, , , ,

lyme, a stack of scalability

Nov 25th

Posted by dewaldbotha in erlang

so last week i’ve been to a conference in good ol’ silicon valley -

a lot of focus on scalability and performance.  that being said – i’ve decided to be proactive and try out a stack i’m totally unfamiliar with, but apparently with great potential.

lyme – linux, yaws, mysql, erlang

linux - the tried and tested platform, open-source, and where all good things start.

yaws - yet another web server written in erlang, supposedly outperforms apache with throughput and parallel sessions.

mysql – i’m just a big fan, what can i say

erlang -  the language, created as a general purpose, concurrent language

so finally i got my lyme stack running More >

, , , ,