Archive

Archive for June, 2009

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)