Archive

Posts Tagged ‘Mysql’

How to Backup and Restore a MySQL Database

June 7th, 2009 1 comment

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.

VN:F [1.9.22_1171]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)
Categories: General Tags: ,

Generate ER diagram by appliying reverse enginnering technique

June 6th, 2009 1 comment


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 ( :

VN:F [1.9.22_1171]
Rating: 8.0/10 (5 votes cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)

What is PHP?

April 18th, 2009 No comments

First of all i need to say that PHP is a language which you are going to in love with. (That is of course if you are a developer ) PHP stands for PHP: Hypertext Processsor.

To start with it you should have knowledge about basic scripting and HTML language.

PHP is totaly free to use and download that is because it is an open source. Well there are many scripting languages on the earth. PHP is server-side scripting language. It means codes are executing on the server-side not in the client-side.

Thus, clients cannot see your php script, a client can only see pure html content. Now i can say PHP is secure langauge since user cannot see your PHP code. How it works? For instance, a client (user) requests a webpage from your server. Then your server executes php code and returns pure html content to the user. And user have no chance to see what is going on at the server-side.

Extensions : .php, .php3, .phtml

Read more…

VN:F [1.9.22_1171]
Rating: 7.5/10 (6 votes cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)
Categories: PHP, Programming Tags: , ,