Dewald Botha
open source web thoughts
open source web thoughts
Apr 8th
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 >
Nov 25th
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, erlanglinux - 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 >