Samet Kilictas’s Blog

To make a database backup using the MySQL command-line utilities, execute the following command:

$ mysqldump -u username -p –opt dbname > dump.sql

It will ask you for password because we used -p paramater over there. If the MySQL programs are not in your path, you will need to manually specify the location of the mysqldump program:

$ /path-to-your-mysql-bin/mysqldump -u username -p –opt dbname > dump.sql

Download the dump.sql and keep it in a safe place (CDR, Zip disk, etc).

If you need to restore your database, you can do so like this:

$ mysql -u username -p dbname < dump.sql

This is the simples way to restore and backup your database.

Yesterday, i needed to generate an ER diagram for one of my databases that i am working on. Well, i didn’t meet with Mysql Workbench visual database tool before. It made my day. MySQL Workbench is a visual database design application that can be used to efficiently design, manage and document database schemata. And it is available under GPL license. This application is allowing you to generate a diagram for a database using its reverse engineering tool. And the good thing is after generating process you may modify it anyway. I think i am going to use this application in future. For detailed information go in this link below :

http://dev.mysql.com/downloads/workbench/5.1.html

Keep in touch foxes ( :

Since i am coding with codeigniter framework on gedit, i was looking for snippets for codeigniter on gedit

download gedit snippet for codeigniter

By the way if you want to make your gedit more useful for programming surely you may add some third party plugins as many as you want or simply just active default plugins. Idea is that firstly download a plugin then extract its content to ‘~/.gnome2/gedit/plugins/’ directory. Once you have installed the plugin you want, you need to enable it via Edit>Preferences and then the Plugins Tab. Such as;

- Snippets
- Class Browser
- Bracket Completation
- Character Map
- Embedded Terminal
etc..

You can basicly find out third-party plugins by clicking on this link

This is a wonderfully informative Amazon update based on Joachim Rohde’s discovery of an interview with Amazon’s CTO. You’ll learn about how Amazon organizes their teams around services, the CAP theorem of building scalable systems, how they deploy software, and a lot more. Many new additions from the ACM Queue article have also been included.

Amazon grew from a tiny online bookstore to one of the largest stores on earth. They did it while pioneering new and interesting ways to rate, review, and recommend products. Greg Linden shared is version of Amazon’s birth pangs in a series of blog articles.

Information Sources

(continue reading…)

TDD => Test Driven Development
Continuous Integration
Refactoring
Design Patterns
eXtreme Programming *
agile design
SOAP, REST